My Oracle Support Banner

Staretl Job Fails for Several Consecutive Days (Doc ID 2574848.1)

Last updated on JUNE 30, 2021

Applies to:

Primavera Analytics Cloud Service - Version 19.4 and later
Information in this document applies to any platform.

Symptoms

The ODI ETL process (staretl) as well as on-demand jobs (LOAD_PLAN_ON_DEMAND, LOAD_PLAN_REALTIME_PROJECT, LOAD_PLAN_DAILY) fail for consecutive attempts with the following errors.

Load plan name: LOAD_PLAN_ON_DEMAND:

Datasource: staretl1
Status: ERROR
Error message: ODI-1530: Load plan instance was stopped by user request.
[ERROR]Loop publish projects, duration = 327859 seconds
[ERROR]Case Data Source Type, duration = 327857 seconds
[ERROR]rootStep_caseWhen, duration = 327857 seconds
[ERROR]LOOP_ON_DEMAND_P6
[DONE]0 \-\ VAR_DATASOURCE_ID
[DONE]1 /-/ Variable - VAR_DATASOURCE_ID - null
[DONE]1 \-\ VAR_SCENARIO_ID
[DONE]2 /-/ Variable - VAR_SCENARIO_ID - null
[DONE]2 \-\ VAR_ROW_WID_MULTIPLIER
[DONE]3 /-/ Variable - VAR_ROW_WID_MULTIPLIER - null
[DONE]3 \-\ VAR_EFFECTIVE_START_DATE
[DONE]4 /-/ Variable - VAR_EFFECTIVE_START_DATE - null
[DONE]4 \-\ VAR_EFFECTIVE_END_DATE
[DONE]5 /-/ Variable - VAR_EFFECTIVE_END_DATE - null
[ERROR]5 \-\ ODIWAITFORLOGDATA
[ERROR]6 /-/ Oracle Data Integrator Command - Oracle Data Integrator Command - null
ODI-1260: Session Task Oracle Data Integrator Command-Oracle Data Integrator Comm

Load plan name: LOAD_PLAN_REALTIME_PROJECT:

Datasource: staretl1
Status: ERROR
Error message: ODI-1530: Load plan instance was stopped by user request.
[ERROR]Real time loop for project tables, duration = 327858 seconds
[ERROR]Case Data Source Type, duration = 327855 seconds
[ERROR]rootStep_caseWhen, duration = 327855 seconds
[ERROR]LOOP_REALTIME_P6_PROJECT
[DONE]0 \-\ VAR_DATASOURCE_ID
[DONE]1 /-/ Variable - VAR_DATASOURCE_ID - null
[DONE]1 \-\ VAR_SCENARIO_ID
[DONE]2 /-/ Variable - VAR_SCENARIO_ID - null
[DONE]2 \-\ VAR_ROW_WID_MULTIPLIER
[DONE]3 /-/ Variable - VAR_ROW_WID_MULTIPLIER - null
[ERROR]3 \-\ ODIWAITFORLOGDATA
[ERROR]4 /-/ Oracle Data Integrator Command - Oracle Data Integrator Command - null
ODI-1260: Session Task Oracle Data Integrator Command-Oracle Data Integrator Command- stopped (Immediate) by user SUPERVISOR.
[ERROR]10) LOOP_REALTIME_P6_PROJECT, duration = 327853 seconds

Load plan [LOAD_PLAN_DAILY]:

[RUNNING]P6 Daily
...
[DONE]For slowly changing dimension projects, duration = 138 seconds
[ERROR]RUNNER_SCHEDULED_P6
...
[ERROR]P6_SCHEDULED_W_PROJECT_D_PHYSICAL
[ERROR]10 \-\ Physical_STEP
[ERROR]10 /-/ SERIAL - MAP_MAIN - null
[WARNING]20 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_SRC_LS_UNIT
[WARNING]30 /-/ Drop work table - LKM Oracle to Oracle (DBLINK) - null
[DONE]40 /-/ Lock journalized table - LKM Oracle to Oracle (DBLINK) - null
[DONE]50 /-/ Create view/table on source - LKM Oracle to Oracle (DBLINK) - null
[WARNING]60 /-/ Drop synonym on target - LKM Oracle to Oracle (DBLINK) - null
[DONE]70 /-/ Create synonym on target - LKM Oracle to Oracle (DBLINK) - null
[ERROR]80 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_TGT_LS_UNIT
[DONE]90 /-/ Create parking table - IKM Oracle Incremental Update (MERGE) - null
[WARNING]100 /-/ Drop flow table - IKM Oracle Incremental Update (MERGE) - null
[DONE]110 /-/ Create flow table I$ - IKM Oracle Incremental Update (MERGE) - null
[DONE]120 /-/ Delete staging table - IKM Oracle Incremental Update (MERGE) - null
[DONE]130 /-/ Truncate target table - IKM Oracle Incremental Update (MERGE) - null
[DONE]140 /-/ Analyze target table - IKM Oracle Incremental Update (MERGE) - null
[ERROR]150 /-/ Insert flow into I$ table - IKM Oracle Incremental Update (MERGE) - null
[ERROR]For scheduled interval projects, duration = 154 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 167 seconds

