Error: "ORA-01017: Invalid Username/password; Logon Denied" During Step 1, Part 1 and Step 4, Part 1 of the Incremental ETL Process After Changing the P6 EPPM Private Database User Password (Doc ID 2100725.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

When attempting to run the incremental.bat|.sh for the reporting database, the following error occurs at Step 1, Part 1 (Synchronize Stage with source PMDB server date (SynchEtlServerDate)), and step 4 part 1 (start of incremental load process):

ERROR
-----------------------
ON STEP 1:
  TIMESTAMP incremental [ERROR] (Message) - ORA-01017: invalid username/password; logon denied
  java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.getConnection(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.getPmdbServerDate(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.for(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.start(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.primavera.er.util.JavaClassInvokerAction.doAction(Unknown Source)
at com.primavera.er.util.CommandInvoker.a(Unknown Source)
at com.primavera.er.util.CommandInvoker.invoke(Unknown Source)
at com.primavera.er.util.CommandInvoker.main(Unknown Source)
  TIMESTAMP incremental [ERROR] (Message) - ERROR: java.lang.NullPointerException
  java.lang.NullPointerException
at com.primavera.er.util.SynchEtlServerDate.getPmdbServerDate(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.for(Unknown Source)
at com.primavera.er.util.SynchEtlServerDate.start(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.primavera.er.util.JavaClassInvokerAction.doAction(Unknown Source)
at com.primavera.er.util.CommandInvoker.a(Unknown Source)
at com.primavera.er.util.CommandInvoker.invoke(Unknown Source)
at com.primavera.er.util.CommandInvoker.main(Unknown Source)

ON STEP 4:

TIMESTAMP incremental [INFO] (Message) - === Step 4, Part 1 ====================================================
TIMESTAMP incremental [INFO] (Message) - === Run incremental load process
TIMESTAMP incremental [DEBUG] (Message) - SQL Plus(3) : [-s] [STAGEUSER/{db.stage.application.password}@(connectinfo)] [@run$script.sql]
TIMESTAMP incremental [INFO] (Message) - BEGIN populate_etl_refrdel_deletes; END;
TIMESTAMP incremental [INFO] (Message) - *
TIMESTAMP incremental [INFO] (Message) - ERROR at line 1:
TIMESTAMP incremental [INFO] (Message) - ORA-01017: invalid username/password; logon denied
TIMESTAMP incremental [INFO] (Message) - ORA-02063: preceding line from STAGE2PMDB
TIMESTAMP incremental [INFO] (Message) - ORA-06512: at "STAGEUSER.POPULATE_ETL_REFRDEL_DELETES", line 43
TIMESTAMP incremental [INFO] (Message) - ORA-06512: at line 1
TIMESTAMP incremental [INFO] (Progress) - Step 4/34 Part 1/4 - FAILED (1017) (0 hours, 0 minutes, 1 seconds, 687 milliseconds)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update privuser password in DB: alter user privuser identified by $newpassword
2. Run dbconfig.exe from P6 Professional installation to update PUBUSER table
3. Confirm successful login to P6 Professional
4. Run incremental.bat
5. Note the following error during Step 1, Part 1 (Synchronize Stage with source PMDB server date (SynchEtlServerDate))

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

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