My Oracle Support Banner

"ODI-40438: File not found" During View Data of File Datastore on Mounted Folder After Upgrading ODI 11g to 12c (Doc ID 2619535.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator on Marketplace - Version 1.0.2 to
Information in this document applies to any platform.


After upgrading from ODI 11g to ODI , following error occurs when trying to View Data from a file datastore located on a mounted shared folder:

java.sql.SQLException: ODI-40438: File not found: /<HOSTNAME>/<SHARED_FOLDER>/<FILENAME>
  at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(
  at com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(
  at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(
  at com.sunopsis.jdbc.driver.file.FilePreparedStatement.executeQuery(
  at com.borland.dx.sql.dataset.o.f(Unknown Source)
  at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
  at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
  at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
  at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
  at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.initialize(
  at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.<init>(
  at com.sunopsis.graphical.frame.edit.EditFrameTableData.<init>(
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
  at java.lang.reflect.Constructor.newInstance(
Caused by: \<HOSTNAME>\<SHARED_FOLDER>\<FILENAME> (The system cannot find the path specified)
  at Method)
  at com.sunopsis.jdbc.driver.file.util.SnpsStreamTools.getInputStream(
  at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(
... 74 more


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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