Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 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