EM12c, EM13c : Edit & Save customized Deployment Procedure in Enterprise Manager 12c Cloud Control Fails With : PROCEDURE_NAME_NOT_UNIQUE_ERROR

(Doc ID 2159275.1)

Last updated on MARCH 07, 2017

Applies to:

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


Editing a User defined Deployment Procedure (DP) from Enterprise Manager (EM) 12c Cloud Control fails with error:

"An error occurred while saving the procedure: Deployment procedures with same name are not allowed."

From the .../gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc file:

2016-03-22 11:07:13,432 [EMUI_11_07_12_/console/paf/procedureSteps] DEBUG controller.AbstractProcedureEditorController logp.251 - An error occurred
while saving the procedure oracle.sysman.emdrep.jobs.framework.validation.ValidationException: PROCEDURE_NAME_NOT_UNIQUE_ERROR
at oracle.sysman.emdrep.jobs.procedure.dal.PAFDataSource.saveProcedure(PAFDataSource.java:737)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SYSMAN"."EM_PAF_USER_PROCEDURES"."CREATED_FROM_PROC_ID")
ORA-06512: at "SYSMAN.EM_PAF_PROC", line 827
ORA-06512: at line 1

"emcli get_procedures" had this procedure information:

292B22A757BC4940E0533A5F1AACF7E8 PatchOracleSoftware DP_292B22A757574940E0533A5F1AACF7E8 CSAA Patch Oracle Restart 2016 1.3 SYSMAN




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