sql logs will be more revealing Axton Grams
On 9/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
