My Oracle Support Banner

Loading from Oracle Object Storage to Oracle Database Fails with "ODI-40438: File not found" (Doc ID 2624462.1)

Last updated on AUGUST 18, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

An Oracle Object Storage data server was configured successfully in Oracle Data Integrator (ODI) following the documentation and a blog entry from Product Management. The file datastore was added to the Oracle Object Storage Model and reverse engineering was successful.

When trying to execute a mapping that loads directly from Oracle Object Storage datastore to an Oracle database table using knowledge module 'LKM SQL to Oracle,' the following error occurs:

ODI-1227: Task Load data-LKM SQL to Oracle- fails on the source connection <Oracle Object Storage Data Server>.
Caused By: java.sql.SQLException: ODI-40438: File not found: <BUCKET_NAME>\<FILE_NAME>
  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.FileStatement.executeQuery(FileStatement.java:63)
  at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:196)
  at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:204)
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:100)
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:309)
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:216)
  ...
Caused by: java.io.FileNotFoundException: <BUCKET_NAME>\<FILE_NAME> (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)
  ... 23 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.