Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Smart Import fails: Closed connection

russos51Nov 13 2017 — edited Nov 16 2017

Hi all,

i am trying to import a large project in ODI with Smart Import but during the process it fails with this exception:

oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: java.sql.SQLException: Closed connection

at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2635)

at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.runSmartImport(ISmartImportInstanceImpl.java:366)

at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:350)

at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:274)

at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)

at java.lang.Thread.run(Thread.java:745)

Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: java.sql.SQLException: Closed connection

at com.sunopsis.dwg.smartie.RunSmartImport.run(RunSmartImport.java:3272)

at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2622)

... 6 more

Caused by: java.sql.SQLException: Connessione chiusa: Closed connection

How can i avoid it?

Thanks a lot

The database is Oracle 12c

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2017

Added on Nov 13 2017

#business-intelligence-applications, #data-integrator, #system-management-and-integration

16 comments

1,459 views