Error: "ORA-00942: table or view does not exist" When Running A Data Warehouse Refresh (Setup.bat "-r") On Step 17

(Doc ID 2285630.1)

Last updated on AUGUST 23, 2017

Applies to:

Primavera Analytics - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a Data Warehouse refresh (by using setup.bat "-r" from path \PrimaveraDataWarehouse\star\etl_homes\staretl1\scripts), the following error occurs on Step 17, Part 3:

ERROR
-----------------------
ORA-00942: table or view does not exist

STEPS
-----------------------
1. Open command prompt from path \PrimaveraDataWarehouse\star\etl_homes\staretl1\scripts.
2. Type setup.bat "-r"
3. Process will be failed at Step 17/67 Part 3/3

<06.22.2017 20:55:24> setup [INFO] (Message) - Connecting to database...
<06.22.2017 20:55:24> setup [INFO] (Message) - Reading Properties file
<06.22.2017 20:55:25> setup [INFO] (Progress) - Step 17/67 Part 3/3 -
[06/22/2017 20:55:25] RefreshMetadata -- Refresh metadata tables (metadata\restore_metadata_tables_all.sql)
<06.22.2017 20:55:25> setup [INFO] (Message) - === Step 17, Part 3
====================================================
<06.22.2017 20:55:25> setup [INFO] (Message) - === Refresh metadata tables (metadata\restore_metadata_tables_all.sql)
<06.22.2017 20:55:25> setup [INFO] (Message) - declare
<06.22.2017 20:55:25> setup [INFO] (Message) - *
<06.22.2017 20:55:25> setup [INFO] (Message) - ERROR at line 1:
<06.22.2017 20:55:25> setup [INFO] (Message) - ORA-00942: table or view does not exist
<06.22.2017 20:55:25> setup [INFO] (Message) - ORA-06512: at line 31
<06.22.2017 20:55:25> setup [INFO] (Progress) - Step 17/67 Part 3/3 - FAILED
(942) (0 hours, 0 minutes, 0 seconds, 829 milliseconds)

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users cannot refresh STAR Schema with backup of history table.

Cause

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 hundreds of Community platforms