Using Swift URL for Object Storage on ODI Results in 'Object Not Found' Error
(Doc ID 2647068.1)
Last updated on AUGUST 09, 2024
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 (ODI) 12c 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)
...
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! |