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 AUGUST 02, 2023

Applies to:

Symptoms

When attempting to login to P6 Professional as a non-admin superuser, one of the following errors 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.