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"
