Cannot Login to P6 Professional Using Null Password (Connect Button is Grayed Out)
Last updated on JULY 03, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.1 and later
Primavera P6 Professional Project Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
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:
- Create a P6 R18 SQLite database (example: release 18.1)
- Open that 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;
- Try to log in with the user that was created when the db was created (example: admin)
- Notice CONNECT button will be grayed out
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