Error: "Bad Private User Name or Password. Check the Public Group ID. SQL State: 1, SQL Error Code: 208, Level: 16, Procedure: , Line: 1 Invalid Object Name 'PUBUSER'." When Connecting To P6 Database (Doc ID 2251290.1)

Last updated on APRIL 11, 2017

Applies to:

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

Symptoms

When attempting to connect a database alias to a SQL Server database, the following error occurs:

ERROR
-----------------------
Unable to connect to the database, would you like to configure your database now? After clicking 'Yes' and upon finishing the DB Configuration wizard in the end receive error: Bad private user name or password. Check the public group ID. SQL State: 1, SQL Error Code: 208, Level: 16, Procedure: , Line: 1
Invalid object name 'PUBUSER'.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Launch P6 Professional login screen
  2. Provide username and password and click ok
  3. Receive first message
  4. Click Yes on the message and finish going through the DB Configuration wizard
  5. Observe second message.

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

Changes

 

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