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 JULY 18, 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

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(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
  at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
  ...

 

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!


In this Document
Symptoms
Cause
Solution
 Workaround
 Apply Patch
References


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