My Oracle Support Banner

Error 'Invalid object name 'PUBUSER'' When Configuring the Connection to the P6 Database (Doc ID 2251290.1)

Last updated on DECEMBER 03, 2019

Applies to:

Primavera P6 Professional Project Management - Version 8.1.0.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:

Unable to connect to the database, would you like to configure your database now?

After clicking Yes and stepping through the Database Configuration Wizard, the process fails with the following 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'.

 

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

  1. Launch P6 Professional.
  2. Enter a username and password and click OK.
  3. The first message displays; click Yes.
  4. Step through the Database Configuration Wizard.
  5. The connection fails and the second message displays.

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!


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