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 17.11.0.0 to 22.8 [Release 17.11 to 22.8]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! |