7 Replies Latest reply on Jun 22, 2010 8:20 AM by 780707

    Soademo: submitted order doesn't invoke OrderBooking BPEL process

    684636
      I have installed the SOADEMO on windows running under Oracle Application Server 10.1.3.4 and can successfully build and deploy all modules.

      Walking through the Order Booking Application in Chapter 3 of the SOA QuickStart Guide, I find that I can connect as the "sking@soademo.org" customer and generate an order as described and receive a message indicating that the order is "submitted" (Section 3.1.2 of the tutorial). However when I attempt to view the order in BPEL Control as described in section 3.1.3 of the tutorial, no new instances are found under 'Instance' column.

      If I then attempt to list all of sking's order history, no new orders are found. From the ORACLE_HOME\j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml, the last two messages are
      <MESSAGE>
      <HEADER>
      <TSTZ_ORIGINATING>2009-03-03T19:42:32.781+05:30</TSTZ_ORIGINATING>
      <COMPONENT_ID>tip</COMPONENT_ID>
      <MSG_TYPE TYPE="NOTIFICATION"></MSG_TYPE>
      <MSG_LEVEL>1</MSG_LEVEL>
      <HOST_ID>hostname</HOST_ID>
      <HOST_NWADDR>10.177.222.17</HOST_NWADDR>
      <MODULE_ID>esb.server.dispatch.agent</MODULE_ID>
      <THREAD_ID>16</THREAD_ID>
      <USER_ID>SYSTEM</USER_ID>
      </HEADER>
      <CORRELATION_DATA>
      <EXEC_CONTEXT_ID><UNIQUE_ID>10.177.222.17:82404:1236089550390:4</UNIQUE_ID><SEQ>13</SEQ></EXEC_CONTEXT_ID>
      </CORRELATION_DATA>
      <PAYLOAD>
      <MSG_TEXT>!!!!Message found ............for Non_Deferred with recipient :oracle.tip.esb.monitor.manager.ActivityMessageReceiver</MSG_TEXT>
      </PAYLOAD>
      </MESSAGE>
      <MESSAGE>
      <HEADER>
      <TSTZ_ORIGINATING>2009-03-03T19:45:57.859+05:30</TSTZ_ORIGINATING>
      <COMPONENT_ID>j2ee</COMPONENT_ID>
      <MSG_TYPE TYPE="ERROR"></MSG_TYPE>
      <MSG_LEVEL>1</MSG_LEVEL>
      <HOST_ID>hostname</HOST_ID>
      <HOST_NWADDR>10.177.222.17</HOST_NWADDR>
      <MODULE_ID>security</MODULE_ID>
      <THREAD_ID>13</THREAD_ID>
      <USER_ID>SYSTEM</USER_ID>
      </HEADER>
      <CORRELATION_DATA>
      <EXEC_CONTEXT_ID><UNIQUE_ID>1236089746:10.177.222.17:5836:5420:9</UNIQUE_ID><SEQ>1</SEQ></EXEC_CONTEXT_ID>
      </CORRELATION_DATA>
      <PAYLOAD>
      <MSG_TEXT>ServletException cause</MSG_TEXT>
      <SUPPL_DETAIL><![CDATA[com.evermind.server.http.HttpIOException: An established connection was aborted by the software in your host machine
           at com.evermind.server.http.EvermindServletOutputStream.write(EvermindServletOutputStream.java:210)
           at com.evermind.server.http.EvermindJSPWriter.writeOut(EvermindJSPWriter.java:542)
           at com.evermind.server.http.EvermindJSPWriter.jspflush(EvermindJSPWriter.java:439)
           at com.evermind.server.http.EvermindJSPWriter.close(EvermindJSPWriter.java:409)
           at oracle.jsp.runtime.OracleJspRuntime.extraHandlePCFinally(OracleJspRuntime.java:1910)
           at _processes._jspService(_processes.java:455)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:724)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:414)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.security.jazn.oc4j.JAZNFilter$1.run(JAZNFilter.java:400)
           at java.security.AccessController.doPrivileged(Native Method)
           at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
           at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:414)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:623)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
           at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
           at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
           at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
           at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
           at com.collaxa.cube.fe.DomainFilter.doFilter(DomainFilter.java:222)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.security.jazn.oc4j.JAZNFilter$1.run(JAZNFilter.java:400)
           at java.security.AccessController.doPrivileged(Native Method)
           at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
           at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:414)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:595)
      ]]></SUPPL_DETAIL>
      </PAYLOAD>
      </MESSAGE>

      Did anyone face the exception before ? Can anyone please help me resolving this issue ?

      Thanks
      Raj

      Edited by: user771067 on Mar 3, 2009 8:11 AM

      Edited by: user771067 on Mar 3, 2009 8:12 AM
        • 1. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
          522026
          Hi,

          can you please check

          ORACLE_HOME/opmn/logs/default...oc4j_soa....log
          1 person found this helpful
          • 2. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
            684636
            Hi Dietrich,
            I found this error from the log you specified.
            file:/D:/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_SOAOrderBooking_1.0_937b09d1bd8dae1b33b028b2871aef63.tmp/OrderSequence.wsdl [ OrderSequence_ptt::OrderSequence(OrderSequenceInput_msg,OrderSequenceOutputCollection) ] - WSIF JCA Execute of operation 'OrderSequence' failed due to: Could not create/access the TopLink Session.
            This session is used to connect to the datastore. [Caused by: Listener refused the connection with the following error:
            ORA-12519, TNS:no appropriate service handler found
            The Connection descriptor used by the client was:
            hostname:1523:XE
            ]
            ; nested exception is:
                 ORABPEL-11622
            Could not create/access the TopLink Session.
            This session is used to connect to the datastore. [Caused by: Listener refused the connection with the following error:
            ORA-12519, TNS:no appropriate service handler found
            The Connection descriptor used by the client was:
            hostname:1523:XE
            ]
            See root exception for the specific exception. You may need to configure the connection settings in the deployment descriptor (i.e. $J2EE_HOME/application-deployments/default/DbAdapter/oc4j-ra.xml) and restart the server. Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.4.0) (Build 080602)): oracle.toplink.exceptions.DatabaseException
            Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
            ORA-12519, TNS:no appropriate service handler found
            The Connection descriptor used by the client was:
            hostname:1523:XE
            Error Code: 0.

            Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
            ORA-12519, TNS:no appropriate service handler found
            The Connection descriptor used by the client was:
            hostname:1523:XE
            Error Code: 0


            This error occurred already while browsing the products, but i thought i had fixed the issue with the following
            ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE
            Now with this change and restarting the Oracle service

            But it did not resolve the problem.
            Please suggest me a solution.

            Thanks
            Raj
            • 3. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
              522026
              Hi,

              there is a problem with your database.

              is hostname:1523:XE the right connection string?
              I would expect 10.0.0.222:1521:XE.

              Can you open a telnet on the as machine like
              telnet hostname 1523?

              Can you please check that the listener is running on your database machine with lsnrctl status?
              • 4. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
                684636
                Hi Dietrich,
                I have replaced the my hostname with the text 'hostname' here in the thread. So please ignore that.

                The problem is resolved. This time i set number of processes to 600. It resolved the issue. It seems its a common issue with Oracle XE.

                Thanks
                Raj
                • 5. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
                  522026
                  Have you ever considered giving points for helpful or right answers?
                  • 6. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
                    684636
                    This is only my third thread, I have already given points for useful and correct answers for all of them.. :)
                    • 7. Re: Soademo: submitted order doesn't invoke OrderBooking BPEL process
                      780707
                      Go to modify the init.ora this script file. Modify job_queue_processes this value.
                      ###########################################
                      # Job Queues
                      ###########################################
                      job_queue_processes=200

                      As you finish it, you HAVE to restart the oracle service.
                      You can use this sql statement to check if your configuration is in effect or not.
                      select value from v$parameter where name = 'processes';