My process flow keeps on running and never completes but in the design center I see that my maps have all completed, I checked my tables and the data has been loaded.
There is this process running in the background. I don't know what this is trying to do.
How could i solve this problem.
select /*+ FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration ,tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data
from "OWBSYS"."WB_RT_NOTIFY_QUEUE_TAB" tab
where q_name = :1 and corrid = :2 and (state = :3 ) for update skip locked
FROM WB_RT_NOTIFY_QUEUE_TAB N1
WHERE PRIORITY = (
FROM AQ$WB_RT_NOTIFY_QUEUE_TAB N2
WHERE N2.CORR_ID = :B1 AND MSG_STATE = 'READY') AND N1.CORRID = :B1
BEGIN wb_rt_notification.wait( :1 , :2 ,
:3 , :4 , :5 )
We are dealing with the same issue. Is this solved yet at your site?
I also note there are lots of records in WB_RT_NOTIFY_QUEUE_TAB. A lot of the AQ$_WB_RT_NOTIFY_QUEUE_TAB_E records are pretty old
Can I just delete them?
SQL> select count(*), Q_NAME from owbsys.WB_RT_NOTIFY_QUEUE_TAB group by Q_NAME;
best regards, Hans