My Oracle Support Banner

Error "ORA-00001: unique constraint (ADMUSER.PK_SETTINGS) violated" When Publishing Resource Role Assignment Spread (Doc ID 2693308.1)

Last updated on OCTOBER 19, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.3.0 to 19.12.6.0 [Release 19.12]
Primavera P6 Enterprise Project Portfolio Management - Version 19.12.3.0 to 19.12.6.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

The following error occurs when publishing Resource Role Assignment Spread:

[TASK]:[WbsResourceQty]: [5] CORE(BRE): Task failed

[5] CORE(BRE): DBEngine.executeStatement for {call settings_write_date(?, ?, ?)}failed:ORA-00001: unique constraint (ADMUSER.PK_SETTINGS) violated ORA-06512: at "ADMUSER.SETTINGS_WRITE_STRING", line 21 ORA-06512: at "ADMUSER.SETTINGS_WRITE_DATE", line 8 ORA-06512: at line 1

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!

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