My Oracle Support Banner

"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 to [Release 12c]
Information in this document applies to any platform.


The import of Work Repository into an environment created with Oracle Data Integrator (ODI), 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(
    at com.sunopsis.dwg.DwgDuplicationTools.setFkRefsUsingFkXRefs(
    at com.sunopsis.dwg.DwgDuplicationTools.setFkRefsUsingFkXRefs(
    at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(
    at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(
    at com.sunopsis.dwg.DwgObject.importFromObjectLst(
    at com.sunopsis.dwg.DwgObject.internalImportObjectList(
    at com.sunopsis.dwg.DwgObject.doImport(
    at com.sunopsis.dwg.DwgObject.doImport(
    at com.sunopsis.dwg.DwgObject.doImport(
    at com.sunopsis.repository.manager.RepositoryManager.importObjectsUsingDoImport(
    at com.sunopsis.repository.manager.RepositoryManager.treatObjectListGeneral(
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(
    at com.sunopsis.repository.manager.RepositoryManager.access$400(
    at com.sunopsis.repository.manager.RepositoryManager$2.doAction(
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
    at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(
    at com.sunopsis.repository.manager.RepositoryManager.internalWorkRepositoryImportWithCommit(
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(
    at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImportWithCommit(
    at com.sunopsis.graphical.dialog.SnpsDialogImportWork$

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

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

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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.