Hello All, I am trying to fix a problem with the Solution Summary field on the Helpdesk form. The admin before thought he could make that field unlimited characters so he set the data input length to 0 under the database tab on field properties. Since he did that, he cannot use that field or the possible solutions button. We now get an ORA-00932 error.
So I decided to duplicate the problem on the test server and see if I could delete the field and recreate it. I imported the good bad helpdesk form onto the test server. I tried to delete the field but it will not let me. So then I just hid the field and created a new one. When I save the form, on the admin tool it shows that its saves, but it only did it on one view regardless that its set to go on all views. I made the changes again on each individual form and it saves somewhat reluctantly. Well when I open the helpdesk form on the user client it doesnt' show the change. When I look in the ARERRR.log, I show a bunch of errors that state " Failure during SQL opreation on the database (ARERR 552) ORA-00904: C12312312: invalid identifier" errors for serveral fields on the helpdesk form. It seems as if the Oracle database and the Remedy server are not connecting correctly. I just can't figure out how to fix this now. Any help or advice? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
