"ODI-14206: Import failed due to unable to delete unneeded objects in target repository." Error when Attempting to Import ODI Object
(Doc ID 2417468.1)
Last updated on AUGUST 29, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.3.181204 [Release 12c]Information in this document applies to any platform.
Symptoms
In ODI 12.2.1.2.6, when attempting to use synonym INSERT_UPDATE to import a specific mapping that already exists, the following error occurs.
ODI-23040: Import file "<DIR>\<MAP_NAME>.xml" error
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-14206: Import failed due to unable to delete unneeded objects in target repository.
at com.sunopsis.dwg.DwgDuplicationTools.deleteUnneededObjectsCurrentlyInRepository(DwgDuplicationTools.java:3592)
at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3963)
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)
at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7500)
at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7483)
at com.sunopsis.graphical.dialog.SnpsDialogImportXml.importFiles(SnpsDialogImportXml.java:890)
at com.sunopsis.graphical.dialog.SnpsDialogImportXml.access$100(SnpsDialogImportXml.java:105)
at com.sunopsis.graphical.dialog.SnpsDialogImportXml$1$2.doAction(SnpsDialogImportXml.java:610)
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.graphical.dialog.SnpsDialogImportXml$1.doLongOperation(SnpsDialogImportXml.java:587)
at oracle.cef.ui.Framework$5.doInBackground(Framework.java:726)
at oracle.cef.ui.Framework$5.doInBackground(Framework.java:718)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
The following error may occur when using "smart import":
ODI-14206: Import failed due to unable to delete unneeded objects in target repository.
at com.sunopsis.dwg.smartie.RunSmartImport.run(RunSmartImport.java:3845)
at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2702)
... 6 more
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-14206: Import failed due to unable to delete unneeded objects in target repository.
at com.sunopsis.dwg.smartie.RunSmartImport.internalRunImportForTempObjList(RunSmartImport.java:1929)
at com.sunopsis.dwg.smartie.RunSmartImport.internalRun(RunSmartImport.java:3495)
at com.sunopsis.dwg.smartie.RunSmartImport.access$400(RunSmartImport.java:124)
at com.sunopsis.dwg.smartie.RunSmartImport$3.doAction(RunSmartImport.java:3656)
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.dwg.smartie.RunSmartImport.internalRunWorkAndMaster(RunSmartImport.java:3629)
at com.sunopsis.dwg.smartie.RunSmartImport.run(RunSmartImport.java:3837)
... 7 more
Caused by: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-14206: Import failed due to unable to delete unneeded objects in target repository.
at com.sunopsis.dwg.DwgDuplicationTools.deleteUnneededObjectsCurrentlyInRepository(DwgDuplicationTools.java:3599)
at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3970)
at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:9966)
at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:8660)
at com.sunopsis.dwg.DwgObject.importObjectList(DwgObject.java:9228)
at com.sunopsis.dwg.smartie.RunSmartImport.internalRunImportForTempObjList(RunSmartImport.java:1913)
... 14 more
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |