2 Replies Latest reply on Oct 25, 2006 3:11 PM by 470644

    REP-56048 report error

    470644
      I have REP-56048 report error when print in SPREADSHEET format more than 4000 rows.
      Our release is 10.1.2.0.2
      Exist a patch that resolve this problem?
      Thanks
        • 1. Re: REP-56048 report error
          516409
          Have a look at this link...There are some information about the error message you have mentioned. Hope this helps.
          http://matrix.csustan.edu/docs/oracle/oas/bi.1012/b14048/pbr_trouble.htm#BABEEBAC
          • 2. Server Trace: REP-56048 report error
            470644
            Follows the Trace of the report job that cause the Engine Crash
            The crash is systematic when we try to report over than 5000 rows
            in DESFORMAT=SPREADSHEET
            Same rerport in HTML or PDF doesn't any problem.

            Trace when DESFORMAT=SPREADSHEET
            [2006/10/25 4:14:49:851] Info 56021 (EngineManager:spawnEngine): Engine rwEng-0 has been launched
            [2006/10/25 4:14:49:851] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Initial
            [2006/10/25 4:14:49:851] Debug 50103 (JobManager.runJobLocal): No Engine available for Job 562
            [2006/10/25 4:14:49:851] Info 56015 (JobManager:dispatch): Job 562 is waiting in current job queue
            [2006/10/25 4:14:49:851] Debug 56031 (ConnectionImpl:runJob): Job 562 is waiting for notification
            [2006/10/25 4:14:50:320] Debug 50103 (JobManager:runCurrentJobs): Job 562 is a sync job :true
            [2006/10/25 4:14:51:320] Debug 50103 (JobManager:runCurrentJobs): Job 562 is a sync job :true
            [2006/10/25 4:14:52:320] Debug 50103 (JobManager:runCurrentJobs): Job 562 is a sync job :true
            [2006/10/25 4:14:52:773] Info 56026 (EngineManager:registerEngine): Reports Server started up engine rwEng-0
            [2006/10/25 4:14:52:789] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-0 status is 1
            [2006/10/25 4:14:52:789] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Ready
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager:firstToRun): job 562 is first to run
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager:runCurrentJob): notify job 562
            [2006/10/25 4:14:52:789] Debug 56032 (ConnectionImpl:runJob): Job 562 is notified
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager:firstToRun): job 562 is first to run
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager.runJobLocal): Trying to get engine for Job 562
            [2006/10/25 4:14:52:789] Debug 50103 (EngineManager:getIdleEngine): Target max engines = 1
            [2006/10/25 4:14:52:789] Debug 50103 (EngineManager:getIdleEngine): rwEng-0 is used = true
            [2006/10/25 4:14:52:789] Debug 50103 (EngineManager:getIdleEngine): rwEng-0 state is 1
            [2006/10/25 4:14:52:789] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Reserved
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager.runJobLocal): Job 562 got Engine rwEng-0
            [2006/10/25 4:14:52:789] Debug 50103 (JobManager:runJobInEngine): Job 562 calling setCommand on engine rwEng-0
            [2006/10/25 4:14:52:789] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-0 status is 3
            [2006/10/25 4:14:52:789] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Running
            [2006/10/25 4:14:52:804] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-0 status is 5
            [2006/10/25 4:14:52:804] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Idle
            [2006/10/25 4:14:52:804] Debug 50103 (JobManager:runJobInEngine): Send job 562 to engine rwEng-0
            [2006/10/25 4:14:52:804] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-0 status is 3
            [2006/10/25 4:14:52:804] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Running
            [2006/10/25 4:14:53:539] State 56016 (JobManager:updateJobStatus): Job 562 status is: Esecuzione del report Inizializzazione report
            [2006/10/25 4:14:53:539] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 562
            [2006/10/25 4:14:54:273] State 56016 (JobManager:updateJobStatus): Job 562 status is: Esecuzione del report Formattazione pagina 1
            [2006/10/25 4:14:54:273] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 562

            [2006/10/25 4:16:54:896] (ConnectionImpl:getServerRunningInfo) enter...
            [2006/10/25 4:16:54:896] (ConnectionImpl:getServerRunningInfo) ...exit
            [2006/10/25 4:16:54:896] Info 56013 (ConnectionManager:release): Connection 10849 is released
            [2006/10/25 4:17:2:692] (ConnectionImpl:getServerRunningInfo) enter...
            [2006/10/25 4:17:2:692] (ConnectionImpl:getServerRunningInfo) ...exit
            [2006/10/25 4:17:2:692] Info 56013 (ConnectionManager:release): Connection 10850 is released
            [2006/10/25 4:17:5:395] (ConnectionImpl:getServerRunningInfo) enter...
            [2006/10/25 4:17:5:395] (ConnectionImpl:getServerRunningInfo) ...exit
            [2006/10/25 4:17:5:395] Info 56013 (ConnectionManager:release): Connection 10851 is released
            [2006/10/25 4:17:7:567] (ConnectionImpl:getServerRunningInfo) enter...
            [2006/10/25 4:17:7:567] (ConnectionImpl:getServerRunningInfo) ...exit
            [2006/10/25 4:17:7:567] Info 56013 (ConnectionManager:release): Connection 10852 is released

            [2006/10/25 4:17:35:926] Exception 50125 (org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 208 completed: Maybe
            at com.sun.corba.se.internal.iiop.IIOPConnection.purge_calls(IIOPConnection.java:438)
            at com.sun.corba.se.internal.iiop.ReaderThread.run(ReaderThread.java:70)
            ): Errore interno org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 208 completed: Maybe
            [2006/10/25 4:17:35:926] Info 56029 (EngineManager:shutdownEngine): Shutting down engine rwEng-0
            [2006/10/25 4:17:36:989] Exception 50125 (org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 201 completed: No
            at com.sun.corba.se.internal.iiop.ConnectionTable.getConnection(ConnectionTable.java:148)
            at com.sun.corba.se.internal.iiop.ConnectionTable.getConnection(ConnectionTable.java:65)
            at com.sun.corba.se.internal.iiop.GIOPImpl.getConnection(GIOPImpl.java:67)
            at com.sun.corba.se.internal.corba.ClientDelegate.createRequest(ClientDelegate.java:652)
            at com.sun.corba.se.internal.corba.ClientDelegate.createRequest(ClientDelegate.java:594)
            at com.sun.corba.se.internal.corba.ClientDelegate.request(ClientDelegate.java:886)
            at org.omg.CORBA.portable.ObjectImpl._request(ObjectImpl.java:431)
            at oracle.reports.engine._EngineClassStub.shutdown(_EngineClassStub.java:173)
            at oracle.reports.server.EngineManager.shutdownEngine(EngineManager.java:1354)
            at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:974)
            at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1779)
            at oracle.reports.server.JobManager.dispatch(JobManager.java:1045)
            at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1280)
            at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
            at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
            at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
            at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
            at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)
            ): Errore interno org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 201 completed: No
            [2006/10/25 4:17:36:989] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Shutdown
            [2006/10/25 4:17:36:989] Info 56047 (EngineManager:remove): Reports Server shut down engine rwEng-0
            [2006/10/25 4:17:36:989] State 56016 (JobManager:updateJobStatus): Job 562 status is: Terminato con errore:
            REP-56048: Crash del motore rwEng-0, job Id: 562
            [2006/10/25 4:17:36:989] Debug 50103 (JobManager:notifyWaitingJobs): Master job 562 notify its duplicated jobs.
            [2006/10/25 4:17:36:989] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 562
            [2006/10/25 4:17:36:989] Exception 56048 (): Crash del motore rwEng-0, job Id: 562
            oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
            at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1009)
            at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1779)
            at oracle.reports.server.JobManager.dispatch(JobManager.java:1045)
            at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1280)
            at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
            at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
            at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
            at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
            at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)
            [2006/10/25 4:17:36:989] Debug 50103 (JobManager:runJobInEngine): Encounted exception in job 562
            [2006/10/25 4:17:36:989] Debug 50103 (ConnectionImpl:runJob): jobid = 562 Failed with exceptionoracle.reports.RWException:
            IDL:oracle/reports/RWException:1.0
            [2006/10/25 4:17:36:989] Exception 56048 (): Crash del motore rwEng-0, job Id: 562
            oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
            at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1009)
            at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1779)
            at oracle.reports.server.JobManager.dispatch(JobManager.java:1045)
            at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1280)
            at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
            at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
            at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
            at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
            at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)



            Thanks for help
            F.Manni