Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c Excell export problem

Hi,
We are trying to export quite big excel file from a dashboard.
We get the following error in the logs:
[2017-08-16T11:57:47.578+03:00] [xmlp] [WARNING] [] [saw.xmlp] [tid: 22] [ecid: 3ae2e016-97a9-48e2-9a8d-7b3f948c6ddb-000004f3,0:1:10] Error[[
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)
at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1359)
at oracle.xml.parser.v2.XMLReader.readQName(XMLReader.java:2156)
at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1860)
at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1810)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1647)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:471)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:417)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:249)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.xdo.common.xml.XDOSAXParser.invokeParse(XDOSAXParser.java:300)
at oracle.xdo.common.xml.XDOSAXParser.parse(XDOSAXParser.java:149)
at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:441)
Our settings are:
Maximum Number of Rows Processed when Rendering a Table View: 1500000
Maximum Number of Rows to Download: 5000000
Didn't find the documentation on this issue for 12c.
Answers
-
ShayG wrote:oracle.xdo.XDOIOException: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException
Probably your BIP InputStreamLimitInKB is set too low in the config.xml compared to the amount of data you are trying to jam down its throat.
You'll need to increase it:
<XMLP>
<InputStreamLimitInKB>32768</InputStreamLimitInKB>
</XMLP>
NOTE: This is an EXAMPLE number, not an ABSOLUTE "set this to 42". You may need an even bigger pipe.
0 -
That was it.
Thanks.
0