OBIEE 12c Excell export problem

ShayG

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.

[Deleted User]

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.

ShayG

That was it.

Thanks.