"ODI-14206: Import failed due to unable to delete unneeded objects in target repository." Error Received when Attempting to Import ODI Object (Doc ID 2446080.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When attempting to import an Oracle Data Integrator (ODI) object through smart import or normal import, the following errors occur:

Smart Import Error

oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: 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.SmartImportManager.runSmartImport(SmartImportManager.java:2715)
at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.runSmartImport(ISmartImportInstanceImpl.java:366)
at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:348)
at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:272)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: 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.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

Normal Import 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: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.doImport(DwgObject.java:9140)
at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7575)
at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7506)
at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7489)
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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Changes

Cause

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