This discussion is archived
4 Replies Latest reply: Mar 25, 2013 11:02 AM by user5716448 RSS

process flow hanging in owb 11.2.0.2

728844 Newbie
Currently Being Moderated
Hello All,

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

SELECT MIN(MSGID)
FROM WB_RT_NOTIFY_QUEUE_TAB N1
WHERE PRIORITY = (
SELECT MIN(N2.MSG_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 )

; END;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points