"ORA-00955: name is already used by an existing object" Error Received when Attempting to Upgrade ODI 12c Environment

(Doc ID 2415851.1)

Last updated on JULY 06, 2018

Applies to:

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

Symptoms

When attempting to upgrade from Oracle Data Integrator (ODI) 12.2.1.0.0 to 12.2.1.2.6 using the Upgrade Assistant (UA), the following error was observed:

[2018-05-25T11:43:39.758-04:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1] Unknown error happened.
[2018-05-25T11:43:39.758-04:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1] Cause: Unknown error happened.
[2018-05-25T11:43:39.758-04:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1] Action: Restore Master Repository from Backup and try to upgrade again.
[2018-05-25T11:43:39.758-04:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]
oracle.odi.setup.RepositorySetupException: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch M_05.02.02.01_05.02.02.02.xml
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:753)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:643)
  ...
Caused by: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch M_05.02.02.01_05.02.02.02.xml
  at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.executeUpgradeDDL(AbstractRepositoryUpgrade.java:157)
  at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.upgradeMasterRepository(AbstractRepositoryUpgrade.java:280)
  at com.sunopsis.repository.manager.upgrade.RepositoryUpgradeRunner.upgradeMasterRepository(RepositoryUpgradeRunner.java:457)
  at com.sunopsis.repository.manager.RepositoryManager.masterRepositoryPatch(RepositoryManager.java:4740)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:738)
  ... 12 more
Caused by: java.lang.RuntimeException: Error while executing create table SNP_REST_OPERATION
(
I_REST_OPERATION NUMBER(19) NOT NULL ,

NAME VARCHAR2(200 CHAR) NOT NULL ,

RESOURCE_URI CLOB NULL ,

METHOD VARCHAR2(200 CHAR) NULL ,

GLOBAL_ID VARCHAR2(36 CHAR) NOT NULL ,

I_OWNER_PSCHEMA NUMBER(19) NOT NULL
)
  at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:101)
  at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:124)
  at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.executeUpgradeDDL(AbstractRepositoryUpgrade.java:155)
  ... 16 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  ...

Changes

Upgrade from ODI 12.2.1.0.0 to 12.2.1.2.6.

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