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.
0 comments:
Post a Comment