EM12c, EM13c : Edit & Save customized Deployment Procedure in Enterprise Manager 12c Cloud Control Fails With : PROCEDURE_NAME_NOT_UNIQUE_ERROR
Last updated on MARCH 07, 2017
Applies to:Enterprise Manager Base Platform - Version 22.214.171.124.0 to 126.96.36.199.0 [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:
while saving the procedure oracle.sysman.emdrep.jobs.framework.validation.ValidationException: 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:
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