Workflow Deferred Agent Listener & Workflow Deferred Notification Agent Listener "ERROR"

[Jackie]

Hi Erman,

I need your assistance.If you help, I will be pleased.

Error >> workflow mailer not sending mail all the time,because two containers always getting error and stop itself : Workflow Deferred Agent Listener & Workflow Deferred Notification Agent Listener

when i start Workflow Deferred Agent Listener container mails can deliver but only 3 4 seconds after that is has error "Stopped with Error " and when i check Workflow Agent Listener Service Process Log;

ORA-06512: konum "APPS.WF_EVENT",  satır 2213
ORA-01086: 'WF_DISPATCH_SAVEPOINT' kayıt noktası bu oturumda hiç kurulmadı veya geçersiz
ORA-20002: 3835: 'oracle.apps.wf.notification.send' olayı için 'WF_XML.Generate' üretme fonksiyonunun yürütülmesi sırasında '-20002 - ORA-20002: [WFMLR_DOCUMENT_ERROR]' hatası oluştu.'
ORA-06512: konum "APPS.WF_EVENT",  satır 1583
ORA-06512: konum  satır 1

[ErmanArslansOracleBlog]

Check this note:

Workflow Deferred Agent Listener Stopped With ORA-01086: SAVEPOINT 'WF_DISPATCH_SAVEPOINT' Never Established (Doc ID 784646.1)

[Jackie]

I have already checked this document but not this is not my case,but ,i checked /tmp etc. file direcotry size

[ErmanArslansOracleBlog]

What is your exact EBS version?

[Jackie]

11.5.10.2

[ErmanArslansOracleBlog]

Check this doc to find out more details, there are lots of bug records in Oracle Support. It is according to the module. For ex, PO workflows have these kinds of bug in 11i.

Tracking Workflow Notification Event Messages (Doc ID 433359.1)
->


If an error occurs during dispatch of oracle.apps.wf.notification.send, the message is enqueued to WF_ERROR queue. The Error Agent Listener dispatches the ERROR subscription for oracle.apps.wf.notification.send that executes WF_XML.Error_Rule.

5. Run $FND_TOP/sql/wfmlrdbg.sql for a notification id and check the status of the message in WF_DEFERRED and WF_NOTIFICATION_OUT queue.

    PROCESSED in WF_DEFERRED - The message is enqueued to WF_NOTIFICATION_OUT

    PROCESSED in WF_NOTIFICATION_OUT - The message is sent as e-mail

    READY in WF_DEFERRED - Check if Deferred Agent Listener is running

    READY in WF_NOTIFICATION_OUT - Check if Notification Mailer is running

6. Analyzing outbound XML message for a notification id. The wfmlrdbg.sql output provides the XML message generated by WF_XML.Generate at the time the script is run. If the original XML message used by the mailer is required to be analyzed following SQL may be used.

    SELECT tab.user_data.text_lob text_lob
    FROM applsys.aq$wf_notification_out tab
    WHERE dbms_lob.instr(tab.user_data.text_lob,'&1') > 0
    /

[ErmanArslansOracleBlog]

I think, there is a message in wf_deferred queue , which your can not be handled on your system.
Rebuilkd wf_deferred may work. How To Rebuild The WF_DEFERRED Queue (Doc ID 286394.1)

Also, if you can find that message in wf_deferred queue and get rid of it, then your agent listener will start fine.

[Aditya K]

Hi Erman,

Our EBS 12.1.3. deferred agent listener is not starting up. It tries to start and go to 'Stopped with Error' and eventually shows the status 'System Deactivated'. Below is the log file message it is showing

oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {PROCESSOR_OUT_THREAD_COUNT=Outbound thread count must be 0. It is currently set to 1}.  Parameters were -> {PROCESSOR_OUT_THREAD_COUNT=1, PROCESSOR_ERROR_LOOP_SLEEP=60, LISTENER_PROCESS_EVT_COUNT=500, PROCESSOR_IN_THREAD_COUNT=2, PROCESSOR_LOOP_SLEEP=120, OUTBOUND_USER=-1, PROCESSOR_MAX_ERROR
        at oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2221)
        at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)
        at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57)


We tried to edit the parameters to make it 0. However it is still being reset to the value 0.

Any thoguhts?

[ErmanArslansOracleBlog]

Hi Aditya,

This is weird -> Outbound thread count must be 0. It is currently set to 1

Are you using Workflow mailer ? (I mean outbound - smtp)

If you are using it, you need to have outbound thread count set to 1.

If you want to set it to 0, you can try using afsvcpup.sql. i.e: "sqlplus apps/<pass> @$FND_TOP/sql/afsvcpup.sql"

As I said, "Outbound thread count must be 0. It is currently set to 1" is weird..

If you can't solve this, put the loglevel of Workflow mailer to "Statement" and then reproduce the issue. Send me the whole log file if you need further analysis.