My Oracle Support Banner

Using Swift URL for Object Storage on ODI results in 'Object Not Found' Error (Doc ID 2647068.1)

Last updated on AUGUST 09, 2021

Applies to:

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


When executing an Oracle data Integrator job that connects to Swift URL for Object Storage, the following error occurs:

ODI-1217: Session <MAPPING_NAME>_SESS (4) fails with return code ODI-1298.
ODI-1226: Step <MAPPING_NAME>_STEP fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection <EMPTY_VALUE>.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (50)" failed because child task "SERIAL-EU-src_obj_storage_ls_UNIT (60)" is in error.
ODI-1298: Serial task "SERIAL-EU-src_obj_storage_ls_UNIT (60)" failed because child task "Copy data from object store-LKM Object Storage to ADWC Copy-Load DEFAULT_AP (70)" is in error.
ODI-1228: Task Copy data from object store-LKM Object Storage to ADWC Copy-Load DEFAULT_AP fails on the target connection <TARGET_CONNECTION>.
Caused By: java.sql.SQLException: ORA-20404: Object not found - https://<SWIFT_OBJECT_STORAGE_HOSTNAME>/v1/<TARGET_PATH>/<TARGET_FILE>
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 598
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1324
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1347
ORA-06512: at line 3
  at oracle.jdbc.driver.T4CTTIoer11.processError(
  at oracle.jdbc.driver.T4CTTIoer11.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.executeForRows(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OracleStatement.executeInternal(
  at oracle.jdbc.driver.OracleStatement.execute(
  at oracle.jdbc.driver.OracleStatementWrapper.execute(
  at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(



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

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

In this Document
 Apply Patch

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