Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.
Hi Team,
I tried accordingly Doc ID 1911331.1. Changed configuration changes in instanceconfig.xml file according to the oracle support provided solution but i am getting same message as mentioned below.Can you please provide solution for below error in obiee 11.1.1.9 Report.
Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.
Error Details
Error Codes: IRVLJWTALocation: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
Thanks
Prabhakar B
9840361256
Answers
-
Hi,
are you aware that there are various settings that effect this, not just a single simple case of increasing the row limit, there are also limits to the number of row / column combinations for pivot tables etc etc, like; -
<CubeMaxRecords>9999999</CubeMaxRecords>
< CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>
Also, did you restart your services after the XML change?
See -> OBIEE 11g: Exceeded configured maximum number of allowed input records
For a previous discussion on the same issue.
0 -
Robert already gave you a key hint: there are literally DOZENS of settings impacting this.
0