8 Replies Latest reply on Jul 16, 2014 4:07 PM by Kurt Geens

    obiee fails to export to large pdf

    Kurt Geens
    Kurt Geens Jul 15, 2014 2:57 PM

      When 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...

        • 1. Re: obiee fails to export to large pdf
          KKT
          KKT Jul 15, 2014 3:26 PM (in response to Kurt Geens)

          Not much sure but my first look goes to /etc/hosts file that should always have first line in the file like the following:

           

           

           

          # Do not remove the following line, or various programs

          # that require network functionality will fail.

          10.128.10.186 machinename.domainname.com    machinename

          127.0.0.1 localhost.localdomain localhost

           

           

          Save the changes and restart all services.

           

           

          Thanks,

          ~~KKT

          • 2. Re: obiee fails to export to large pdf
            Sasi Nagireddy
            Sasi Nagireddy Jul 15, 2014 11:20 PM (in response to Kurt Geens)

            Can you copy and paste the version of obiee  you are using with Patch?

             

            Thanks,

            Sasi Nagireddy..

            • 3. Re: obiee fails to export to large pdf
              Kurt Geens
              Kurt Geens Jul 16, 2014 7:39 AM (in response to KKT)

              Thanks for the suggestion, but the host file does have the localhost (and loopback) entry.

              Furthermore, I would think that if that was the problem, the pdf would always fail to generate (instead of only when reaching a certain size).

              • 4. Re: obiee fails to export to large pdf
                Kurt Geens
                Kurt Geens Jul 16, 2014 7:46 AM (in response to Sasi Nagireddy)

                version.txt:

                 

                Build: 11.1.1.7.1.BISERVER_11.1.1.7.0_AIX.PPC64_130531.2321

                Release Version: Oracle Business Intelligence 11.1.1.7.1

                Package: 130602.0158.000

                 

                opatch inventory:

                 

                Installed Top-level Products (1):

                 

                Oracle Business Intelligence Shiphome                                11.1.1.7.0

                There are 1 products installed in this Oracle Home.

                 

                 

                Interim patches (7) :

                 

                Patch  16916026     : applied on Wed Mar 05 09:15:29 CET 2014

                   Created on 7 Jun 2013, 16:48:05 hrs PST8PDT

                   Bugs fixed:

                     16398834, 16713973, 16221055, 16725591, 16707772, 15937308, 16532436

                     16269584, 14735520, 16219823, 16193452, 16384321, 16213618, 16773824

                     16069249, 16745019, 15909222, 16683693, 16688700, 16708613, 16910400

                     15905738, 16584238, 16584272, 16307860, 16701102, 16239148, 16231262

                     16412331, 16464161, 16614458, 16264619, 16700237, 16213379, 15927301

                     16352978, 15943349, 16688752, 16808563, 16283171, 16422863, 15961670

                     16614461, 16674634, 16702747, 16190497, 16568537, 16533654, 15904732

                     16178344, 16838297, 16407235, 16584216, 16358365, 13937712, 14763670

                     16024046, 16202603, 16464101, 16291779, 16090490, 16622345, 16068978

                     16589919, 15942667, 16206423, 15930438, 16354734, 16060449, 16185284

                     16095724, 16081424, 16412391

                 

                Patch  16869578     : applied on Wed Mar 05 09:13:33 CET 2014

                   Created on 8 Jun 2013, 00:05:54 hrs PST8PDT

                   Bugs fixed:

                     16383681, 16807062, 16462659, 16492220, 16869578, 16709679, 16660288

                 

                Patch  16850553     : applied on Wed Mar 05 09:12:45 CET 2014

                   Created on 2 Jun 2013, 15:34:25 hrs PST8PDT

                   Bugs fixed:

                     15899791, 16202039, 16205593, 16082084, 14707502, 16212235, 16541254

                     16211720, 16246532, 15856175, 16533380, 16411235, 16432398, 15923119

                     16829344, 13997033, 16180022, 16073845, 16503403, 15938293, 16232096

                     16225309, 16250380, 16588800, 14759014, 16366540, 16681048, 16675024

                     16098352, 16630993, 16710174, 16338494, 15998686, 15974003, 16051890

                     16055098, 16616596, 16681088, 16195852, 16363137, 16499690, 15905882

                     16616127, 14721919, 16403404, 15950163, 16500619, 15979853, 16779214

                     16453922, 16537281, 16631043, 16398673, 16179354, 16390104, 16838790

                     15856117, 16358396, 16227537, 15949849, 15945705, 16099818, 16211742

                     16078406, 16760411, 16014567, 14712420, 16413431, 16383079, 15950175

                     16761432, 14612457, 16278897, 14406458, 16419645, 16423091, 16527635

                     16211788, 16573183, 16371029, 15924375, 16082079, 14809681, 16181178

                     16239305, 16447488, 16616142, 16467196, 16212190, 16424369, 16194063

                     16447124, 16211466, 16021684, 16521971, 16311723, 14837778, 14577963

                     16390374, 16622023, 16008376, 16383338, 16225335, 16539983, 16627183

                 

                Patch  16849017     : applied on Wed Mar 05 09:11:38 CET 2014

                   Created on 7 Jun 2013, 06:34:28 hrs PST8PDT

                   Bugs fixed:

                     16311041, 15982594, 14755910, 16381954, 16596837, 13720037, 16440558

                     13825454, 15886696, 16754485, 16709104, 16810826, 16303357, 15925965

                     15835055, 15893446, 16602238, 15944966, 15886427, 15937202, 16453917

                     13836760, 16385344, 16760384, 13990460, 16036921, 16339006, 12866751

                     14733191, 16608302, 14831544, 16478354, 16384964, 16191483, 16842141

                     16515484, 16183449, 16371395, 16636503, 15986061, 16480634, 14624063

                     16725621, 15953794, 14710743

                 

                Patch  16842070     : applied on Wed Mar 05 09:10:28 CET 2014

                   Created on 7 Jun 2013, 15:41:16 hrs PST8PDT

                   Bugs fixed:

                     16370231, 15955919, 16758001, 16080731, 16098999, 16732668, 16085893

                     15977804, 16181186, 15873335, 16563791, 16025431, 16195598, 15936365

                     16432100, 16423399, 15836931, 15911357, 16048912, 16306220, 14200531

                     14123936, 16321247, 14786553, 14796461, 16208148, 16323282, 16214816

                     16790124, 14769682, 16515206, 15846127, 16175201, 16765598, 16210174

                     15908175, 15931755, 16081724, 14745585, 14404227, 16624321, 16473120

                     15961449, 14597361, 16098576, 16803542, 16405009, 16168896, 16088305

                     14766020, 16040756, 16788791, 14140136, 16210213, 14270482, 13404311

                     15941168, 15966717, 16456619, 15912205, 16210078, 14255286, 13629052

                     16563663, 16309432, 15903315, 14551563, 14509257, 16341656, 16757080

                     14571347, 16370366, 16387359, 14839368, 15879674, 14694478, 14482447

                     14774051, 16673838, 14488588, 16680403, 16727109, 16304609, 16182007

                     14322016, 16456338, 16694816, 14800670, 13728915, 15840909, 16775590

                     14722158, 14834396, 15908156, 16432997, 16172172, 14701862, 16248123

                     14043444, 16657405, 14650457, 15839502, 16515088, 16193511, 16856154

                     16207947, 14205752, 14194376, 16796577, 14832723, 14832439, 15908489

                     14510493, 15952935, 16481343, 13533513, 16180599, 16401538, 15937629

                     15953014, 16674936, 16210127, 16807165, 14168140

                 

                Patch  16453010     : applied on Wed Mar 05 09:09:47 CET 2014

                   Created on 23 Apr 2013, 20:02:43 hrs PST8PDT

                   Bugs fixed:

                     16339799, 16328568

                 

                Patch  16569379     : applied on Wed Mar 05 09:01:17 CET 2014

                Unique Patch ID:  16340563

                   Created on 9 May 2013, 02:25:40 hrs PST8PDT

                   Bugs fixed:

                     16367012, 16397667

                • 5. Re: obiee fails to export to large pdf
                  deepika walia
                  deepika walia Jul 16, 2014 12:40 PM (in response to Kurt Geens)

                  Hi,

                   

                  Try this link:

                  Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher

                   

                  It will generate your report in pdf and export it as zipped pdf.

                   

                  Thanks

                  • 6. Re: obiee fails to export to large pdf
                    Kurt Geens
                    Kurt Geens Jul 16, 2014 12:57 PM (in response to deepika walia)

                    Thanks, but I'm looking for a solution or explanation, not a work around. It is a client requirement to use the default pdf export from within the analysis...

                    • 7. Re: obiee fails to export to large pdf
                      deepika walia
                      deepika walia Jul 16, 2014 3:48 PM (in response to Kurt Geens)

                      Hi,

                       

                      This is what we have suggested to our client also as inspite of implementing all the performance tuning measures report was not getting generated for large no. of records.

                      So, this not a workaround but a solution in  which report will always be generated irrespective of no. of records.

                       

                      Thanks

                      • 8. Re: obiee fails to export to large pdf
                        Kurt Geens
                        Kurt Geens Jul 16, 2014 4:07 PM (in response to deepika walia)

                        Hi Deepika,

                         

                        I understand what you're saying, but it's still a work around that is packaged as a solution.

                         

                        Our client is not using publisher at all for the moment, they just use dashboards and analysis and are used to exporting to pdf, xls(x), csv, ... using the dashboard export context menu. I'm willing to accept that for your client using publisher was an acceptable alternative, but I can't explain to my client that they have to start using publisher if the data set is 'large' and they wish to export to pdf or ppt 2007+ (for everything else works fine) just because the process they're used to following crashes without any warning or error, apart from the one burried in the log files.

                         

                        Thanks once more for the suggestion though.

                         

                        Regards,

                        Kurt