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

Posted by Harikrishna Gogineni on Jul 16, 2018; 2:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-Error-Agent-Listener-agent-Automatic-component-frequently-going-to-system-deactivated-status-tp6412.html

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