ODI-10018, ODI-26005 Or ODI-10093 Message Received During ODI 11g Import In Synonym INSERT_UPDATE Mode (Doc ID 1456584.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

While attempting to import objects with ODI 11g in Synonym INSERT or Synonym INSERT_UPDATE mode to a new Work Repository, the following message is observed:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10018: The repository {0} is not coherent between the current repository and the import file.
    at com.sunopsis.dwg.DwgDuplicationTools.checkTheImportRepCoherence(DwgDuplicationTools.java:2376)
    at com.sunopsis.dwg.DwgDuplicationTools.checkTheImportRepCoherence(DwgDuplicationTools.java:2252)
    at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:2030)
    at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:6509)
    at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:6011)
    ...

In certain versions of ODI 11g, the Repository ID is indicated in the error message:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10018: The repository 002 is not coherent between the current repository and the import file.
    at com.sunopsis.dwg.DwgDuplicationTools.checkTheImportRepCoherence(DwgDuplicationTools.java:2882)
    at com.sunopsis.dwg.DwgObject.checkImportRepCoherence(DwgObject.java:7087)
    at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:6363)
    at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:6802)
    at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6021)
    ...

When importing into the Master Repository, in Synonym INSERT or Synonym INSERT_UPDATE mode, ODI signals:

ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.
    at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2078)
    at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.runSmartImport(ISmartImportInstanceImpl.java:342)
    at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:237)
    at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:1)
    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:656)
    at java.lang.Thread.run(Thread.java:662)

When importing into the Work Repository, in Synonym INSERT or Synonym INSERT_UPDATE mode, ODI signals:

ODI-26005: You are importing an object from another repository with the same identifier. It is forbidden.
    at ...

Changes

The environment may have multiple repositories where two remote repositories have the same repository ids but have differnt creation time-stamps with the repository being imported into.

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