Error ORA-00001 Unique Constraint When Re-applying Service Packs (Doc ID 1562709.1)

Last updated on JUNE 21, 2013

Applies to:

Oracle Utilities Framework - Version 2.2.0 and later
Information in this document applies to any platform.

Goal

When we run CDXPatch.exe with the '-k' parameter, we are seeing several unique constraint errors.


e.g.

--ERROR: ORA-00001: unique constraint (CISADM.SYS_C008392) violated (DBD ERROR: OCIStmtExecute)occured while executing INSERT INTO CI_MD_PRG_COM(PROG_COM_ID,LOC_ID,TBL_NAME,PROG_COM_NAME,TMPL_CD,DEV_STATUS_FLG,COMMENT_LONG,COMMENT_SHORT,PROG_COM_TYPE_FLG,OWNER_FLG) VALUES ('CI2       ','utilcode  ','CI_MD_PRG_COM                 ','metaDataProgComSearchPage','UIXSP   ','  ',' ',' ','    ','F1  ')
 

Solution

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