OBIEE

OBIEE 12c Error: “Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5.

/

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"


To resolve the issue you need to increase the following parameters: In Fusion Middleware Control:

  • Log into FMW Console: http://hostname.domain:port/em (for example; http://localhost:7001/em).
  • Go to Business Intelligence -> coreapplication -> Capacity Management -> Performance and click “Lock and Edit Configuration”.
  • 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

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

  • Click Activate Changes to execute your changes and release the lock to enable another system administrator to make changes.
  • 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.

After you have activated your changes, restart all services.   In instanceconfig.xml:

  1. Stop the Presentation Server.
  2. Take a back-up copy of your current ‘instanceconfig.xml‘ file.
  3. Edit the ‘instanceconfig.xml’ and make the following changes:

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

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

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

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

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

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

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

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

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>

Save the file and restart the presentation server.   Note: by increasing these values, performance may decrease due to the high number of data to be displayed.

Leave a Reply