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 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


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>(
  at com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(
  at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(
  at com.sunopsis.jdbc.driver.file.FileStatement.executeQuery(
  at oracle.odi.query.JDBCTemplate.executeQuery(
  at oracle.odi.query.JDBCTemplate.executeQuery(
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(
Caused by: <BUCKET_NAME>\<FILE_NAME> (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>(
  ... 23 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.