Error: "Bad Public Username or Password. Login Timeout Expired" When Connecting to a P6 SQL Server Database (Doc ID 1967595.1)

Last updated on MAY 13, 2016

Applies to:

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

Symptoms

On :  8.4.0.0 version, Desktop Client Installation / Login

When attempting to login to P6, the following error occurs:

ERROR
-----------------------
AVAA0-3822-8

Or

Unable to Connect to the database.

When attempting to connect to the db using using the database configuration tool, the following error occurs:

ERROR
-----------------------
Bad public username or password. Login timeout expired

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to login to the P6 Professional Client
2. "AVAA0-3822-8" or "Unable to Connect to the database" occurs
3. Attempt to configure connection to the db using database configuration
4. Type in public user name/password
5. "Bad public username or password. Login timeout expired" occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot login to P6 to manage projects.

-----------------------
"Oracle will not accept my password"

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