OBIEE11G: Export to CSV Displays Less Rows than Max Rows Limit Set in the OBI Repository (rpd) and nQSError: 60008 error
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.140114 and later
Information in this document applies to any platform.
In OBIEE 22.214.171.124.140114, the query Limit is set to 100000 rows in the repository:
Manage, Identity, select a user or application role
However, it is retrieving only 99926 in CSV export for one of the reports.
After the last row, the following error is displayed:
[nQSError: 43121] Max Row Limit Exceeded
[nQSError: 43119] Query Failed:
[nQSError: 60008] The query for user 'xxxxxxx' exceeded the maximum query governing rows 100000 from the database 'Oracle Data Warehouse'....
The expected outcome is that OBIEE should download all 100000 rows. The same report in OBIEE 10g environment is retrieving 99925 rows in CSV export.
The maximum number of rows limit behaviour is not consistent, for example, in another report which has more than 100000 rows the error was not displayed.
Please answer the following questions:
1. The reason for less number of records in (99925 instead of 100000) in OBIEE 11g
2. The inconsistent behavior of maximum rows limit parameter
3. Can we retrieve 100000 rows without displaying maximum rows limit error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms