2 Replies Latest reply on Mar 11, 2011 6:20 PM by 846311

    Reports Builder works fine but not AS !?

    846311
      Hello,


      A report with 16 ref cursors works fine in ReportsBuilder...
      When i recompile it on my AS 10.1.2.0.2 and i call it by url, the reports seems to be freeze...my engine's trace stay on "EXCECUTE QUERY" order.
      Have any ideas ?

      Cheers
        • 1. Re: Reports Builder works fine but not AS !?
          Huge10
          Could you add some more information at the request?

          For example:
          Your Reports Builder point the same Database?
          How much is big your database?
          How may engine are UP on your AS?

          Bye
          • 2. Re: Reports Builder works fine but not AS !?
            846311
            Here it is...Hope you can help me :)

            Platform:
            Forms & Reports Services Standalone v.10.1.2.3 (Windows 2003 Server).
            Database : 10.2.0.1 (Windows 2003 Server)


            <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="3" minEngine="1" engLife="50" maxIdle="240" callbackTimeOut="90000" jvmOptions="-Xmx1024M -Xms512M -Xss512k">
            <property name="diagnosis" value="yes"/>
            </engine>

            #######################
            Extract from rwserver.trc

            [2011/3/11 11:16:53:241] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 237
            [2011/3/11 11:16:53:537] 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)
            ): Erreur interne org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 208 completed: Maybe
            [2011/3/11 11:16:53:537] Info 56029 (EngineManager:shutdownEngine): Shutting down engine rwEng-0
            [2011/3/11 11:16:54:522] 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:1473)
                 at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1033)
                 at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1912)
                 at oracle.reports.server.JobManager.dispatch(JobManager.java:1152)
                 at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1285)
                 at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
                 at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
                 at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
                 at com.sun.corba.se.internal.iiop.LocalClientRequestImpl.invoke(LocalClientRequestImpl.java:98)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:235)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:282)
                 at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:457)
                 at oracle.reports.server._ConnectionStub.runJob(_ConnectionStub.java:492)
                 at oracle.reports.client.ReportRunner.dispatchReport(ReportRunner.java:290)
                 at oracle.reports.rwclient.RWReportRunner.dispatchReport(RWReportRunner.java:86)
                 at oracle.reports.rwclient.RWClient.runReport(RWClient.java:1671)
                 at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1525)
                 at oracle.reports.rwclient.RWClient.doPost(RWClient.java:504)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
                 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:674)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
                 at java.lang.Thread.run(Thread.java:534)
            ): Erreur interne org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 201 completed: No
            [2011/3/11 11:16:54:522] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Shutdown
            [2011/3/11 11:16:54:522] Info 56047 (EngineManager:remove): Reports Server shut down engine rwEng-0
            [2011/3/11 11:16:54:522] State 56016 (JobManager:updateJobStatus): Job 237 status is: Terminé avec erreur :
            REP-56048: Le moteur rwEng-0 sest arrêté brutalement., job Id: 237
            [2011/3/11 11:16:54:522] Debug 50103 (JobObject:writeLongUTF): Number of Break Index values=0
            [2011/3/11 11:16:54:522] Exception 50125 (java.lang.StringIndexOutOfBoundsException: String index out of range: 57
                 at java.lang.String.<init>(String.java:196)
                 at oracle.reports.server.JobObject.writeLongUTF(JobObject.java:497)
                 at oracle.reports.server.JobObject.writeExternal(JobObject.java:253)
                 at oracle.reports.server.JobStore.writePersistFile(JobStore.java:559)
                 at oracle.reports.server.JobManager.moveJob(JobManager.java:1290)
                 at oracle.reports.server.JobManager.updateJobStatus(JobManager.java:2314)
                 at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1110)
                 at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1912)
                 at oracle.reports.server.JobManager.dispatch(JobManager.java:1152)
                 at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1285)
                 at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
                 at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
                 at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
                 at com.sun.corba.se.internal.iiop.LocalClientRequestImpl.invoke(LocalClientRequestImpl.java:98)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:235)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:282)
                 at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:457)
                 at oracle.reports.server._ConnectionStub.runJob(_ConnectionStub.java:492)
                 at oracle.reports.client.ReportRunner.dispatchReport(ReportRunner.java:290)
                 at oracle.reports.rwclient.RWReportRunner.dispatchReport(RWReportRunner.java:86)
                 at oracle.reports.rwclient.RWClient.runReport(RWClient.java:1671)
                 at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1525)
                 at oracle.reports.rwclient.RWClient.doPost(RWClient.java:504)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
                 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:674)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
                 at java.lang.Thread.run(Thread.java:534)
            ): Erreur interne java.lang.StringIndexOutOfBoundsException: String index out of range: 57
            [2011/3/11 11:16:54:522] Debug 50103 (JobManager:notifyWaitingJobs): Master job 237 notify its duplicated jobs.
            [2011/3/11 11:16:54:522] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 237
            [2011/3/11 11:16:54:522] Exception 56048 (): Le moteur rwEng-0 sest arrêté brutalement., job Id: 237
            oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
                 at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1116)
                 at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1912)
                 at oracle.reports.server.JobManager.dispatch(JobManager.java:1152)
                 at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1285)
                 at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
                 at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
                 at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
                 at com.sun.corba.se.internal.iiop.LocalClientRequestImpl.invoke(LocalClientRequestImpl.java:98)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:235)
                 at com.sun.corba.se.internal.corba.ClientDelegate.invoke(ClientDelegate.java:282)
                 at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:457)
                 at oracle.reports.server._ConnectionStub.runJob(_ConnectionStub.java:492)
                 at oracle.reports.client.ReportRunner.dispatchReport(ReportRunner.java:290)
                 at oracle.reports.rwclient.RWReportRunner.dispatchReport(RWReportRunner.java:86)
                 at oracle.reports.rwclient.RWClient.runReport(RWClient.java:1671)
                 at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1525)
                 at oracle.reports.rwclient.RWClient.doPost(RWClient.java:504)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
                 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
                 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:674)
                 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
                 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
                 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
                 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
                 at java.lang.Thread.run(Thread.java:534)

            #######################
            Extract from rwEng-0-c-2011-03-11_11-16-26.dig

            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Enter
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Rebinding
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rdrslv
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rdrslv returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling ropexe2 for ref cursor
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe2): Enter
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Enter
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Before calling depxcrun()
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): After calling depxcrun(), status: 0
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Exit, ecod: 0
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe2): Exit
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): ropexe2 returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rosrenew
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rosrenew returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rosnxt for ref cursor
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rosnxt returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rdcaag
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rdcaag returned successfully
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Exit
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Enter
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rosnxt for ref cursor
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rosnxt returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rdcaag
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rdcaag returned successfully
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Exit
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Enter
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Rebinding
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rdrslv
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rdrslv returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling ropexe2 for ref cursor
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe2): Enter
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Enter
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Before calling depxcrun()
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): After calling depxcrun(), status: 0
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe): Exit, ecod: 0
            [2011/03/11 11:16:53] Diagnosis (ropexe:ropexe2): Exit
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): ropexe2 returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rosrenew
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): rosrenew returned
            [2011/03/11 11:16:53] Diagnosis (rdftch:rdftch): Calling rosnxt for ref cursor

            The last trace before the engine crash ;(