My Oracle Support Banner

ETL FAILED WITH ERROR ORA-00942: TABLE OR VIEW DOES NOT EXIST (Doc ID 2639086.1)

Last updated on FEBRUARY 14, 2020

Applies to:

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

Symptoms

Load Plans failing with the following error,

ERROR
-----------------------
Load plan name: LOAD_PLAN_ON_DEMAND
Datasource: staretl1
Instance id:
Run start time:
Run end time:
Status: ERROR
Error message: ODI-1519: Serial step "Loop publish projects (InternalID:10)" failed because child step "Case Data Source Type (InternalID:11)" is in error.

[ERROR] Loop publish projects, duration = 37000 seconds
  [ERROR] Case Data Source Type, duration = 36992 seconds
  [ERROR] rootStep_caseWhen, duration = 36992 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
oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  [ERROR] 10) LOOP_ON_DEMAND_P6, duration = 36991 seconds


 

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


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