5 Replies Latest reply on Mar 27, 2015 6:45 PM by SriniVEERAVALLI

    error while exporting large report to pdf document in OBIEE 11.1.1.6.12

    1418935

      Hi,

       

      we have large report needed to be exported to PDF, I have change some setting as below:

       

      In Config.xml which is located  \BI_Home\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1\, change

       

      <XMLP>

            <InputStreamLimitInKB>32768</InputStreamLimitInKB>

            <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>

         </XMLP>

       

      in xdo.cfg, change

      <property name="system-temp-dir">c:\temp</property>

      to the correct path

       

      after this setting, i am able to export some reports to PDF, but records over 10000, it throw the error in the sawlog:

      2015-03-27T10:51:29.000-04:00] [OBIPS] [ERROR:16] [] [saw.rpc.mis.read] [ecid: 6314d6274a0b62d0:3aa2f498:14bec1dc796:-8000-0000000000048471,0:1] [tid: 2312] RPCServer returned a error: Error while executing PDFRpcCall.processMessage

      oracle.xdo.XDOIOException: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException

        at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1065)

        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:662)

      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.read1(BufferedInputStream.java:256)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        at oracle.xdo.common.io.FileUtil.writeLargeFile(FileUtil.java:75)

        at oracle.xdo.template.FOProcessor.xmlDataSave(FOProcessor.java:2229)

        at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1050)

        ... 7 more

      [[

      File:rpc.cpp

      Line:473

      Location:

        saw.rpc.mis.read

        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: 6hj63tlcl14h5jfa8m9dacbmgea1frjsndqc6ta

      AuthProps: AuthSchema=UidPwd|PWD=******|UID=wei|User=wei

      ecid: 6314d6274a0b62d0:3aa2f498:14bec1dc796:-8000-0000000000048471,0:1

      ThreadID: 2312

      HttpCommand: Go

       

      ]]

      [2015-03-27T10:51:29.000-04:00] [OBIPS] [ERROR:31] [] [saw.rpc.mis.read] [ecid: 6314d6274a0b62d0:3aa2f498:14bec1dc796:-8000-0000000000048471,0:1] [tid: 2312] A fatal error occurred while processing the request. The server responded with: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.[[

      File:rpc.cpp

      Line:479

      Location:

        saw.rpc.mis.read

        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: 6hj63tlcl14h5jfa8m9dacbmgea1frjsndqc6ta

      AuthProps: AuthSchema=UidPwd|PWD=******|UID=wei|User=wei

      ecid: 6314d6274a0b62d0:3aa2f498:14bec1dc796:-8000-0000000000048471,0:1

      ThreadID: 2312

      HttpCommand: Go

       

       

      also, we have already have setting setup in insatanceconfig.xml for export large report to excel which has no problem:

       

      <ResultRowLimit>300000</ResultRowLimit>

      </ODBC>

      <Views>

      <Pivot>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

      <DefaultRowsDisplayedInDelivery>2500</DefaultRowsDisplayedInDelivery>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

      <DefaultRowsDisplayedInDownload>200000</DefaultRowsDisplayedInDownload>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

      <DisableAutoPreview>false</DisableAutoPreview>

      <MaxCells>1920000</MaxCells>

      <MaxVisibleColumns>5000</MaxVisibleColumns>

      <MaxVisiblePages>2500</MaxVisiblePages>

      <MaxVisibleRows>500000</MaxVisibleRows>

      <MaxVisibleSections>5000</MaxVisibleSections>

      </Pivot>

      <Table>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

      <DefaultRowsDisplayedInDelivery>2500</DefaultRowsDisplayedInDelivery>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

      <DefaultRowsDisplayedInDownload>200000</DefaultRowsDisplayedInDownload>

      <MaxCells>1920000</MaxCells>

      <MaxVisiblePages>2500</MaxVisiblePages>

      <MaxVisibleRows>500000</MaxVisibleRows>

      <MaxVisibleSections>5000</MaxVisibleSections>

      </Table>

      <Cube>

      <CubeMaxRecords>500000</CubeMaxRecords>

      <CubeMaxPopulatedCells>500000</CubeMaxPopulatedCells>

      </Cube>

      <Charts>

      <MaxVisibleColumns>5000</MaxVisibleColumns>

      <MaxVisiblePages>2500</MaxVisiblePages>

      <MaxVisibleRows>500000</MaxVisibleRows>

      <MaxVisibleSections>5000</MaxVisibleSections>

      <JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>

      </Charts>

      </Views>

       

      Does anybody know if i still miss anything here?

       

      Thanks