Hi all,
we are upgrading the ODI from version 10g to ODI 11g.
Master Repository upgraded successfully while its failed in work repositories.
ODI_Upgrade_Error_round1.txt (75 KB)
[2021-02-26T14:35:00.410+01:00] [eclipse] [NOTIFICATION] [org.eclipse.persistence.default] login successful
[2021-02-26T14:35:00.535+01:00] [ODI] [NOTIFICATION] [upgrade.ODI] Work Repositories:
[2021-02-26T14:35:00.535+01:00] [ODI] [NOTIFICATION] [upgrade.ODI] WORK_DEV_2
[2021-02-26T14:35:00.535+01:00] [ODI] [NOTIFICATION] [UPGCMP-00316] [upgrade.ODI] Target Work Repository WORK_DEV_2 upgrade is started.
[2021-02-26T14:35:00.675+01:00] [odi] [NOTIFICATION] [ODI-14052] [oracle.odi.setup] ODI Work Repository Upgrade: Upgrading Repository Structure...
[2021-02-26T14:35:00.675+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.02.02.01_04.02.03.01.xml
[2021-02-26T14:41:11.638+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.02.03.01_04.03.01.01.xml
[2021-02-26T14:41:11.794+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.01.01_04.03.02.01.xml
[2021-02-26T14:41:12.793+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.02.01_04.03.02.02.xml
[2021-02-26T14:41:12.886+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.02.02_04.03.02.03.xml
[2021-02-26T14:41:13.042+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.02.03_04.03.02.04.xml
[2021-02-26T14:41:13.058+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.02.04_04.03.03.01.xml
[2021-02-26T14:41:13.120+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\E_04.03.03.01_04.03.03.02.xml
[2021-02-26T14:41:13.588+01:00] [odi] [NOTIFICATION] [ODI-14063] [oracle.odi.setup] Applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\W_04.02.02.01_04.02.03.01.xml
[2021-02-26T14:41:17.675+01:00] [odi] [ERROR] [ODI-14064] [oracle.odi.setup] Error while applying DDL from file C:\oracle\product\11.1.1\Oracle_ODI_Win32\oracledi.sdk\lib\scripts\ORACLE\patches\W_04.02.02.01_04.02.03.01.xml
[2021-02-26T14:41:17.691+01:00] [ODI] [ERROR] [UPGCMP-00334] [upgrade.ODI] Unknown error happened.
[2021-02-26T14:41:17.691+01:00] [ODI] [ERROR] [upgrade.ODI] Cause: Unknown error happened. Action: Restore Work Repository from Backup and try to upgrade again.
[2021-02-26T14:41:17.691+01:00] [ODI] [ERROR] [upgrade.ODI]
oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: Error while executing drop table SNP_KEY
at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:552)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:186)
at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:41)
at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:453)
at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:153)
at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeWork(RepositoryUpgradeServiceImpl.java:57)
at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:136)
at oracle.ias.mrua.plugin.odi.ODIPlugin.doUpgrade(ODIPlugin.java:466)
at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:3576)
at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:2357)
at oracle.ias.mrua.MRUA.driver(MRUA.java:1621)
at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:390)
Caused by: java.lang.RuntimeException: Error while executing drop table SNP_KEY
at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:92)
at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:97)
at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.executeXmlAbsoluteFile(Pre04_03_03_02Upgrader.java:232)
at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.workUpgradePre04_03_03_02(Pre04_03_03_02Upgrader.java:333)
at com.sunopsis.repository.manager.RepositoryManager.workRepositoryPatch(RepositoryManager.java:5090)
at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:537)
... 11 more
Caused by: java.sql.SQLException: ORA-02449: unique/primary keys in table referenced by foreign keys
Please find the attached error and help me on this