Unable to Populate Private Database Logins from Connection <privuser/password@IP:DB> : SQLSyntaxErrorException (ORA-00942: Table or View Does Not Exist) When Attempting to Use Databaselogins

(Doc ID 1960605.1)

Last updated on MARCH 06, 2018

Applies to:

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


On : 8.x version, P6 EPPM Database Install, Setup and Configuration

When attempting to connect to a database with databaselogins.bat, the following error occurs.

Unable to populate private database logins from connection <privuser/password@IP:DB> : SQLSyntaxErrorException (ORA-00942: table or view does not exist)

The issue can be reproduced at will with the following steps:
1. double-click on databaselogins.bat
2. enter details and click next

The issue has the following business impact:
Due to this issue, users cannot encrypt the password for the privileged user and therefore login to P6 will fail.


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