My Oracle Support Banner

ETL Process Failed With Error:"java.sql.SQLException: ORA-01017: Invalid Username/password; Logon Denied" (Doc ID 2140296.1)

Last updated on DECEMBER 13, 2018

Applies to:

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

Symptoms

When attempting to run startetl script, the ETL process failed with the following errors:

     staretl [INFO] (Message) - === Create the Star database (InvokeScriptRunner)
     staretl [INFO] (Message) - [DATE TIME] Setting override properties
     staretl [ERROR] (Message) - The main class (com.primavera.database.tools.ScriptRunner.InvokeScriptRunner) failed
     java.sql.SQLException: ORA-01017: invalid username/password; logon denied

and

     staretl [INFO] (Message) - === Create the Star database (InvokeScriptRunner)
     staretl [INFO] (Message) - [DATE TIME] Setting override properties
     staretl [ERROR] (Message) - The main class (com.primavera.database.tools.ScriptRunner.InvokeScriptRunner) failed
     java.sql.SQLException: ORA-28000: the account is locked

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.