My Oracle Support Banner

"ODI-40438: File Not Found" Error Received when Attempting to View File Data from a Remote Server (Doc ID 2415153.1)

Last updated on JULY 09, 2018

Applies to:

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

Symptoms

After Reverse Engineering a file from a remote server in Oracle Data Integrator (ODI), when attempting to "View Data" of the data source based on the remote file, the following error occurs:

java.sql.SQLException: ODI-40438: File not found: /directory_path/filename.txt
at com.sunopsis.jdbc.driver.file.FileResultSet.(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.(AbstractEditFrameGridBorland.java:925)
at com.sunopsis.graphical.frame.edit.EditFrameTableData.(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)
at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.openEditor(EditorState.java:318)
at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.doLayout(SplitPane.java:579)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.whenCurrentEditorChanges(NbEditorManager.java:1637)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.whenCurrentEditorChanges(TabGroup.java:1026)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.setCurrentTabGroupState(TabGroup.java:847)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.addTabGroupState(TabGroup.java:129)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:556)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:533)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:401)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditorInFrame(NbEditorManager.java:321)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openDefaultEditorInFrame(NbEditorManager.java:308)
at oracle.odi.window.node.OdiEditorFactory.openEditorLegacy(OdiEditorFactory.java:1031)
at oracle.odi.ui.action.SnpsPopupActionDataConsultHandler.actionPerformed(SnpsPopupActionDataConsultHandler.java:82)
at oracle.odi.ui.SnpsActionControler.handleEvent(SnpsActionControler.java:94)
at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1488)

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!


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