12 Replies Latest reply on Feb 4, 2010 6:47 AM by obiee123

    Error in creating a PDF

    319739
      When I create a very big PDF-Document with several hundreds of pages I receive the followung error message:

      Q: Do I have to configure the PresentationServer in a better way?


      Regards,

      Stefan

      +++ ThreadID: 1964 : 2008-04-22 10:25:53.000
      [nQSError: 77006] Oracle BI Presentation Server Error: Unexpected end of file encountered. 4 bytes were requested and 0 bytes were read.
      Error Codes: KUWODMKH



      +++ ThreadID: 1964 : 2008-04-22 10:25:53.000
      iBotID: /users/extov01/_ibots/xx001_BestandesListe_K31
      ...Trying iBot Get Response Content loop again.

      +++ ThreadID: 1964 : 2008-04-22 10:25:53.000
      ... Sleeping for 3 seconds.

      +++ ThreadID: 1964 : 2008-04-22 10:27:38.000
      [nQSError: 77006] Oracle BI Presentation Server Error: Unexpected end of file encountered. 4 bytes were requested and 0 bytes were read.
      Error Codes: KUWODMKH



      +++ ThreadID: 1964 : 2008-04-22 10:27:38.000
      iBotID: /users/extov01/_ibots/xx001_BestandesListe_K31
      ...Trying iBot Get Response Content loop again.

      +++ ThreadID: 1964 : 2008-04-22 10:27:38.000
      ... Sleeping for 5 seconds.

      +++ ThreadID: 1964 : 2008-04-22 10:29:25.000
      [nQSError: 77006] Oracle BI Presentation Server Error: Unexpected end of file encountered. 4 bytes were requested and 0 bytes were read.
      Error Codes: KUWODMKH



      +++ ThreadID: 1964 : 2008-04-22 10:29:25.000
      iBotID: /users/extov01/_ibots/xx001_BestandesListe_K31
      Exceeded number of request retries.
        • 1. Re: Error in creating a PDF
          577516
          try adding these in instanceconfig

          <PDF>
          <InputStreamLimitInKB>20480</InputStreamLimitInKB>
          </PDF>
          <ResultRowLimit>100000000</ResultRowLimit>
          <CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>

          restart services.
          • 2. Re: Error in creating a PDF
            631758
            I tested the parameters as you described but I still get the error below. I also tried to increase it to 204800 but the error is still the same.

            Error:
            A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage 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:41) at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:38) at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:28) at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:40) at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:94) at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:175) at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223) at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205) at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153) at java.lang.Thread.run(Thread.java:595) .
            Error Details
            Error Codes: AGEGTYVF

            instanceconfig.xml contents:

            <PivotView>
            <MaxCells>600000</MaxCells>
            </PivotView>
            <PDF>
            <InputStreamLimitInKB>204800</InputStreamLimitInKB>
            </PDF>
            <ResultRowLimit>100000000</ResultRowLimit>
            <CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>
            <CubeMaxRecords>100000</CubeMaxRecords>

            Any help appreciated.
            • 3. Re: Error in creating a PDF
              634359
              Hi,

              I am facing the same problem. When I try to export data to pdf, I am getting the same error. Did you find any solution to this?

              A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage org.apache.fop.apps.FOPException at org.apache.fop.apps.Driver.render(Driver.java:507) at org.apache.fop.apps.Driver.run(Driver.java:565) at com.siebel.analytics.web.sawjavahost.pdf.PDFRpcCall.processMessageInternal(PDFRpcCall.java:48) at com.siebel.analytics.web.sawjavahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:41) at com.siebel.analytics.web.sawjavahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:127) at com.siebel.analytics.web.sawjavahost.Listener$Job.run(Listener.java:216) at com.siebel.analytics.web.sawjavahost.standalone.SAWWorkManagerImpl.threadMain(SAWWorkManagerImpl.java:178) at com.siebel.analytics.web.sawjavahost.standalone.SAWWorkManagerImpl$1.run(SAWWorkManagerImpl.java:126) at java.lang.Thread.run(Thread.java:534) --------- com.siebel.analytics.web.sawjavahost.InputStreamWithLimit$ReadOverTheLimitException at com.siebel.analytics.web.sawjavahost.InputStreamWithLimit.incTotalBytes(InputStreamWithLimit.java:56) at com.siebel.analytics.web.sawjavahost.InputStreamWithLimit.read(InputStreamWithLimit.java:47) at org.apache.xerces.impl.XMLEntityManager$RewindableInputStream.read(Unknown Source) at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.scanContent(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanContent(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.fop.apps.Driver.render(Driver.java:498) at org.apache.fop.apps.Driver.run(Driver.java:565) at com.siebel.analytics.web.sawjavahost.pdf.PDFRpcCall.processMessageInternal(PDFRpcCall.java:48) at com.siebel.analytics.web.sawjavahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:41) at com.siebel.analytics.web.sawjavahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:127) at com.siebel.analytics.web.sawjavahost.Listener$Job.run(Listener.java:216) at com.siebel.analytics.web.sawjavahost.standalone.SAWWorkManagerImpl.threadMain(SAWWorkManagerImpl.java:178) at com.siebel.analytics.web.sawjavahost.standalone.SAWWorkManagerImpl$1.run(SAWWorkManagerImpl.java:126) at java.lang.Thread.run(Thread.java:534) .
              Error Details
              Error Codes: AGEGTYVF
              Location: saw.subsystem.portal.pdf, saw.subsystem.portal.pdf, saw.httpserver.request, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.socketServer, saw.threadPool, saw.threadPool, saw.threads
              File: ./project/webcomm/rpc.cpp, Line: 354

              Thanks.
              • 4. Re: Error in creating a PDF
                678974
                To configure the Javahost service, edit the Javahost service configuration parameters in the
                instanceconfig.xml file. The parameters are
                identified by their relative path starting from the /WebConfig/ServerInstance node
                For example:

                <JavaHost>
                <PDF>
                <InputStreamLimitInKB>50000</InputStreamLimitInKB>
                </PDF>
                </JavaHost>

                After changes restart Siebel Analytics Java Host and Siebel Analytics Web services

                Edited by: user5464401 on Jan 9, 2009 12:36 AM
                • 5. Re: Error in creating a PDF
                  628531
                  Or you could take the limitation of in total:

                  <JavaHost>
                  <PDF>
                  <InputStreamLimitInKB>0</InputStreamLimitInKB>
                  </PDF>
                  </JavaHost>

                  see: http://obiee101.blogspot.com/2009/01/obiee-creating-large-huge-pdf-documents.html

                  Regards John
                  http://obiee101.blogspot.com/

                  Edited by: John Minkjan on Jan 9, 2009 4:40 AM
                  • 6. Re: Error in creating a PDF
                    691647
                    Hi.
                    As per your instructions i have tried following tags

                    <JavaHost>
                    <PDF> <InputStreamLimitInKb>0</InputStreamLimitInKb> </PDF>
                    </JavaHost>

                    but still getting same exception.

                    racle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage
                    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:41)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:38)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:28)
                         at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:40)
                         at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:94)
                         at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:175)
                         at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153)
                         at java.lang.Thread.run(Thread.java:619)
                    .
                    Error Codes: AGEGTYVF

                    .
                    Error Codes: AGEGTYVF



                    +++ ThreadID: 1114 : 2009-03-18 20:45:17.402
                    iBotID: /users/mughal/_ibots/one more
                    ...Trying iBot Get Response Content loop again.

                    +++ ThreadID: 1114 : 2009-03-18 20:45:17.433
                    ... Sleeping for 3 seconds.

                    +++ ThreadID: 1114 : 2009-03-18 20:45:33.839
                    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage
                    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:41)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:38)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:28)
                         at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:40)
                         at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:94)
                         at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:175)
                         at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153)
                         at java.lang.Thread.run(Thread.java:619)
                    .
                    Error Codes: AGEGTYVF

                    .
                    Error Codes: AGEGTYVF



                    +++ ThreadID: 1114 : 2009-03-18 20:45:34.011
                    iBotID: /users/mughal/_ibots/one more
                    ...Trying iBot Get Response Content loop again.

                    +++ ThreadID: 1114 : 2009-03-18 20:45:34.152
                    ... Sleeping for 5 seconds.

                    +++ ThreadID: 1114 : 2009-03-18 20:45:52.745
                    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage
                    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:41)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:38)
                         at com.siebel.analytics.utils.IOUtils.copyStreams(IOUtils.java:28)
                         at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:40)
                         at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:94)
                         at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:175)
                         at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205)
                         at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153)
                         at java.lang.Thread.run(Thread.java:619)
                    .
                    Error Codes: AGEGTYVF

                    .
                    • 7. Re: Error in creating a PDF
                      701193
                      I am also in somewhat same situation. Not able to generate huge pdf reports. tried out below code as well. but in vain. Still getting the same error.
                      Is there anything that can be done for running the report successfully ?

                      <JavaHost>
                      <PDF> <InputStreamLimitInKb>0</InputStreamLimitInKb> </PDF>
                      </JavaHost>

                      Thanks in Advance.
                      EssPee.

                      Edited by: esspee on Jul 22, 2009 5:06 PM
                      • 8. Re: Error in creating a PDF
                        Dimitris
                        As it is mentioned in many threads,
                        pdf printing is best managed via xml - publisher!!!
                        the presentation server has really small capabilities...


                        hope i helped...

                        ///////////////////////////////////////
                        http://greekoraclebi.blogspot.com/
                        ///////////////////////////////////////
                        • 9. Re: Error in creating a PDF
                          user616533
                          John, even I tried setting the value to 0, but I still get the error when I open a large PDF report (services were restarted).

                          Thanks.
                          • 10. Re: Error in creating a PDF
                            Dimitris
                            hi,
                            if the answer is closed....
                            reward answerers with points ...and close it..tnks

                            i hope i helped....

                            ///////////////////////////////////////
                            http://greekoraclebi.blogspot.com/
                            ///////////////////////////////////////
                            • 11. Re: Error in creating a PDF
                              obiee123
                              Try removing one of the views (i.e. title or filter view) then it should work. Happened to me also few days back. I could create few report by removing title view. Then it started giving error, so removed filters view.

                              But that is a workaround, I think there is some bug in PDF creator module.
                              • 12. Re: Error in creating a PDF
                                obiee123
                                Try removing one of the views (i.e. title or filter view) then it should work. Happened to me also few days back. I could create few report by removing title view. Then it started giving error, so removed filters view.

                                But that is a workaround, I think there is some bug in PDF creator module.