My Oracle Support Banner

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 FEBRUARY 03, 2019

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 PROCEDURE_NAME_NOT_UNIQUE_ERROR
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




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.