OBIEE 11g: Error: "Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5:OI2DL65" when Exporting or Opening a Large Report or Graph

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 BP2 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 BP2 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 to 11.1.10.0.0 [Release 1.0]
Information in this document applies to any platform.
**Updated 16-Oct-2014**

**This information also applies to the 11.1.1.6.x and 11.1.1.7.x releases**

Symptoms

When trying to export or run large reports the following error appears:

Error:
"View Display Error
Exceeded configured maximum number of allowed input records.
Error Details
Error Codes: EKMT3FK5:OI2DL65P
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads"

Cause

You have hit a query governor limit set in instanceconfig.xml.

Solution

To resolve the issue you need to increase the following parameters:
In Fusion Middleware Control:
1. Log into FMW Console: http://hostname.domain:port/em (for example; http://localhost:7001/em).
    Refer to the following document for more information Logging into Fusion Middleware Control to Manage Oracle Business Intelligence
2. Go to Business Intelligence -> coreapplication -> Capacity Management -> Performance and click "Lock and Edit Configuration".
3. Change the following parameter values (values shown here are examples):

Maximum Number of Rows Processed when Rendering a Table View Number Of Rows: 800000
Maximum Number of Rows to Download Number Of Rows: 140000

4. Click Apply on each page after you have made your changes.

When you have finished making your changes, do one of the following:

5a. Click Activate Changes to execute your changes and release the lock to enable another system administrator to make changes.
5b. Click Release Configuration to undo all changes you made since clicking Lock and Edit Configuration and release the lock to enable another system administrator to make changes.

6. After you have activated your changes, go to the Overview page and click Restart.
In instanceconfig.xml:
1. Stop the Presentation Server.
2. Take a back-up copy of your current 'instanceconfig.xml' file: MW_HOME\ORACLE_INSTANCE\instancen\config\OracleBIPresentationServicesComponent\coreapplication_obips1\
3. Edit the 'instanceconfig.xml' and make the following changes.

Note: Unless listed leave the other parameter values at their default values.

i. Increase the values for the following two parameters in the <Cube> section; for example:

<Cube>
 <CubeMaxRecords>5000000</CubeMaxRecords>
 <CubeMaxPopulatedCells>15000000</CubeMaxPopulatedCells>
</Cube>

ii. Increase the values for the following two parameters in the <Pivot> section; for example:

<Pivot>
 <MaxCells>4000000</MaxCells>
 <MaxVisibleRows>140000</MaxVisibleRows>
 ....
</Pivot>

iii. Increase these 2 settings in the <Table> section; for example:

<Table>
 <MaxCells>4000000</MaxCells>
 <MaxVisibleRows>140000</MaxVisibleRows>
</Table>

iv. Increase this setting in the <Charts> section; for example:

<Charts>
<MaxVisibleRows>140000</MaxVisibleRows>
</Charts>

v. If you are running OBIEE 11.1.1.6.10 or later, then also increase this setting in the <ODBC> section; for example:

<ODBC>
   <ResultRowLimit>1500000</ResultRowLimit>
</ODBC>

For more information on this setting refer here.
4. Save the file.
5. Restart the Presentation server.


* NOTE:
1.You need to insert one by one tags(<TABLE>,<PIVOT> etc) in  Instanceconfig.xml file between <views> </views> tags.
 2. First try to perform instanceconfig.xml changes alone, even then if issue not fixed then perform changes in Fusion Middleware Control as well .