My Oracle Support Banner

"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 APRIL 03, 2019

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

 

NOTE: In versions prior to ODI 12.2.1.3.0 (ie. ODI 12.2.1.2.6), the issue only occurs after the patch for <Bug 25491619> is applied.

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.