Agent failure with InputStreamWithLimit$ReadOverTheLimitException

[OracleBISchedulerComponent] [ERROR:1] [] [] [ecid:0053x_55GsOEWN3pzkG7yW00015v0000tH] [tid: b92e6700] 
[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
.
Error Codes: AGEGTYVF

Issue

Excel download of the report works properly but when sending this report in agent, the agent fails.
Upon looking at the agent log files, you could see the error messages mentioned above.

Agent Log File Location:  <OBIEE_HOME>/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

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


InputStreamLimitInKB

A subelement common to each loader that specifies, in kilobytes, 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.

Solution

1) Change the excel format to 2003 and try to run the agent. This works in some cases.

OR

2) Edit the config.xml file in <MiddlewareHome>/instances/instance1/confi/OracleBIJavaHostComponent/coreapplication_obijh1

Increase the value of parameter InputStreamLimitInKB until it resolves the issue  

<XMLP>
      <InputStreamLimitInKB>8192</InputStreamLimitInKB>
      <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>

Note: Setting InputStreamLimitInKB governor value to zero (0), which is unlimited, should only be used for testing purposes only. Configuring the value too high will allocate or consume more resources than necessary for an individual request to the JavaHost, may cause the Javahost to become unstable or crash and should be configured in context of all JavaHost requests (charts, graphs, exports). Set the value to something reasonable that works with your large data sets. The default is 8192 (8MB), but you may need to increase it to 16384 (16MB), 32768 (32MB), etc. (1024 * X).