My Oracle Support Banner

Error: ORA-00942: Table or View Does Not Exist When ETL Process Is Triggered Through the Windows Task Scheduler (Doc ID 2523516.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

Primavera Data Warehouse - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

After running the ETL process, it fails and,
the following error occurs in the StarETL logs

ERROR
-----------------------
staretl [INFO] (Message) - === Start ETL Process (status_start_run.sql)
staretl [INFO] (Message) - BEGIN status_start_run(1, 'FULL'); END;
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-00942: table or view does not exist
staretl [INFO] (Message) - ORA-02063: preceding line from DSLINK01
staretl [INFO] (Message) - ORA-06512: at "STARUSER.VERSION_FROM_LINK", line 35
staretl [INFO] (Message) - ORA-06512: at "STARUSER.VALIDATE_DB_LINK", line 16
staretl [INFO] (Message) - ORA-06512: at "STARUSER.STATUS_START_RUN", line 33


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
   1. Run ETL Process
   2. Notice it fails and the reported error is shown

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, ETL Process does not finish successfully.,

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


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