My Oracle Support Banner

Upgrade from ODI 11g to ODI 12c is failing with "ORA-00001: unique constraint (<MASTER_SCHEMA>.AK_PROFILE_NAME) violated" (Doc ID 2575458.1)

Last updated on MAY 27, 2021

Applies to:

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

Symptoms

When upgrading from Oracle Data Integrator (ODI) 11.1.1.9 to 12.2.1.3, below error occurs in the upgrade log:

[2019-07-01T10:27:35.226+03:00] [odi] [NOTIFICATION:16] [ODI-14086] [oracle.odi.setup] Begin importing: for <Oracle_Home>\odi\sdk\lib\scripts\xml\PROF_OPERATOR.xml
[2019-07-01T10:27:35.491+03:00] [odi] [ERROR] [ODI-14096] [oracle.odi.setup] Error While Upgrading Master Repository ORA-00001: unique constraint (<MASTER_SCHEMA>.AK_PROFILE_NAME) violated[[
]]
[2019-07-01T10:27:35.491+03:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1] Unknown error happened.
[2019-07-01T10:27:35.491+03:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] Cause: Unknown error happened.
[2019-07-01T10:27:35.491+03:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] Action: Restore Master Repository from Backup and try to upgrade again.
[2019-07-01T10:27:35.491+03:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [[
oracle.odi.setup.RepositorySetupException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<MASTER_SCHEMA>.AK_PROFILE_NAME) violated
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:797)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:687)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:868)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:421)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:432)
  at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
  at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
  at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:726)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:369)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1058)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<MASTER_SCHEMA>.AK_PROFILE_NAME) violated
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
  at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
  at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3898)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
  at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:367)
  at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:194)
  at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)
  ...
Caused by: Error : 1, Position : 0, Sql = update SNP_PROFILE set EXT_VERSION=:1 ,GLOBAL_ID=:2 ,IND_CHANGE=:3 ,LAST_DATE=sysdate ,LAST_USER=:4 ,PROF_NAME=:5 where I_PROF=:6 , OriginalSql = update SNP_PROFILE set EXT_VERSION=? ,GLOBAL_ID=? ,IND_CHANGE=? ,LAST_DATE=sysdate ,LAST_USER=? ,PROF_NAME=? where I_PROF=?, Error Msg = ORA-00001: unique constraint (<MASTER_SCHEMA>.AK_PROFILE_NAME) violated at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 52 more

Cause

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
Symptoms
Cause
Solution


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