Private Database User (PRIVUSER), Public Database User (PUBUSER), Background Job User (BGJOBUSER) Or Reporting Database User (PXRPTUSER) Not Listed In Dropdown When Using DBSETUP To Upgrade A P6 EPPM Database (Doc ID 2135070.1)

Last updated on JUNE 27, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to upgrade P6 EPPM database (for example, from r8.3.2 to r16.1) using DBSETUP, any of the following conditions occur when required to select a P6 EPPM database user from the associated drop down fields:

EXPECTED BEHAVIOR
-----------------------
When attempting to upgrade a P6 EPPM database using DBSETUP, for the required database users to be present in the dropdown fields.

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

  1. Run dbsetup.bat (or .sh) utility
  2. Provide database connection information on database connection screen, then select Next
  3. Enter the P6 EPPM schema owner, then select Next.
  4. On the two screens:
    1. First Screen, the Private, Public, Background job users may possibly not display the associated usernames in the dropdown fields.
    2. Second Screen, the Reporting database user may possibly not display the associated username in the dropdown field.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully upgrade the P6 EPPM database.

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