Error: "ORA-28002: the password will expire within 7 days" When Running The StarETL (Doc ID 1498359.1)

Last updated on DECEMBER 15, 2016

Applies to:

Primavera Data Warehouse - Version R2.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2014***

Symptoms

When using an Oracle  database and attempting to run the ETL process, an error similar to the following occurs:


TIMESTAMP> staretl [INFO] (Progress) - Step 8/28 Part 1/1 - [TIMESTAMP] StartProcess -- Start ETL Process
staretl [INFO] (Message) - === Step 8, Part 1 ====================================================
staretl [INFO] (Message) - === Start ETL Process
staretl [INFO] (Message) - BEGIN status_start_run('FULL'); END;
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-28002: the password will expire within 7 days
staretl [INFO] (Message) - ORA-06512: at "STARUSER.TABLE_EXISTS_AT_LINK", line 11
staretl [INFO] (Message) - ORA-06512: at "STARUSER.VERSION_FROM_LINK", line 8
staretl [INFO] (Message) - ORA-06512: at "STARUSER.VALIDATE_DB_LINK", line 16
staretl [INFO] (Message) - ORA-06512: at "STARUSER.STATUS_START_RUN", line 14
staretl [INFO] (Message) - ORA-06512: at line 1
staretl [INFO] (Progress) - Step 8/28 Part 1/1 - FAILED (28002) (0 hours, 0 minutes, 2 seconds, 344 milliseconds)

 

This issue can be reproduced by running any of the following processes:

odsetl.bat, odsetl.sh

staretl.bat, staretl.sh

Due to this issue, the ETL process does not run successfully.

   

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