All ETL Load Plans and StarETL Process Have Failed (Doc ID 2629685.1)

Last updated on MAY 12, 2022

Applies to:

Symptoms

Two issues presented:

• The Load Plans and ETLs failed.
• Missing grants to the PXRPTUSER account.

Initial Errors
Load plan name: LOAD_PLAN_REALTIME_PROJECT
Datasource: staretl1
Instance id: 641
Run start time: Tue Jan 14 20:07:53 UTC 2020
Run end time: Tue Jan 14 23:58:41 UTC 2020
Status: ERROR
[ERROR] 4 \-\ ODIWAITFORLOGDATA
  [ERROR] 5 /-/ Oracle Data Integrator Command - Oracle Data Integrator Command - null
oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  [ERROR] 10) LOOP_REALTIME_P6_PROJECT, duration = 13820 seconds

ETL Log
Load plan name: LOAD_PLAN_REALTIME_GLOBAL
Datasource: staretl1
Instance id: 642
Run start time: Tue Jan 14 20:07:53 UTC 2020
Run end time: Tue Jan 14 20:09:40 UTC 2020
Status: ERROR
Error message: ODI-1519: Serial step "Real time loop for global tables (InternalID:1919)" failed because child step "Case Data Source Type (InternalID:1920)" is in error.
[ERROR] 9 \-\ Extend Window
  [ERROR] 10 /-/ Journalizing - PRIMAVERA_ANALYTICS_P6_GLOBAL - Validate KM options
ODI-1228: Task Journalizing-PRIMAVERA_ANALYTICS_P6_GLOBAL-Validate KM options fails on the target connection PRIMAVERA_ANALYTICS_SRC_DS1.
  [ERROR] 10) LOOP_REALTIME_P6_GLOBAL, duration = 100 seconds

ETL Log
Load plan name: LOAD_PLAN_ON_DEMAND
Datasource: staretl1
Instance id: 640
Run start time: Tue Jan 14 20:07:52 UTC 2020
Run end time: Tue Jan 14 20:08:04 UTC 2020
Status: ERROR
Error message: ODI-1519: Serial step "Loop publish projects (InternalID:1868)" failed because child step "Case Data Source Type (InternalID:1869)" is in error.
[ERROR] 7 \-\ Extend Window
  [ERROR] 8 /-/ Journalizing - PRIMAVERA_ANALYTICS_P6_OD - Validate KM options
ODI-1228: Task Journalizing-PRIMAVERA_ANALYTICS_P6_OD-Validate KM options fails on the target connection PRIMAVERA_ANALYTICS_SRC_DS1.
  [ERROR] 10) LOOP_ON_DEMAND_P6, duration = 4 seconds

Secondary Error

Real Time Global fails with the below error.

ODI-1521: Case step "Case Data Source Type (InternalID:1920)" failed; the selected child "When P6 (InternalID:1921)" is in error.
ODI-1520: Case-When/Else step "When P6 (InternalID:1921)" failed because child step "rootStep_caseWhen (InternalID:1922)" is in error.
ODI-1519: Serial step "rootStep_caseWhen (InternalID:1922)" failed because child step "10) LOOP_REALTIME_P6_GLOBAL (InternalID:1923)" is in error.
ODI-1217: Session LOOP_REALTIME_P6_GLOBAL (10586) fails with return code 6550.
ODI-1226: Step Extend Window fails after 1 attempt(s).
ODI-1229: An error occurred while performing a Journal operation on model code PRIMAVERA_ANALYTICS_P6_GLOBAL.
ODI-1228: Task Journalizing-PRIMAVERA_ANALYTICS_P6_GLOBAL-Validate KM options fails on the target connection PRIMAVERA_ANALYTICS_SRC_DS1.
Caused By: java.sql.SQLException: ORA-06550: line 12, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 8, column 5:
PL/SQL: SQL Statement ignored

Cause

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