Some of our uers are getting the error - Exception: DBD, ORA-00920: invalid relational operator while they refreshing the report. The Query condition we are using is
Account Number In list of the query result (C:\xyz.xls.Org Number)The xyz.xls file has been placed in a common shaed location and all the users have access for this xls sheet.
Any ideas?
-Dora.
dora (BOB member since 2008-04-09)
Has anyone got it open?
Business objects needed exclusive access from what I remember.
I copied the xls sheet onto my computer and repointed (in there is no chance to open by someone), but still the same issue.
dora (BOB member since 2008-04-09)
How many values are you trying to supply to your In List, Oracle has a limit of around 250 from memory?
Mak 1 
(BOB member since 2005-01-06)
Tank you, Mak
Your suspect is correct. No. of values causing the issue. my list contants ~6000 values. If reduce down to 1027, the report is refreshing fine, beyond that it’s throwing an error. Is there any parameter setting which can accept more values?
-Dora?
dora (BOB member since 2008-04-09)
You uses Oracle database, right?
The problem that you are experiencing (the fact that IN operator can not accept more than 1000 or so values) is a limitation of the database and not BO.
I suggest to ask your Oracle DBA whether he/she knows any DB parameter that would help to extend the number of values accepted by IN operator in the WHERE clause.
Marek Chladny 
(BOB member since 2003-11-27)
Thank you, Marek.
dora (BOB member since 2008-04-09)
There is no parameter to increase the number of values allowed n the IN operator. simply split the condition down into multiple conditions combined with OR s
pablolee (BOB member since 2008-07-29)
In that case, consider loading your data from your Excel sheet into the database and importing it as a table into designer then joining it.
You’d have a far more performant query then.