obiee fails to export to large pdf
Kurt Geens Jul 15, 2014 2:57 PMWhen exporting large volumes of report data to pdf no error is raised in obiee, nor does the export ever complete. In the logfiles I find following entries:
logfile = jh.log
message level = 1
relationship id = 0:1:33
component = xmlp
module = saw.xmlp
message = error
oracle.xdo.XDORuntimeException
at oracle.xdo.template.fo.area.AreaTree.handleGeneratorError(AreaTree.java:582)
at oracle.xdo.template.fo.area.AreaTree.doOutput(AreaTree.java:567)
at oracle.xdo.template.fo.elements.FormattingEngine.startLayout(FormattingEngine.java:303)
at oracle.xdo.template.fo.elements.FormattingEngine.run(FormattingEngine.java:143)
at oracle.xdo.template.fo.FOHandler.endElement(FOHandler.java:657)
at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:211)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1588)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:442)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:388)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:232)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at oracle.xdo.common.xml.XDOSAXParser.invokeParse(XDOSAXParser.java:166)
at oracle.xdo.common.xml.XDOSAXParser.parse(XDOSAXParser.java:122)
at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:408)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1228)
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:193)
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:738)
logfile = jh.log
message level = 1
relationship id = 0
component = messageprocessor
module = saw.messageprocessor
message = Unexpected exception. Connection will be closed
java.io.IOException: Attempt to read from closed socket
at com.siebel.analytics.javahost.io.ChannelWithTimeout.read(ChannelWithTimeout.java:134)
at com.siebel.analytics.javahost.io.BlockingIOImpl.read(BlockingIOImpl.java:37)
at com.siebel.analytics.javahost.io.BlockingIOInputStream.readFromChannelIfNeeded(BlockingIOInputStream.java:108)
at com.siebel.analytics.javahost.io.BlockingIOInputStream.skip(BlockingIOInputStream.java:86)
at java.io.BufferedInputStream.skip(BufferedInputStream.java:360)
at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolInputStreamImpl.callSkipOnBase(SAWProtocolInputStreamImpl.java:143)
at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolInputStreamImpl.skipAll(SAWProtocolInputStreamImpl.java:159)
at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:197)
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:738)
logfile = sawlog1.log
message level = 31
relationship id = 0:1
component = OBIPS
module = saw.rpc.variablemos.write
message = An error occurred during execution of "send". Broken pipe [Socket:9]
File:socket.cpp
Line:733
Location:
saw.rpc.variablemos.write
saw.fopProxy
saw.subsystem.portal.pdf
saw.httpserver.processrequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
SessionID: 3jdsoqdpbtir40vu1r0982cah4ro3mujomnh4aq
AuthProps: AuthSchema=UidPwd|PWD=******|UID=weblogic|User=weblogic
ecid: 1bbe33c59cea0aa0:-d7e31ce:147101c0c21:-8000-000000000005c173,0:1
ThreadID: 3600
HttpCommand: Go
RemoteIP: <ip adres>
As for versions, OBIEE is version 11.1.1.7.1, and the browser in use is firefox 30.0 (though it seems unlikely to be a brower issue as the java errors are server side).
Exporting the same data to excel (both 2003 and 2007+) works like a charm, but only after adjusting the xmlp settings as described in this blogpost: Oracle Business Intelligence by Sandeep Venu: OBIEE 11.1.1.7.1 EXCEL 2007+ DOWNLOAD ERROR
Exporting smaller quantities of data is working as well, so the pdf generation itself does work. Somehow something crashes though when processing larger quantities of data, and it's unclear to me what it might be or how to resolve it...