ERROR "ORA-00001 - Unique Constraint (ADMUSER.PK UACCESS) Violated" When Logging Into P6 Professional Connecting To A P6 EPPM Database
Last updated on SEPTEMBER 27, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.0 to 184.108.40.206 [Release 8.0 to 15.2]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 220.127.116.11 to 18.104.22.168 [Release 8.4 to 15.2]
Information in this document applies to any platform.
When attempting to log into P6, the following error occurs:
Exception Exception in module PM.exe at 0024C4FF.
Error executing query. Error: ORA-00001: unique constraint (ADMUSER.PK UACCESS) violated
Exception TDBXError in module PM.exe at 000000000036194F.
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
The issue can be reproduced at will with the following steps:
1. Log into P6 as a specific user
2. Note pop up error message
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