how to rebuild the wf_java_deferred queue

Followings steps are to be followed to rebuild the queue (1) Check to see what records will be backed up on the wf_queue_temp_jms_table backup table. select wfjd.corr_id corrid, msg_state state, count(*) COUNTfrom applsys.aq$wf_java_deferred wfjdwhere msg_state IN(‘READY’, ‘WAIT’)group by corr_id, wfjd.msg_state; (2) Shut down the Workflow Agent Listener Service and backup the records on the WF_JAVA_DEFERRED …

how to rebuild the wf_java_deferred queue Read More »