CCB 2.8 DB Schema Upgrade Error (Doc ID 2824268.1)

Last updated on OCTOBER 04, 2023

Applies to:

Symptoms

On : CCB 2.8.0.0.0 version, ENV - Environment

Error during CCB 2.8 DB Schema upgrade from CCB 2.7.0.3.0.

ERROR:
-----------
ERROR (oem.install.OraDBI) Error while executing SQL: StmtType-U, Stmt-INSERT INTO SC_USR_GRP_PROF (USR_GRP_ID,APP_SVC_ID,EXPIRATION_DT,VERSION,OWNER_FLG)
(SELECT USR_GRP_ID, 'C1CCSRCH', EXPIRATION_DT, 1, OWNER_FLG FROM SC_USR_GRP_PROF WHERE APP_SVC_ID = 'CILCCCIP' AND OWNER_FLG = 'CM' AND EXPIRATION_DT >= CURRENT_DATE)

 - 2021-05-25 08:59:05,755 [main] ERROR (oem.install.OraDBI) ORA-00001: unique constraint (CISADM.SYS_C00124369) violated

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CISADM.SYS_C00124369) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1747) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:1712) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1699) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:285) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
at com.oracle.ouaf.oem.install.OraDBI.ExecuteSql(OraDBI.java:1971) [spl-oradbi-4.4.0.3.0.jar:?]
at com.oracle.ouaf.oem.install.OraDBI.ProcessDRVFile(OraDBI.java:1398) [spl-oradbi-4.4.0.3.0.jar:?]
at com.oracle.ouaf.oem.install.OraDBI.ExecUpgScripts(OraDBI.java:1119) [spl-oradbi-4.4.0.3.0.jar:?]
at com.oracle.ouaf.oem.install.OraDBI.mymain(OraDBI.java:461) [spl-oradbi-4.4.0.3.0.jar:?]
at com.oracle.ouaf.oem.install.OraDBI.(OraDBI.java:221) [spl-oradbi-4.4.0.3.0.jar:?]
at com.oracle.ouaf.oem.install.OraDBI.main(OraDBI.java:136) [spl-oradbi-4.4.0.3.0.jar:?]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00001: unique constraint (CISADM.SYS_C00124369) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0]
... 19 more
 - 2021-05-25 08:59:05,762 [main] DEBUG (oem.install.OraDBI) NO RECORDS SELECTED
 - 2021-05-25 08:59:05,762 [main] INFO (oem.install.OraDBI) Error Occured!
 - 2021-05-25 08:59:05,762 [main] INFO (oem.install.OraDBI) Do you want to continue from the current step again (Y/N)?
 - 2021-05-25 09:07:30,024 [main] INFO (oem.install.OraDBI) Executing Finalization Scripts ...
 - 2021-05-25 09:07:30,024 [main] INFO (oem.install.OraDBI) -----------------------------------------------------------
 - 2021-05-25 09:07:30,024 [main] INFO (oem.install.OraDBI) --Applying patch CDIPost.DRV at 05-25-2021 09:07:30
 - 2021-05-25 09:07:30,024 [main] INFO (oem.install.OraDBI) ---------------------------------------------------------------

STEPS:
------------

1. CCB_2.8/DB/CCB/Upgrade/Install-Upgrade 2. Execute command --> java -Xmx1500M com.oracle.ouaf.oem.install.OraDBI -p <RW_USERPASS>,<R_USERPASS>

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.