Violations Of AK Unique Constraints Abort Encountered When Attempting To Upgrade To ODI 11.1.1.5.0 With UA

(Doc ID 1405207.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

The Oracle Upgrade Assistant (UA) fails when upgrading:

More precisely, the upgrade of the Work Repository fails due to violations of AK_ORIG_TXT unique constraint, and the following is shown in the UA log file:

oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: Error while executing alter table SNP_COND add constraint AK_ORIG_TXT unique ( SNPS_TABLE , SNPS_COL )
at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:470)

[...]

Caused by: java.lang.RuntimeException: Error while executing alter table SNP_COND add constraint AK_ORIG_TXT unique ( SNPS_TABLE , SNPS_COL )
at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:92)
at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:74)
at

[...] 8 more

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02299: cannot validate (MYWORK.AK_ORIG_TXT) - duplicate keys found

[...] 13 more

Cause

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