STARETL Log:

Complete update on W_XLAT_S
[ERROR]RUNNER_SCHEDULED_P6
[DONE]P6_SCHEDULED_W_WBS_NOTE_D_PHYSICAL
[DONE]P6_SCHEDULED_W_PROJECT_NOTE_D_PHYSICAL
[DONE]P6_SCHEDULED_W_WBS_D_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITYCODETYPE_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITYCODEASSIGNMENT_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITY_D_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITY_NOTE_D_PHYSICAL
[DONE]P6_SCHEDULED_W_P6_CBS_HIERARCHY_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITY_EXPENSE_D_PHYSICAL
[DONE]P6_SCHEDULED_W_RISK_D_PHYSICAL
[DONE]P6_SCHEDULED_W_WBS_HIERARCHY_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITYCODE_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ACTIVITY_RISK_DS_PHYSICAL
[DONE]P6_SCHEDULED_W_ASSIGNMENT_D_PHYSICAL
[DONE]P6_SCHEDULED_W_RESOURCE_ASSIGNMENT_D_PHYSICAL
[DONE]P6_SCHEDULED_W_PROJECTCODEASSIGNMENT_DS_PHYSICAL
[DONE]SPREAD_INCREMENT_LOAD
[DONE]P6_SCHEDULED_W_ACTIVITY_SPREAD_F_PHYSICAL
[DONE]P6_SCHEDULED_W_RESOURCE_ASSIGNMENT_SPREAD_F
[DONE]P6_SCHEDULED_W_ASSIGNMENT_SPREAD_F_PHYSICAL
[DONE]SPREAD_FULL_LOAD
[DONE]P6_SCHEDULED_W_ACTIVITY_STEP_D_PHYSICAL
[ERROR]P6_SCHEDULED_W_PROJECT_D_PHYSICAL
[ERROR]10 \-\ Physical_STEP
[ERROR]10 /-/ SERIAL - MAP_MAIN - null
[WARNING]20 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_SRC_LS_UNIT
[WARNING]30 /-/ Drop work table - LKM Oracle to Oracle (DBLINK) - null
[DONE]40 /-/ Lock journalized table - LKM Oracle to Oracle (DBLINK) - null
[DONE]50 /-/ Create view/table on source - LKM Oracle to Oracle (DBLINK) - null
[WARNING]60 /-/ Drop synonym on target - LKM Oracle to Oracle (DBLINK) - null
[DONE]70 /-/ Create synonym on target - LKM Oracle to Oracle (DBLINK) - null
[ERROR]80 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_TGT_LS_UNIT
[DONE]90 /-/ Create parking table - IKM Oracle Incremental Update (MERGE) - null
[WARNING]100 /-/ Drop flow table - IKM Oracle Incremental Update (MERGE) - null
[DONE]110 /-/ Create flow table I$ - IKM Oracle Incremental Update (MERGE) - null
[DONE]120 /-/ Delete staging table - IKM Oracle Incremental Update (MERGE) - null
[DONE]130 /-/ Truncate target table - IKM Oracle Incremental Update (MERGE) - null
[DONE]140 /-/ Analyze target table - IKM Oracle Incremental Update (MERGE) - null
[ERROR]150 /-/ Insert flow into I$ table - IKM Oracle Incremental Update
(MERGE) - null
[ERROR]For scheduled interval projects, duration = 157 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 178 seconds

Complete load on w_resource_security_s
[DONE]PROC_POPULATE_SECURITY
[DONE]71) PROC_POPULATE_SECURITY, duration = 88 seconds
[DONE]SCEN_OBIEE_PACKAGE
[ERROR]OBIEE_CACHE_PURGE_DAILY
[DONE]0 \-\ VAR_OBIEE_CACHE_PURGE_DAILY
[DONE]1 /-/ Variable - VAR_OBIEE_CACHE_PURGE_DAILY - null
[ERROR]1 \-\ OBIEE Cache Purge Daily
[ERROR]2 /-/ Procedure - OBIEE Cache Purge Daily - OBIEE Cache Purge Daily
ODI-1228: Task Procedure-OBIEE Cache Purge Daily-OBIEE Cache Purge Daily fails on the target connection
PRIMAVERA_ANALYTICS_OBIEE_DS. Caused By: java.sql.SQLException: java.io.IOException: [nQSError: 43113]
Message returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password.
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

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!


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