I have looked at the logs and its telling me that the error is coming from one specific ticket. But the error will repeat again on a brand new ticket. The user is showing up as AR_Escalator and I'm not sure if that is significant. The ORA-00932 error is stating "Failure during SQL Operation to the database: ORA-00932 inconsistant datatype expected -got CLOB"
I'm trying to work with the Oracle guys but they are just as lost as I am on this issue. All because the other admin changed the datatype on the fields property to 0. On Sep 28, 11:23 am, Howard Richter <[EMAIL PROTECTED]> wrote: > Axton, > > As always is correct, turn on sql and api logs, that might pin it down. > > hbr > > 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 atwww.arslist.orgARSlist:"Where > > the Answers Are" > > -- > Howard Richter > > Remedy ServiceDesk Manager > CedarCrestone Managed Services Center > > [EMAIL PROTECTED] > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are"- Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
