"SnpsForeignKeyReferencedObjectMissingException: ODI-10244" Message Is Signaled When Importing a Work Repository In ODI 12c (Doc ID 1662734.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.1.2.0.1 [Release 12c]
Information in this document applies to any platform.

Symptoms

The import of Work Repository into an environment created with Oracle Data Integrator (ODI) 12.1.2.0.0, using synonym INSERT_UPDATE mode fails, and signals:

com.sunopsis.core.SnpsForeignKeyReferencedObjectMissingException: ODI-10244: Cannot import Mapping Expression Reference : null (with global id: 63f5ed64-2c46-4e7f-bc81-e31570777bfa and internal id: 1298) because referenced Map Reference Pivot Point with global id 12733fd0-4de5-4e76-8a02-8cc17691d41c does not exist.
    at com.sunopsis.dwg.DwgDuplicationTools.processFkRefThatCannotBeSet(DwgDuplicationTools.java:6080)
    at com.sunopsis.dwg.DwgDuplicationTools.setFkRefsUsingFkXRefs(DwgDuplicationTools.java:6412)
    at com.sunopsis.dwg.DwgDuplicationTools.setFkRefsUsingFkXRefs(DwgDuplicationTools.java:6112)
    at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(DwgDuplicationTools.java:4284)
    at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3667)
    at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:8823)
    at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:7577)
    at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:8036)
    at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:7734)
    at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:7692)
    at com.sunopsis.repository.manager.RepositoryManager.importObjectsUsingDoImport(RepositoryManager.java:6488)
    at com.sunopsis.repository.manager.RepositoryManager.treatObjectListGeneral(RepositoryManager.java:4423)
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(RepositoryManager.java:4975)
    at com.sunopsis.repository.manager.RepositoryManager.access$400(RepositoryManager.java:189)
    at com.sunopsis.repository.manager.RepositoryManager$2.doAction(RepositoryManager.java:4825)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
    at com.sunopsis.repository.manager.RepositoryManager.internalWorkRepositoryImportWithCommit(RepositoryManager.java:4812)
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(RepositoryManager.java:5132)
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImportWithCommit(RepositoryManager.java:5180)
    at com.sunopsis.graphical.dialog.SnpsDialogImportWork$1.run(SnpsDialogImportWork.java:181)
    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:920)
    at java.lang.Thread.run(Thread.java:724)

Click "OK", and observe that no  objects have been imported.

Note that the import operation succeeds if the environment has been created with ODI 12.1.2.0.1 bundle patch instead of ODI 12.1.2.0.0:

Version of ODI StudioVersion of the ODI RepositoriesOutcome
12.1.2.0.0 12.1.2.0.0 Import fails with ODI-10244 message
12.1.2.0.0 12.1.2.0.1 Import fails with ODI-10244 message
12.1.2.0.1 (*) 12.1.2.0.0 Import fails with ODI-10244 message
12.1.2.0.1 (*) 12.1.2.0.1 Import succeeds

 






(*) The "About" menu in ODI Studio shwows 12.1.2.0.0 even if ODI 12.1.2.0.1 bundle patch has been applied.
For getting the precise version of ODI Studio, "opatch lsinventory" must be used. Note ODI 12.1.2.0.1 is patch 17836908 (refer to <Note 456313.1>)

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