Upgrading Data Warehouse Schema By Running upgradeStar.sh Fails With Error "ORA-01403: no data found; ORA-06512: at 'STARUSER.VERSION_FROM_LINK'; ORA-06512: at 'STARUSER.UDF_UNIFIER'"

(Doc ID 2396548.1)

Last updated on MAY 25, 2018

Applies to:

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

Symptoms

When attempting to run upgradeStar.sh (or .cmd on Windows) script to upgrade Primavera Data Warehouse schema, the following error occurs:

ERROR
-----------------------
......
TIMESTAMP [main] INFO ETL.Progress - Step 29/82 Part 1/1 - [02/27/2018 14:13:35] AddUnifierUdfMappings -- Add Unifer BP UDF Mappings (add_unifier_udf_mappings.sql)
TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] INFO ETL.Message - === Step 29, Part 1 ====================================================
TIMESTAMP [main] INFO ETL.Message - === Add Unifer BP UDF Mappings (add_unifier_udf_mappings.sql)
TIMESTAMP [Thread-1] INFO ETL.Message - declare
TIMESTAMP [Thread-1] INFO ETL.Message - *
TIMESTAMP [Thread-1] INFO ETL.Message - ERROR at line 1:
TIMESTAMP [Thread-1] INFO ETL.Message - ORA-01403: no data found
TIMESTAMP [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.VERSION_FROM_LINK", line 17
TIMESTAMP [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.UDF_UNIFIER", line 64
TIMESTAMP [Thread-1] INFO ETL.Message - ORA-06512: at line 5
TIMESTAMP [main] INFO ETL.Progress - Step 29/82 Part 1/1 - FAILED (123) (0 hours, 0 minutes, 1 seconds, 165 milliseconds)
......


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run script upgradeStar.sh
2. The process failed with above error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the upgrade.

Changes

 

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