I believe the saying is "once you go CLOB you never go back"...that's what I think it is anyway....either way...you may need to create a new column in the db, copy contents, delete clob...change the column name (can you do that?)...then update remedy with a smaller value...
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 28, 2007 1:49 PM To: [email protected] Subject: Re: ORA-00904, ORA-00932 on ARS 6.0.1 Thats exactly what we found. The field was switched to a CLOB and we are not sure if we can get it back to a varchar. Everytime I try to change the data input length back, I get the ORA error after it freezes my machine for a few minutes. Here are the lines leading up the error. I'm not sure if this is normal, but the field that is always giving us the error is not even listed in the log. <SQL > <TID: 000006> <RPC ID: 0000000185> <Queue: Escalation> <Client- RPC: 390603 > <USER: AR_ESCALATOR > /*Mon Sept 24 2007 11:49:22.3599 */SELECT T168.C1, T168.CI FROM T168 WHERE (((('Remedy' = T168.C200000003) AND ('Problem' = "T168.C200000004)) AND ('Problem" = T168.C2000000005)) AND (' ' =T168.C100000000)) ORDER BY ASC 1 <SQL > <TID: 000006> <RPC ID: 0000000185> <Queue: Escalation> <Client- RPC: 390603 > <USER: AR_ESCALATOR > / *Mon Sept 24 2007 11:49:22.3942 */***ERROR *** ORA-00932: Inconsistent datatypes: expected - got CLOB On Sep 28, 3:04 pm, Axton <[EMAIL PROTECTED]> wrote: > Changing the length of a character field from <= 4000 to > 4000 > characters on Oracle changes the data type from a varchar to a clob. > > Can you post the sql logs that lead up to the error? Probably 3 lines > leading up to the error will be enough. > > ORA-00904 seems to be unrelated, but the logs should make it evident > what the problem is. > > Axton Grams > > On 9/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > 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 > > atwww.arslist.orgARSlist:"Where the Answers Are" > > ______________________________________________________________________ > _____-____ 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
