EM13c: Saving A Configured Deployment Procedure in Enterprise Manager 13c loud Control Fails with ORA-00001 Error and Message: Procedure Configuration with the same name already exists (Doc ID 2299188.1)

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

On Enterprise Manager Cloud Control 13.2.0.0.0 version, Provisioning Framework

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

 [2017-02-23T02:56:49.266-05:00] [EMGC_OMS2] [ERROR] [] [oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter] [tid:]] [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'userId: GZT98S_SA] [ecid:]] 005IIroWQf53f5tLkeP5iZ0001G40000ri,0:1] [APP: emgc] [DSID:]] 0000LddppHu3f5tLkeP5iZ1Ofa55000002] ADF_FACES-60096:Server Exception during PPR, #1

javax.el.ELException: oracle.sysman.emSDK.app.exception.EMSystemException
 Caused by: oracle.sysman.emSDK.app.exception.EMSystemException
 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.

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms