'[UPGCMP-00334] ... Internal limit on object ids reached' Signalled During Upgrade Of ODI 10g To 11g (Doc ID 1923740.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When attempting to upgrade ODI version 10g to 11g using Oracle Upgrade Assistant (UA), the following message is displayed:

[2014-06-23T16:12:23.819+02:00] [odi] [NOTIFICATION:16] [ODI-14053] [oracle.odi.setup] [tid: 13] [ecid: 0000KR93xBRDsX_5HRWByf1Je3JI000004,0] ODI Work Repository Upgrade: Upgrading Repository Data...

[2014-06-23T16:15:25.294+02:00] [ODI] [ERROR] [UPGCMP-00334] [upgrade.ODI] [tid: 13] [ecid: 0000KR93xBRDsX_5HRWByf1Je3JI000004,0] Unknown error happened.

[2014-06-23T16:15:25.294+02:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: 13] [ecid: 0000KR93xBRDsX_5HRWByf1Je3JI000004,0] Cause: Unknown error happened. Action: Restore Work Repository from Backup and try to upgrade again.

[2014-06-23T16:15:25.294+02:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: 13] [ecid: 0000KUeSYDhEsHwb0DR_6F1JsUUP000004,0] [[
oracle.odi.setup.RepositorySetupException: java.lang.Exception: Internal limit on object ids reached
    at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:542)
    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:443)
    at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:154)
    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)
...
]]

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