I saw something similar on an AI Transformation (MSSQL) that was performing a similar function. I, too, thought it was a space issue. I removed one condition (order by) from the SQL query, and it worked.
Rick On Nov 3, 2015 2:33 PM, "Ben Chernys" <ben.cher...@softwaretoolhouse.com> wrote: > ** > > Hi All, > > > > ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2 > > > > Interesting trace on this one. The query worked fine the first go (there > is no query argument to this f) and ARGetMultipleEntries() picked up 100 > records from AST:BaseElement. > > > > On the second go of 100 records, the SQL log shows a single SQL repeated > 100 times for each record, and then (for the status history): > > > > ARGetMultipleEntries ==> <SQL > <TID: 4253898496> <RPC ID: 0002163601> > <Queue: List > <Client-RPC: 390620 > <USER: > Demo > <Overlay-Group: 1 > > > ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT > entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7 > > U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId > IN) > > ARGetMultipleEntries ==> <SQL > <TID: 4253898496> <RPC ID: 0002163601> > <Queue: List > <Client-RPC: 390620 > <USER: > Demo > <Overlay-Group: 1 > > > ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR > *** ORA-00936: missing expression > > > > Interestingly, I think it may be related to not enough space allocated for > the IN expression – as each Id will be more than 15 bytes. More > interestingly, this table has 0 records. > > > > The table in Q (schemaid = 1572) is AST:BaseElement – an infamous join J > > > > So, has this been fixed in a server patch? Has anyone else seen this? > > > > Cheers > > Ben Chernys > > www.softwaretoolhouse.com > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
