OBIEE 11g: Exceeded configured maximum number of allowed input records
971988Nov 1 2012 — edited Sep 23 2013I get the below error on a table prompt (drop down from a compound layout view). The are 31000 rows in the report and 808 distinct values for the column that has the table prompt.
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.socketrpcserver, saw.threads
SQL Issued: 167~o6oobclqncnfg2foffgju398ki
If I add a filter to limit the output to a few hundred rows and the table prompt values to one or two distinct values, it works.
The below setting in the instanceconfig.xml file did not help. Any other suggestions would be greatly appreciated.
<Cube>
<CubeMaxRecords>99999</CubeMaxRecords>
<CubeMaxPopulatedCells>9999999</CubeMaxPopulatedCells>
</Cube
Thanks,
Sathish