Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Subquery contains too many values for the IN predicate.

783226Aug 22 2011 — edited Aug 22 2011
My report is based on inner report (filter by inner report), which return list of 10k strings (IP addresses).
It used to work fine in 10g.
In OBIEE 11.1.1.5 I got the following error:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
+State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000).+

Is there a way to configure the max number of values of IN predicate?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2011
Added on Aug 22 2011
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #configuration
7 comments
6,218 views