Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.

Question

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.

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

[Deleted User] · Answer

Robert already gave you a key hint: there are literally DOZENS of settings impacting this.

https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-E158301D-67F3-495D-BEB7-B81FFDBA725A.htm#BIESG3262

Robert Angel · Answer

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; - 9999999 < CubeMaxPopulatedCells>999999999 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.