OBIEE ERROR: Subquery contains too many values for the IN predicate

To update parameters in NQSConfig.INI:

1. Open the NQSConfig.INI file in a text editor. You can find this file at:

2.  ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

Make a backup copy of the file before editing.

3. Locate parameter “MAX_EXPANDED_SUBQUERY_PREDICATES” and update the parameter from default value 8192 to 15000.
4. Save and close the file.
5. Restart the Oracle BI Server

Below is image for reference from a sample NQSConfig.INI

 

Reference Oracle Link:

http://docs.oracle.com/cd/E21764_01/bi.1111/e10541/configfileref.htm#BIESG2968