Workflow Error Agent Listener agent(Automatic component) frequently going to system deactivated status

[Harikrishna Gogineni]

Hi Erman,

Could you please help me here? Workflow Error Agent Listener agent(Automatic component) frequently going to system deactivated status. As per Doc ID 1302169.1 we are good with temp tablespace.

Below are the errors captured in the log file during the issue.

[Jul 14, 2018 8:27:02 AM GMT]:1531556822072:-1:-1:(**my server name**):10.245.53.83:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1994166203:41270:1531556812014:400:EXCEPTION:[SVC-GSM-WFALSNRSVC-645906 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:Successfully handled component event, oracle.apps.fnd.cp.gsc.SvcComponent.start, for component 10004
[Jul 14, 2018 8:27:02 AM GMT]:1531556822279:-1:-1:(**My server name**):10.245.53.83:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1994166203:41270:1531556822279:401:ERROR:[SVC-GSM-WFALSNRSVC-645906-10004 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on begin   WF_EVENT.setNavigationParams  (  p_agentName => :1, p_navigationThreshold => :2  );  WF_EVENT.LISTEN  (  p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7  );end; -> java.sql.SQLException: ORA-20002: 3825: Error '-20002 - ORA-20002: 3101: Status row for item 'APEXP/209710', activity ID '462098' does not exist.' encountered during execution of Rule function 'WF_XML.ERROR_RULE' for event 'oracle.apps.wf.notification.send' with key '25824689'.
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1

[Jul 15, 2018 9:08:32 AM GMT]:1531645712723:-1:-1:(** my server name) :10.245.53.83:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1994166203:58559:1531645172372:111:ERROR:[SVC-GSM-WFALSNRSVC-648170-10004 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on begin   WF_EVENT.setNavigationParams  (  p_agentName => :1, p_navigationThreshold => :2  );  WF_EVENT.LISTEN  (  p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7  );end; -> java.sql.SQLException: ORA-20002: 3825: Error '-20002 - ORA-20002: 3101: Status row for item 'APEXP/208789', activity ID '462098' does not exist.' encountered during execution of Rule function 'WF_XML.ERROR_RULE' for event 'oracle.apps.wf.notification.send' with key '25829020'.
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1


[Jul 15, 2018 9:01:39 PM GMT]:1531688499908:-1:-1:(my server name):10.245.53.83:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1994166203:15056:1531687623990:45:ERROR:[SVC-GSM-WFALSNRSVC-648294-10004 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on begin   WF_EVENT.setNavigationParams  (  p_agentName => :1, p_navigationThreshold => :2  );  WF_EVENT.LISTEN  (  p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7  );end; -> java.sql.SQLException: ORA-20002: 3825: Error '-20002 - ORA-20002: 3101: Status row for item 'APEXP/171227', activity ID '462098' does not exist.' encountered during execution of Rule function 'WF_XML.ERROR_RULE' for event 'oracle.apps.wf.notification.send' with key '25828955'.
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1

[ErmanArslansOracleBlog]

If your TEMP tablespace is fine .(have the required free space all the time + not corrupted), then you are probably hitting a bug..

It may be a compilation issue as well.. ( Workflow does not recommend any specific type either NATIVE or INTERPRETED)

Please check the following document->

Workflow Notification Agent Listeners Fail with unhandled user-defined exception ORA-06512: at "APPS.WF_EVENT" (Doc ID 1066568.1)

I still recommend you to "recreate" your TEMP tablespace, restart your database and apps services and retry... (just in case)

[Harikrishna Gogineni]

Hi Erman,

Thanks for the reply..

Will try in a next maintenance window. I would need get downtime window from Tech team to test this as it a Quality Instance. Will update you the status.

Thanks,
Harikrishna

[ErmanArslansOracleBlog]

Ok. good.