Starting Workflow Generates ORA-04068 Error with Debug Service Manager Stuck Activating
Last updated on JUNE 22, 2017
Applies to:Oracle Concurrent Processing - Version 11.5.9 to 188.8.131.52 [Release 11.5]
Oracle Workflow Cartridge - Version 11.5.9 to 184.108.40.206 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 25-Mar-2013***
When attempting to start the Workflow Mailer, an error is generated:
java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "APPS.FND_SVC_COMPONENT" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
After checking the services, discover the Debug Service Manager is stuck in Activating.
Review the FNDSMxx.mgr log file and there is an error:
The SQL statement being executed at the time of the error was: begin
FND_CP_GSM_IPC.Cartridge_Init_Service(:h, :p, :d); end; and was executed from the file &ERRFILE.
The call to function StartProcess in cartridge AQCART has failed.
03-AUG-2006 15:19:09 - ORACLE error 25207 in init_service
Cause: init_service failed due to ORA-25207: enqueue failed, queue APPLSYS.FND_CP_GSM_IPC_AQ is
disabled from enqueueing
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 178
ORA-06512: at line 1.
Bounced the database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms