Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 11g: Exceeded configured maximum number of allowed input records

971988Nov 1 2012 — edited Sep 23 2013
I 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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2013
Added on Nov 1 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
10 comments
76,234 views