ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

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

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

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" wrote: > **

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: November-03-15 15:36 To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression ** I saw something similar on an AI Transformation (MSSQL) that was performing a similar function. I, too, thought

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

nt: November-03-15 15:56 To: 'arslist@ARSLIST.ORG' Subject: RE: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression Thanks Rick, but that can’t be it. I am doing NO SQL queries. ONLY an ARGetMuplipleEntries() call – which has no query terms at all – so there’s nothing

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

To: 'arslist@ARSLIST.ORG' Subject: RE: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression More info: Each AST:BaseElement is picked up with “(E0 = '368' and E1 = '120' )” and the successful pick up of the Status History seems to be missing