Error: "Primary Constraint PK_UAccess Cannot Insert Duplicate Key in Object UACCESS" or "Error: ORA-00001: Unique Constraint (ADMUSER.PK UACCESS) Violated" or "Exception TDBXError in Module PM.exe at $Address." When Logging Into P6 Professional (Doc ID 896323.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 3.5 and later
All Platforms

Symptoms

When attempting to login to P6 Professional as a non-admin superuser, the following error occurs:

ERROR
-------
Primary constraint PK_UAccess cannot insert duplicate key in object UACCESS

OR

ERROR
-------
Exception TDBXError in module PM.exe at $Address.
ORA-00001: unique constraint (ADMUSER.PK UACCESS) violated
ORA-06512: at "ADMUSER.POPULATE_UACCESS", line 20
ORA-06512: at "ADMUSER.UACCESS_MAINTAIN_FOR_USER", line 5
ORA-06512: at line 2

OR


ERROR
-------
Exception Exception in module PM.exe at 0024C4FF.
Error executing query. Error: ORA-00001: unique constraint (ADMUSER.PK UACCESS) violated
ORA-06512: at "ADMUSER.POPULATE UACCESS", line 20
ORA-06512: at "ADMUSER.UACCESS MAINTAIN FOR USER",
ORA-06512: at line 5
Session -1 - privuser:: (PM.exe)- cp1252 DCD6-4A27-10224364
DB Connection oracle.jdbc.driver.T4CConnection@78e6017a
Request type: CALL SP
Command UACCESS MAINTAIN FOR USER
Parameter count: 3
0 INPUT Integer z 444
1 INPUT Integer z o
2-- INPUT- string Y
Block count: 0
Total data size: 0 bytes (before compression)
Total job time spent to push in the queue: 0 ms
Total job time: 0 ms (not including compression)

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