Oracle BI Agent nQSError: 77006 Error Codes: AGEGTYVF

During a Oracle BI Agent job execution, I have encountered the following error message:

[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: A fatal error occurred while processing the request. The server responded with: com.siebel.analytics.utils.InputStreamWithLimit $ ReadOverTheLimitException.
Error Codes: AGEGTYVF
Location: saw.rpc.mis.read, saw.subsystem.portal.pdf, saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

With this analysis, the Excel download of the report work properly but when I execute this report in the agent, it fails. After the fail, if you look at the agent log files, you could see the error messages mentioned above in:

/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

Lookout for Agent.log for the time of Agent failure.

You can workaround this issue by changing the excel format to 2003 and try to run the agent. This works in most cases:

Alternatively, edit the config.xml file in

/instances/instance1/confi/OracleBIJavaHostComponent/coreapplication_obijh1

and increase the value of parameter InputStreamLimitInKB in kilobytes. This indicates the maximum input size for requests that are sent to JavaHost. A value of zero deactivates this limit. If the maximum size is exceeded, then an error message is displayed. Default value is 8192.

You can set this parameter to zero (unlimited), but use this only in a test environement, beacuse configuring the value too high will allocate or consume more resources than necessary.

The default InputStreamLimitInKB is 8192 (8MB), but you may need to increase it to 16384 (16MB), 32768 (32MB), etc.