My Oracle Support Banner

"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:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

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

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


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