All ETL Load Plans and StarETL Process Have Failed
(Doc ID 2629685.1)
Last updated on MAY 12, 2022
Applies to:
Primavera Analytics Cloud Service - Version 19.11 and laterInformation in this document applies to any platform.
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
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 |
References |