This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Feb 5, 2008 8:05 AM by 488171 RSS

Apps Adapter not dequeuing Business Event Messeages.

user570355 Newbie
Currently Being Moderated
Hi,
I am having a BPEL process which gets invoked by a business event that gets triggered in oracle apps R12 instance. I am using AppsAdapter to listen to the event.
It seems i've got everything correctly in place.
Queue: WF_BPEL_Q
Queue Table : WF_BPEL_QTAB
Agent listeners are also up and running.

I can see message data getting inserted into Queue table when event gets raised.
However, BPEL process is somehow not getting invoked since messages in the queue are not being consumed.

In domain.log file, i can see the following error:

<2007-09-14 13:18:45,553> <ERROR> <default.collaxa.cube.activation> <AdapterFramework::Inbound> [DEQUEUE_ptt::DEQUEUE(WF_EVENT_T)]BPEL JCA Listener was unable prepare delivery of inbound message to BPEL Process 'bpel://localhost/default/TestInvokeBPELFromEvent~1.0/' due to: ORA-00942: table or view does not exist

Can anyone throw some lights?

Thanks-
Ashish.
  • 1. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    Check credentials (login and password). Check schema.
    Where did you place you queue?
  • 2. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    Check credentials (login and password).
         credentials of what?

    Check schema.
         XML Schema?
         
    Where did you place you queue?
         Queue has been placed on the same database which was useed to create AppsAdapter.
  • 3. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    Check credentials (login and password).
    credentials of what?
    Credentials of schema where you placed your queue.

    Check schema.
    XML Schema?
    Schema where you placed your queue.

    Where did you place you queue?
    Queue has been placed on the same database which was useed to create AppsAdapter.
    I mean that may be you loging in to this database by one user and queue is another schema and adapter does'not see it.
  • 4. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    Wow, that was quick! Thanks!.

    1) Credentials of schema: apps/apps
    Queue name: WF_BPEL_Q
    Owner: APPS

    Queue table name: WF_BPEL_QTAB
    Owner: APPS

    2) Queue is placed on APPS schema as mentioned above.

    3) It doesn't leave any possibility for the third case you mentioned since everything is APPS here. :-)

    Can you think of anyother possible cause for this error?
    I Checked metalink for possible bug to no avail. :-(

    Thanks-
    Ashish.
  • 5. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    I've made a simple example as you provide - it works on R12!

    Try simple testcase:
    1) Create simple Event in BES, with one subscription - Out Agent = WF_BPEL_QAGENT@PFA3.RU.ORACLE.COM, Phase = 50, rule data=Key, source=Local
    2) Create simple BPEL process - first step of BPEL is receive from OEBS adapter which setted on outbound BES event.Not forget to Create Instance checkbox. And than an Empty step (next).
    3) May be BPEL generate subscriiption for you, I didn't examine because some strange suscription was generated... In this case modify it phase to 50 to start it immediatelly when event fired.

    Then do BES metadata update (IT'S CRITICAL IN R12!):
    begin
    wf_bes_cache.SetMetaDataUploaded;
    end;

    and test you Event (through Test Event).
    You should found new instance of BPEL process.... I see!
  • 6. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    did all you suggested. Still no luck.! :(
    I found what is causing the problem: and that is messages getting rejected by Adapter Framework before BPEL process gets invoked.
    I tried putting RejectionHandler in my process deployment descriptor (bpel.xml) and rejection handler gets called and it tries to put the message (bad message) into rejection queue specified in it. But here also it fails. giving general, not specific error.

    I would like to, though, see the message (inbound to BPEL process) generated in your example. Mine is as follows (which is reckoned as Bad by Adapter Framework.) If you can compare and figure out why it's bad, would be a great help.
    Please paste your message (which is valid) here.
    <WF_EVENT_T xmlns="http://xmlns.oracle.com/xdb/APPS">
    <PRIORITY xmlns="">50</PRIORITY>
    <SEND_DATE xmlns="">2007-09-18T17:27:06.000+05:30</SEND_DATE>
    <RECEIVE_DATE xmlns=""></RECEIVE_DATE>
    <CORRELATION_ID xmlns=""></CORRELATION_ID>
    <PARAMETER_LIST xmlns="">
    <PARAMETER_LIST_ITEM>
    <NAME>FND_RESPONSIBILITY_ID</NAME>
    <VALUE>56084</VALUE>
    </PARAMETER_LIST_ITEM>
    <PARAMETER_LIST_ITEM>
    <NAME>FND_RESPONSIBILITY_APPS_ID</NAME>
    <VALUE>0</VALUE>
    </PARAMETER_LIST_ITEM>
    </PARAMETER_LIST>
    <EVENT_NAME xmlns="">oracle.apps.fnd.resp.update</EVENT_NAME>
    <EVENT_KEY xmlns="">56084:0</EVENT_KEY>
    <EVENT_DATA xmlns=""></EVENT_DATA>
    <FROM_AGENT xmlns="">
    <NAME>WF_BPEL_QAGENT</NAME>
    <SYSTEM>VIS.IN.IBM.COM</SYSTEM>
    </FROM_AGENT>
    <TO_AGENT xmlns=""/>
    <ERROR_SUBSCRIPTION xmlns=""></ERROR_SUBSCRIPTION>
    <ERROR_MESSAGE xmlns=""></ERROR_MESSAGE>
    <ERROR_STACK xmlns=""></ERROR_STACK>
    </WF_EVENT_T>

    Thanks-
    Ashish.
  • 7. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    My message is similar to yours. I don't think the problem in message.
    Theck error message carefully and try to debug.
    By the way what version of BPEL do you use. As for me it's SOA Suite 10.1.3.1.0

    My message:
    select t.user_data from WF_BPEL_QTAB t order by t.enq_time desc

    USER_DATA.PRIORITY     50
    USER_DATA.SEND_DATE     19.09.2007 11:14:58
    USER_DATA.RECEIVE_DATE     
    USER_DATA.CORRELATION_ID     
    USER_DATA.PARAMETER_LIST     <Collection> (NULL)
    USER_DATA.EVENT_NAME     oracle.apps.xxt.Test
    USER_DATA.EVENT_KEY     432353453456345645634
    USER_DATA.EVENT_DATA     <CLOB> (NULL)
    USER_DATA.FROM_AGENT.NAME     WF_BPEL_QAGENT
    USER_DATA.FROM_AGENT.SYSTEM     PFA3.RU.ORACLE.COM
    USER_DATA.TO_AGENT.NAME     
    USER_DATA.TO_AGENT.SYSTEM     
    USER_DATA.ERROR_SUBSCRIPTION     
    USER_DATA.ERROR_MESSAGE     
    USER_DATA.ERROR_STACK
  • 8. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    If it can help you here is my

    ============================================================
    OEBS_AQ.bpel
    ============================================================
    <?xml version = "1.0" encoding = "UTF-8" ?>
    <!--
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    Oracle JDeveloper BPEL Designer

    Created: Mon Sep 17 19:05:06 MSD 2007
    Author: ogrishko
    Purpose: Asynchronous BPEL Process
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    -->
    <process name="OEBS_AQ" targetNamespace="http://xmlns.oracle.com/OEBS_AQ"
    xmlns="http://schemas.xmlsoap.org/ws/2003/03/business-process/"
    xmlns:xp20="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.Xpath20"
    xmlns:bpws="http://schemas.xmlsoap.org/ws/2003/03/business-process/"
    xmlns:ns1="http://xmlns.oracle.com/pcbpel/adapter/apps/tstOEBS12/"
    xmlns:ldap="http://schemas.oracle.com/xpath/extension/ldap"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:ns2="http://xmlns.oracle.com/xdb/APPS"
    xmlns:client="http://xmlns.oracle.com/OEBS_AQ"
    xmlns:bpelx="http://schemas.oracle.com/bpel/extension"
    xmlns:ora="http://schemas.oracle.com/xpath/extension"
    xmlns:orcl="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc">
    <!--
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    PARTNERLINKS
    List of services participating in this BPEL process
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    -->
    <partnerLinks>
    <!--
    The 'client' role represents the requester of this service. It is
    used for callback. The location and correlation information associated
    with the client role are automatically set using WS-Addressing.
    -->
    <partnerLink myRole="DEQUEUE_role" name="tstOEBS12"
    partnerLinkType="ns1:DEQUEUE_plt"/>
    </partnerLinks>
    <!--
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    VARIABLES
    List of messages and XML documents used within this BPEL process
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    -->
    <variables>
    <!-- Reference to the message passed as input during initiation -->
    <variable name="Receive_1_DEQUEUE_InputVariable"
    messageType="ns1:WF_EVENT_T_msg"/>
    </variables>
    <!--
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    ORCHESTRATION LOGIC
    Set of activities coordinating the flow of messages across the
    services integrated within this business process
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    -->
    <sequence name="main">
    <!-- Receive input from requestor. (Note: This maps to operation defined in OEBS_AQ.wsdl) -->
    <receive name="Receive_1" partnerLink="tstOEBS12"
    portType="ns1:DEQUEUE_ptt" operation="DEQUEUE"
    variable="Receive_1_DEQUEUE_InputVariable"
    createInstance="yes"/>
    <!--
    Asynchronous callback to the requester. (Note: the callback location and correlation id is transparently handled using WS-addressing.)
    -->
    <empty name="Empty_1"/>
    </sequence>
    </process>
    ============================================================
    ============================================================
    tstOEBS12.wsdl
    ============================================================
    <definitions
    name="tstOEBS12"
    targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/apps/tstOEBS12/"
    xmlns="http://schemas.xmlsoap.org/wsdl/"
    xmlns:tns="http://xmlns.oracle.com/pcbpel/adapter/apps/tstOEBS12/"
    xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
    xmlns:jca="http://xmlns.oracle.com/pcbpel/wsdl/jca/"
    xmlns:pc="http://xmlns.oracle.com/pcbpel/"
    xmlns:imp1="http://xmlns.oracle.com/xdb/APPS"
    xmlns:obj1="http://xmlns.oracle.com/xdb/APPS"
    xmlns:hdr="http://xmlns.oracle.com/pcbpel/adapter/aq/inbound/"
    >
    <import namespace="http://xmlns.oracle.com/pcbpel/adapter/aq/inbound/" location="aqAdapterInboundHeader.wsdl"/>
    <types>
    <schema xmlns="http://www.w3.org/2001/XMLSchema" >
    <import namespace="http://xmlns.oracle.com/xdb/APPS" schemaLocation="APPS_WF_EVENT_T.xsd" />
    </schema>
    </types>
    <message name="WF_EVENT_T_msg">
    <part name="WF_EVENT_T" element="imp1:WF_EVENT_T"/>
    </message>
    <portType name="DEQUEUE_ptt">
    <operation name="DEQUEUE">
    <input message="tns:WF_EVENT_T_msg"/>
    </operation>
    </portType>
    <binding name="DEQUEUE_binding" type="tns:DEQUEUE_ptt">
    <pc:inbound_binding />
    <operation name="DEQUEUE">
    <jca:operation
    ActivationSpec="oracle.tip.adapter.apps.AppsWFBesQueueDequeueActivationSpec"
    QueueName="WF_BPEL_Q"
    DatabaseSchema="APPS"
    Consumer="ORA_6co36chk74o36d1h6p132chg65"
    MessageSelectorRule="tab.user_data.event_name = &apos;oracle.apps.xxt.Test&apos;"
    OpaqueSchema="false" >
    </jca:operation>
    <input>
    <jca:header message="hdr:Header" part="Header"/>
    </input>
    </operation>
    </binding>
    <service name="tstOEBS12">
    <port name="DEQUEUE_pt" binding="tns:DEQUEUE_binding">
    <!--Your runtime connection is declared in
    J2EE_HOME/application-deployments/default/AppsAdapter/oc4j-ra.xml
    These mcf properties here are from your design time connection and
    save you from having to edit that file and restart the application server
    if eis/Apps/ftas_dev_OEBS is missing.
    These mcf properties are safe to remove.-->
    <jca:address location="eis/Apps/ftas_dev_OEBS" UIConnectionName="ftas_dev_OEBS" UIOracleAppType="WFBES" UIWfEventName="oracle.apps.xxt.Test"
    ManagedConnectionFactory="oracle.tip.adapter.apps.AppsManagedConnectionFactory"
    mcf.ConnectionString="jdbc:oracle:thin:@l2.ru.oracle.com:1522:pfa3"
    mcf.UserName="apps"
    mcf.Password="****************" />
    </port>
    </service>
    <plt:partnerLinkType name="DEQUEUE_plt" >
    <plt:role name="DEQUEUE_role" >
    <plt:portType name="tns:DEQUEUE_ptt" />
    </plt:role>
    </plt:partnerLinkType>
    </definitions>
    ============================================================

    Message was edited by:
    occ2000
  • 9. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    Thanks again for your time.
    Compared both the files you've sent with mine, line by line.
    No difference at all..

    Wondering why AQ Adapter Framework rejects my message. What is that which qualifies the message as good message or bad message? I guess that should give me some direction for troubleshooting this issue.

    Btw, I am using the following BPEL PM: (:))
    Oracle BPEL Server version 10.1.3.1.0
    Build: 0
    Build type: release
    Source tag: PCBPEL_10.1.3.1.0_GENERIC_061009.0802

    Hoping for hearing something from you.

    Thanks-
    Ashish.
  • 10. Re: Apps Adapter not dequeuing Business Event Messeages.
    159563 Newbie
    Currently Being Moderated
    May be you have problems with adapters.
    Try to reinstall BPEL in a clear Application Server. I recommend you to install last release SOA Suite.
    Try to use different adapter to see if anything work, for ex AQ adapter and publish in AQ using DBMS_AQ...
  • 11. Re: Apps Adapter not dequeuing Business Event Messeages.
    130180 Newbie
    Currently Being Moderated
    Hi all

    I just applied a patch to 10.1.3.3 to fix this issue!!

    The number is: 6267726.

    The problem seemed to manifest itself in the namespace being changed during dequeue to something other than the BPEL process or ESB process expected. Seems to work fine now!

    Hope this helps

    Chris
  • 12. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    Hey Chris,
    Thanks a lot for sharing this piece of information.
    Will try to get this patch applied and test it out.

    With regards-
    Ashish.
  • 13. Re: Apps Adapter not dequeuing Business Event Messeages.
    Abhisheksaurabh Newbie
    Currently Being Moderated
    Hi Ashish,

    Are you able to find the solution for the problem after applying the patch.

    Abhi...
  • 14. Re: Apps Adapter not dequeuing Business Event Messeages.
    user570355 Newbie
    Currently Being Moderated
    Abhishek, we've got the latest version of SOA Suite. And it worked.

    Ashish.
1 2 Previous Next