rss
SOATUBE
Oracle
Custom Search SOABYTE here

Monday, February 15, 2010

Working with business events troubleshooting




















SELECT ENQUEUE_ENABLED, DEQUEUE_ENABLED

 FROM all_queues

WHERE NAME LIKE  ''


Also check the status of the queue from

SELECT ENQUEUE_ENABLED, DEQUEUE_ENABLED
 FROM all_queues
WHERE NAME LIKE  ''

If the values are NO .. then start the queue

--To start the queue
BEGIN
DBMS_AQADM.Start_Queue (queue_name => '');
END;

--To stop the queue
BEGIN
DBMS_AQADM.STOP_QUEUE
         (queue_name => '',
          enqueue    => TRUE,
          dequeue    => TRUE,
          wait       => TRUE);
            END;


Did you check the status of the message in the Queue??

There is a status (STATE) column in the queue, having values 0, 1, 2…

Similarly u can find the view for your queue (view name starts AQ$)… check the status (MSG_STATE) of the message from this view. It will give the exact status of the message (like, is it ready, waiting, etc..)

SELECT *
FROM all_queues
WHERE NAME LIKE  '%ALERT%' --- QNAME

SELECT MSG_STATE ------- CHECK THE VALUE IN THIS COLUMN FOR THE EVENT
    FROM AQ$WF_BPEL_QTAB


Checking available subscription :--



select * from wf_event_subscriptions where event_filter_guid in(
select guid from wf_events where name = 'oracle.apps.wsh.trip.gen.shipconfirmed')
and out_agent_guid in ( select guid from wf_agents where name = 'WF_BPEL_QAGENT');



If there are no subscriptions for the business events or if there are multiple subscriptions in subscription list pointing to the same system, then drop all and recreate the subscriptions.
       The drop and create sql files are automatically created when Oracle Apps adapter is configured.One can find these files in project folder.

1 comments:

Post a Comment

 
Blogger Profile