My Oracle Support Banner

EM13c: Saving A Configured Deployment Procedure Fails with: Procedure Configuration with the same name already exists ORA-00001 Error (Doc ID 2299188.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Enterprise Manager Base Platform - Version to [Release 13c]
Information in this document applies to any platform.


Using a custom deployment procedure based on the standard Oracle RAC Database Provisioning procedure; the Operators access a configured version of the procedure where some values are pre-populated and locked.
After upgrade to EM 13c, saving the configured procedure with the same name as before the migration results in an error:

 [2017-02-23T02:56:49.266-05:00] [<OMS Instance Home>] [ERROR] [] [] [tid:]] [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'userId: GZT98S_SA] [ecid:]] <ECID>] [APP: emgc] [DSID:]] <DSID>] ADF_FACES-60096:Server Exception during PPR, #1

 Caused by:
 Caused by: oracle.sysman.emSDK.core.job.procedure.exception.PAFException:
 Procedure Configuration with the same name already exists.

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
 unique constraint (SYSMAN.MGMT_JOB_UK) violated
 ORA-06512: at "SYSMAN.EM_PAF_CONFIG", line 39
 ORA-06512: at line 1


Saving the procedure with a different name seems to work at first attempt, however, changing and saving any value shows the same error again.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.