My Oracle Support Banner

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 JANUARY 02, 2019

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.

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!


In this Document
Symptoms
Changes
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.