How to Manually Process the Events from Workflow Queues When The Deferred Agent Listener Won't Start (Doc ID 953103.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Workflow Cartridge - Version 11.5.9 to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 27-JUL-2013


Symptoms

The Workflow Agent Listener goes down with 10 consecutive errors due to the unwanted / corrupted events from the queue.

Running the following select shows reflects a large volume of subscriptions on this queue with no correlation id:

SQL> select corr_id, msg_state, count(*) from applsys.aq$wf_deferred group by corr_id, msg_state;


The output may resemble:


CORR_ID MSG_STATE COUNT(*)
APPS:oracle.apps.gl.CloseProcess.period.open READY 4
APPS:oracle.apps.ar.transaction.Invoice.complete READY 1
APPS:oracle.apps.ar.batch.AutoInvoice.run READY 2
APPS:oracle.apps.ap.payment READY 33
APPS:oracle.apps.po.rcv.rcvtxn READY 1
APPS READY 729442

 

Changes

Generally this kind of issues occurs after a new clone was performed from Production, but it may occur from various other reasons.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms