After Upgrading , Getting Errors in The "HDOWNER.E_LOAD_LOG" Table Running The ETL Process
(Doc ID 2014176.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Fusion Transportation Intelligence - Version 6.3.6 to 6.3.8 [Release 6.3]Information in this document applies to any platform.
Symptoms
Upgrading OTM, getting errors in the HDOWNER.E_LOAD_LOG table Running the ETL process
The errors are generated while completing the following:
A) Select Transportation Intelligence
B) Select Process Management
C) Run ETL
----Then to display the errors ,
D) Select Transportation Intelligence
E) Select Data Management
F) Select View FTI Data Load Log
"ODI-1226: Step INCR LOAD_PATH_AND_PATHEDGE fails after 1 attempt(s).
ODI-1232: Procedure INCR_LOAD_PATH_AND_PATHEDGE execution fails.
ODI-1228: Task INCR_LOAD_PATH_AND_PATHEDGE (Procedure) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLException: ORA-06550: line 30 column 30:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 28 column 1:
PL/SQL: SQL Statement ignored
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.pro"
"ODI-1226: Step INCR_W_LEG_D fails after 1 attempt(s).
ODI-1240: Flow INCR_W_LEG_D fails while performing a Integration operation. This flow loads target table W_LEG_D.
ODI-1228: Task INCR_W_LEG_D (Integration) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.proce"
"ODI-1226: Step INCR_W_NETWORK_D fails after 1 attempt(s).
ODI-1240: Flow INCR_W_NETWORK_D fails while performing a Integration operation. This flow loads target table W_NETWORK_D.
ODI-1228: Task INCR_W_NETWORK_D (Integration) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.drive"
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |