ERROR "ORA-00001 - Unique Constraint (ADMUSER.PK UACCESS) Violated" When Logging Into P6 Professional Connecting To A P6 EPPM Database (Doc ID 2233694.1)

Last updated on APRIL 20, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 to 15.2.13.0 [Release 15.1 to 15.2]
Information in this document applies to any platform.

Symptoms

When attempting to log into P6, the following error occurs:

ERROR
--------
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


STEPS
-----------------------
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

This knowledge base document is specific to connecting to a 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