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 12.2.1.3.0 to 12.2.1.4.200123 [Release 12c]
Oracle Data Integrator on Marketplace - Version 1.0.2 to 12.2.1.4.200123
Information in this document applies to any platform.

Symptoms

After upgrading from ODI 11g to ODI 12.2.1.3 , 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>(FileResultSet.java:156)
  at com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(CommandSelect.java:57)
  at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:34)
  at com.sunopsis.jdbc.driver.file.FilePreparedStatement.executeQuery(FilePreparedStatement.java:134)
  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(AbstractEditFrameGridBorland.java:644)
  at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.<init>(AbstractEditFrameGridBorland.java:925)
  at com.sunopsis.graphical.frame.edit.EditFrameTableData.<init>(EditFrameTableData.java:49)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at oracle.odi.ui.editor.AbstractOdiEditor.open(AbstractOdiEditor.java:115)
  ...
Caused by: java.io.FileNotFoundException: \<HOSTNAME>\<SHARED_FOLDER>\<FILENAME> (The system cannot find the path specified)
  at java.io.FileInputStream.open0(Native Method)
  at java.io.FileInputStream.open(FileInputStream.java:195)
  at java.io.FileInputStream.<init>(FileInputStream.java:138)
  at java.io.FileInputStream.<init>(FileInputStream.java:93)
  at com.sunopsis.jdbc.driver.file.util.SnpsStreamTools.getInputStream(SnpsStreamTools.java:33)
  at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(FileResultSet.java:75)
... 74 more

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!


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