My Oracle Support Banner

Bad private user name or password. Check the public group ID. Invalid object name 'PUBUSER.' When Attempting to Configure the Database Alias (Doc ID 2747349.1)

Last updated on JANUARY 27, 2021

Applies to:

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

Symptoms

When attempting to configure a database alias for a new P6 PPM 20.12 SQL Server database, the following error occurs:

ERROR

Bad private user name or password. Check the public group ID. Invalid object name 'PUBUSER.'

STEPS

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

1.  Create a brand new P6 PPM 20.12 SQL Server database using DBSetup.bat.

2.  From the P6 PPM client 20.12 login window, click "Edit database configuration?" link.

3.  Click "Add".

4.  Select Driver Type:  "Microsoft SQL Server/SQL Express"

5.  Enter the connection string using this format:  ServerName/DatabaseName

4.  Observe after clicking "Next" and providing the public login information, the reported error is received.

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
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.