OBIEE 11.1.1.9 inline prompts

Question

I have a problem in using inline analysis prompts on some larger datasets. Larger I mean 200+. When ever I try to use an analysis column as a table prompt by drag&drop it into "Table prompts" and this column has more than 200+ distinct values I get and error :

"Error Codes: IRVLJWTA

Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.thread".

Anybody has an idea what is the limit of inline prompts dataset length? Btw using same combination of prompts on dashboard level everything is working fine.

Thanx.

Robert Angel · Answer

Have a look at =>

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1911331_1.htm…

and

https://r12siebel.wordpress.com/2012/03/23/obiee-errors-with-exceeded-configured-maximum-number-of-allowed-output-prompt…   (particularly the last point in this one)