Error: "There was an error processing your download. Please check with your administrator" And "oracle.xdo.XDOIOException: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException" When Exporting An Analysis To Excel (Doc ID 2422775.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

When attempting to export an Analysis to excel (either by exporting an Analysis directly, or by exporting a dashboard page), the following error occurs (using OBIEE 12c):

ERROR
--------------------
There was an error processing your download. Please check with your administrator.

The OBIEE Server Log (saw#.log) generated the following exception:

ERROR
--------------------
[TIMESTAMP] [OBIPS] [ERROR:31] [] [saw.rpc.mis.read] [ecid: XXX] [tid: XXX] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [XX] A fatal error occurred while processing the request. The server responded with: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.[[
File:rpc.cpp
Line:482
Location:
     saw.rpc.mis.read
     saw.subsystems.portal.generatedashboardexcel
     saw.httpserver.processrequest
     saw.rpc.server.responder
     saw.rpc.server
     saw.rpc.server.handleConnection
     saw.rpc.server.dispatch
     saw.threadpool.socketrpcserver
     saw.threads
HttpCommand: generateDashboardExcel
AuthProps: AuthSchema=SSO|IMPERSONATE=XXX|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=<UID>
SessionID: XXX
RemoteIP: XXX
SIKey: ssi
]]

[TIMESTAMP] [OBIPS] [ERROR:31] [] [saw.rpc.mis.read] [ecid: XXX] [tid: XXX] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [XX] RPCServer returned a error: Error while executing ExcelRpcCall.processMessage
oracle.xdo.XDOIOException: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException
     at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:450)
     at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1278)
     at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:71)
     at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:251)
     at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:200)
     at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
     at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)
     at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)
     at java.lang.Thread.run(Thread.java:745)
Caused by: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException
     at com.siebel.analytics.utils.InputStreamWithLimit.incTotalBytes(InputStreamWithLimit.java:58)
     at com.siebel.analytics.utils.InputStreamWithLimit.read(InputStreamWithLimit.java:49)
     at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
     at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
     at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
     at oracle.xml.parser.v2.XMLByteReader.fillByteBuffer(XMLByteReader.java:366)
     at oracle.xml.parser.v2.XMLUTF8Reader.fillBuffer(XMLUTF8Reader.java:131)
     at oracle.xml.parser.v2.XMLByteReader.saveBuffer(XMLByteReader.java:455)
     at oracle.xml.parser.v2.XMLReader.fillBuffer(XMLReader.java:2859)
     ...

STEPS TO REPRODUCE
--------------------
The following steps can be utilized to reproduce the issue:

1. Login to OBIEE
2. Click dashboard and select the associated dashboard
3. Export the analysis using one of the following options:
4. Export the Analysis by clicking the export link
5. Export the dashboard page by clicking Page Options, Export to Excel

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.