My Oracle Support Banner

Error 'ORA-00001: unique constraint (STARUSER.W_PROJECT_SECURITY_S_KEY) violated' While Executing the 'Unifier Company Security' Step of a Unifier ODI ETL (Doc ID 2467365.1)

Last updated on JANUARY 31, 2024

Applies to:

Primavera Analytics Cloud Service - Version to 22.8 [Release 17.11 to 22.8]
Primavera Analytics - Version and later
Primavera Data Warehouse - Version and later
Information in this document applies to any platform.


While running a Unifier ETL, the following error occurs in the "Unifier Company Security" step causing the ETL to fail:

[ERROR] 61) PROC_POPULATE_SECURITY, duration = 2 seconds
[DONE] 1 /-/ Variable - VAR_DATASOURCE_ID - null
[DONE] 1 \-\ Load User S
[DONE] 2 /-/ Procedure - Load User S - Load User S
[ERROR] 2 \-\ Unifier Company Security
[ERROR] 3 /-/ Procedure - Unifier Company Security - Unifier Company Security

ODI-1228: Task Procedure-Unifier Company Security-Unifier Company Security fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (STARUSER.W_PROJECT_SECURITY_S_KEY1) violated ORA-06512: at "STARUSER.SEC_LOAD_PKG", line 447 ORA-06512




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.