Workflow Deferred Agent Listener SYSTEM DEACTIVATED With oracle.apps.fnd.cp.gsc.ProcessorException: Could not executeUpdate()
(Doc ID 1379004.1)
Last updated on MAY 19, 2024
Applies to:
Oracle Workflow - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]Information in this document applies to any platform.
Symptoms
Trying to start the Workflow Deferred Agent Listener, but it stops on its own and going to a "System Deactivated" state and the Workflow Agent Listener log shows the following error:
1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:xxxx:PROCEDURE:[SVC-GSM-WFALSNRSVC-29260-10002 : oracle.apps.fnd.cp.gsc.SvcComponent.performStopError(Connection, Exception)]:BEGIN (oracle.jdbc.driver.T4CConnection@xxx, oracle.apps.fnd.cp.gsc.ProcessorException: 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: 3837: An unhandled error '-1086 - ORA-01086: savepoint 'WF_DISPATCH_SAVEPOINT' never established in this session or is invalid
ORA-06512: at "APPS.WF_EVENT", line 2221
ORA-01086: savepoint 'WF_DISPATCH_SAVEPOINT' never established in this session or is invalid
ORA-06550: line 1, column 14:
PLS-00201: identifier 'HZ_EVENT_ELT.HZ_PARAM_DELETE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored' encountered when dispatching event 'oracle.apps.ar.hz.Location.create' with key 'oracle.apps.ar.hz.Location.create12963'
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1
ORA-06512: at "APPS.WF_EVENT", line 2221
ORA-01086: savepoint 'WF_DISPATCH_SAVEPOINT' never established in this session or is invalid
ORA-06550: line 1, column 14:
PLS-00201: identifier 'HZ_EVENT_ELT.HZ_PARAM_DELETE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored' encountered when dispatching event 'oracle.apps.ar.hz.Location.create' with key 'oracle.apps.ar.hz.Location.create12963'
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1
Changes
Implementing Ebiz Release 12.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |