Last updated on DECEMBER 03, 2012
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0  to 126.96.36.199.5 [Release 11g]
Oracle Exalytics Software - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Information in this document applies to any platform.
OBIEE 11g requests (reports) and dashboards are failing with error:
[nQSError: 42029] Subquery contains too many values for the IN predicate.
[nQSError: 43119] Query Failed:
[nQSError: 43113] Message returned from OBIS.
This occurs even though the NQSConfig.ini setting shows:
MAX_EXPANDED_SUBQUERY_PREDICATES = 500000; # default is 8192
This error may occur on requests that worked (without error) in a previously working 11g version, or in environments where the data results increased significantly (i.e. increased from 15 to 20,000 rows to over 1 million rows).
This problem may also occur on Oracle Exalytics environments when running OBIEE 11g requests or dashboards.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms