My Oracle Support Banner

Cannot Login to P6 Professional Using Null Password (Connect Button is Grayed Out) (Doc ID 2381365.1)

Last updated on NOVEMBER 13, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.1 and later
Primavera P6 Professional Project Management - Version 17.9.0.0 and later
Information in this document applies to any platform.

Symptoms

P6 Professional release 18 does not allow a user to login without typing in a password. Therefore, the method of using a null password to reset the password does not work, and the user cannot login.

For example: If a user forgets the password to the SQLite DB, nulling out the password, then logging in with a username/<blank password> doesn't work.

STEPS TO REPRODUCE:

  1. Create a P6 R18 SQLite database (example: release 18.1)
  2. Open the SQLite db and run the following per How to Reset an Application User's Password in P6 Professional using SQLite (Doc ID 1967526.1)
    update users set passwd = NULL;
    commit;
  3. Try to log in with the user that was created when the db was created (example: admin)
  4. Notice CONNECT button will be grayed out

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
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.