OBIEE 11g|12c: Error: "View Display Error Exceeded configured maximum number of allowed input records. Error Details Error Codes: EKMT3FK5" Occurs when Scrolling only Half Data of ResultRowLimit Setting in Table View (Doc ID 1940810.1)

Last updated on JUNE 27, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

You have installed OBIEE 11g or 12c and have created a table view report.
You are using "Fixed headers with scrolling content" in the table view.
You changed the parameter, [Maximum Number of Rows Processed when Rendering a Table View](ResultRowLimit), to 111,000 to view the data until at least 110,000 records in the table view with scrolling content.
But when you scroll to 56,000 rows, you get the following error:

       

 

If you use Content Paging, you can view up to 110,500 records.

Cause

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