Running Cognos Impromptu 7.4 and getting the following error:
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RBI_SUBQCONTEXTLIMIT, The maximum number of subqueries or derived tables in a request has been exceeded.
when trying to run a report.
This report worked last year. It does call a dataset report for filtering, which in turn calls another dataset report for filtering, ...
This occurs 5 times.
This last report does not call any other Cognos reports and returns 6801 records (6068 unique ID's).
Each dataset (sub report) runs fine. It is only the main report which returns this error.
What DB vendor and version are you querying?
Has the DB changed?
Has the driver or DB version changed?
Grab the SQL (Report | Query | Profile | SQL, copy and past the SQL code) and run it against the DB directly, does it return?