Tuesday, August 6, 2013

Agent Failed : nQSError: 77006

Hi Friends,

Today I cam across an error in Agents ( OBIEE 11.1.17.1) when I try to deliver a report of 18.1 MB size to users as excel attachment.

Error :

[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


Solution :

Go to

/u01/app/oracle/obiee117g/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1

and edit the config.xml file



 Here limit is 8192 KB and I am trying to send 18534.4 KB.

First Thing to do for trouble shoot this issue is.... Change the 8192 to zero as  shown below.




 and restart the services.... It will fix the issue...A value of '0' means that this limit is deactivated.

But , you would like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then gradually increase the parameter's value until you can export correctly.

Thanks
Venkat


No comments:

Post a Comment