2 Replies Latest reply: Jan 23, 2012 4:06 AM by 912604 RSS

    Error in Generating reports with large amount of data using OBIR

    Oracle.Quest
      Hi all,

      we hve integrated OBIR (Oracle BI Reporting) with OIM (Oracle Identity management) to generate the custom reports. Some of the custom reports contain a large amount of data (approx 80-90K rows with 7-8 columns) and the query of these reports basically use the audit tables and resource form tables primarily. Now when we try to generate the report, it is working fine with HTML where report directly generate on console but the same report when we tried to generate and save in pdf or Excel it gave up with the following error.

      [120509_133712190][][STATEMENT] Generating page [1314]
      [120509_133712193][][STATEMENT] Phase2 time used: 3ms
      [120509_133712193][][STATEMENT] Total time used: 41269ms for processing XSL-FO
      [120509_133712846][oracle.apps.xdo.common.font.FontFactory][STATEMENT] type1.Helvetica closed.
      [120509_133712846][oracle.apps.xdo.common.font.FontFactory][STATEMENT] type1.Times-Roman closed.
      [120509_133712848][][PROCEDURE] FO+Gen time used: 41924 msecs
      [120509_133712848][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) is called.
      [120509_133712850][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) done. All inputs are cleared.
      [120509_133712850][oracle.apps.xdo.template.FOProcessor][STATEMENT] End Memory: max=496MB, total=496MB, free=121MB
      [120509_133818606][][EXCEPTION] java.net.SocketException: Socket closed
      at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)
      at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
      at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:525)
      at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:504)
      at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:382)
      at weblogic.servlet.internal.ChunkOutput.checkForFlush(ChunkOutput.java:469)
      at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:304)
      at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:139)
      at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:169)
      at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)
      at oracle.apps.xdo.servlet.util.IOUtil.readWrite(IOUtil.java:47)
      at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:280)
      at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:82)
      at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:562)
      at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:265)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:270)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:250)
      at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:178)
      at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:201)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:97)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(Unknown Source)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

      It seems where the querry processing is taking some time we are facing this issue.Do i need to perform any additional configuration to generate such reports?
        • 1. Re: Error in Generating reports with large amount of data using OBIR
          K Tanna
          Hi,
          Were you able to find a solution for the same?We are facing the same problem.
          • 2. Re: Error in Generating reports with large amount of data using OBIR
            912604
            java.net.SocketException: Socket closed
                 at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)
                 at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
                 at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:525)
                 at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:504)
                 at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:382)
                 at weblogic.servlet.internal.CharsetChunkOutput.flush(CharsetChunkOutput.java:249)
                 at weblogic.servlet.internal.ChunkOutput.checkForFlush(ChunkOutput.java:469)
                 at weblogic.servlet.internal.CharsetChunkOutput.implWrite(CharsetChunkOutput.java:396)
                 at weblogic.servlet.internal.CharsetChunkOutput.write(CharsetChunkOutput.java:198)
                 at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:139)
                 at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:169)
                 at com.tej.systemi.util.AroundData.copyStream(AroundData.java:311)
                 at com.tej.systemi.client.servlet.servant.Newdownloadsingle.producePageData(Newdownloadsingle.java:108)
                 at com.tej.systemi.client.servlet.servant.BaseViewController.serve(BaseViewController.java:542)
                 at com.tej.systemi.client.servlet.FrontController.doRequest(FrontController.java:226)
                 at com.tej.systemi.client.servlet.FrontController.doPost(FrontController.java:128)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(Unknown Source)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:17

            (Please help finding a solution in this issue its in production and we need to ASAP)

            Thanks in Advance

            Edited by: 909601 on Jan 23, 2012 2:05 AM