"ODI-14070 Parent Object Was Not Found" When Importing Work Repository into ODI 12.2.1

Last updated on FEBRUARY 04, 2018

Applies to:

Symptoms

Attempting to import a Work Repository (WR) into Oracle Data Integrator (ODI) 12.2.1 fails with the following error (case 1):

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-14070: Import failed. The parent object was not found in the repository.
 at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3624)
 at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:9074)
 at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:7849)
 at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:8309)
 at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6833)
 at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6795)
 at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6764)
 at com.sunopsis.repository.manager.RepositoryManager.importObjectsUsingImportFromXML(RepositoryManager.java:6929)
 at com.sunopsis.repository.manager.RepositoryManager.treatObjectList(RepositoryManager.java:4555)
 at com.sunopsis.repository.manager.RepositoryManager.treatObjectListGeneral(RepositoryManager.java:4878)
 at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(RepositoryManager.java:5478)
 at com.sunopsis.repository.manager.RepositoryManager.access$400(RepositoryManager.java:199)
 at com.sunopsis.repository.manager.RepositoryManager$2.doAction(RepositoryManager.java:5299)
 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:5286)
 at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImport(RepositoryManager.java:5623)
 at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImportFromZipFile(RepositoryManager.java:5791)
 at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImportFromZipFileWithCommit(RepositoryManager.java:5864)
 at com.sunopsis.repository.manager.RepositoryManager.workRepositoryImportFromZipFileWithCommit(RepositoryManager.java:5919)
 at com.sunopsis.graphical.dialog.SnpsDialogImportWork$1.run(SnpsDialogImportWork.java:207)
 at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)
 at java.lang.Thread.run(Thread.java:745)
Caused by: com.sunopsis.core.SnpsInexistantObjectException: SnpProject.getObjectByIdent : SnpProject does not exist
 at com.sunopsis.dwg.dbobj.generated.GeneratedSnpProject.getObjectByIdent(GeneratedSnpProject.java:462)
 at com.sunopsis.dwg.dbobj.SnpTrt.checkParentExists(SnpTrt.java:2340)
 at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3620)
 ... 22 more

Similar errors have been observed (case 2):

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-14070: Import failed. The parent object was not found in the repository.
 at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3907)
 at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:9960)
 at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:8654)
 at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:9134)
 at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7569)
 ...
Caused by: com.sunopsis.core.SnpsInexistantObjectException: SnpFolder.getObjectByIdent : SnpFolder does not exist
 at com.sunopsis.dwg.dbobj.generated.GeneratedSnpProject.getObjectByIdent(GeneratedSnpFolder.java:508)
 at com.sunopsis.dwg.dbobj.SnpMapping.checkParentExists(SnpMapping.java:845)
 at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3903)
 ... 20 more

Changes

The Work Repository was created with ODI 12.1.3 and upgraded to ODI 12.2.1.1.0.

Cause