My Oracle Support Banner

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

Last updated on MARCH 09, 2020

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Primavera Data Warehouse - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

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
[ERROR] PROC_POPULATE_SECURITY
[DONE] 0 \-\ VAR_DATASOURCE_ID
[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

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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