Oracle Analytics and AI

User_WYDQH

A table view is throwing an error "Exceeded configured maximum number of allowed output rows" with the below instanceconfig.xml file. When the generated sql ran on the database, the record count is 42978. The error does not disappear even after increasing the number in the instanceconfig.xml (Version 2) file.

The report results is : Table view and the number of columns are 16

Please suggest.

Error:

Version 1

Version 2

User_WYDQH

@SteveF-Oracle, Thanks for your response. The maximum allowed number in the console is 5000.

This issue is fixed now. Solution applied as mentioned in the below KM article.

Document 3006067.1

Note: Though errored report view is Table view, there is a narrative view too available in the compound layout. I reluctantly applied this solution (narrative view element) as the error is not thrown by the narrative view. However, this solution fixed the issue.