STAR ETL Fails At Step 30 With Error: "ORA-00001: unique constraint (STARUSER.W_PROJECT_SECURITY_S_KEY) violated" (Doc ID 1996081.1)

Last updated on JUNE 12, 2015

Applies to:

Primavera Data Warehouse - Version R3.2 and later
Information in this document applies to any platform.

Symptoms

 When running the STARETL process, step 30 project_security.sql fails with error in staretlprocess.log file.

<02.13.2015 19:08:16> staretl INFO (Progress) - Step 30/48 Part 1/1 - 02/13/2015 19:08:16 SecurityLoad -- Load Security Tables (sec_load)
<02.13.2015 19:08:16> staretl INFO (Message) - Connecting to jdbc:oracle:thin:@//10.41.63.7:1521/P6WPRD as STARUSER
<02.13.2015 19:08:42> staretl INFO (Message) - === Step 30, Part 1 ====================================================
<02.13.2015 19:08:42> staretl INFO (Message) - === Load Security Tables (sec_load)
<02.13.2015 19:08:42> staretl INFO (Message) - Adding sql script resource_security.sql to the job queue
<02.13.2015 19:08:42> staretl INFO (Progress) - Starting Script resource_security.sql
<02.13.2015 19:08:42> staretl INFO (Message) - Adding sql script project_security.sql to the job queue
<02.13.2015 19:08:42> staretl INFO (Progress) - Starting Script project_security.sql
<02.13.2015 19:10:47> staretl INFO (Message) - LoadSecurity Insert Time for 17931 rows ON table w_resource_security_s is 2.084
<02.13.2015 19:10:47> staretl INFO (Message) - mins (125.03s) at rate 143.414/s
<02.13.2015 19:10:47> staretl INFO (Message) - Complete load on w_resource_security_s for table w_resource_security_s
<02.13.2015 19:10:47> staretl INFO (Message) - rows=17931
<02.13.2015 19:10:47> staretl INFO (Message) - Processed 17931 rows in 125.048/s at rate of 143.393/s
<02.13.2015 19:10:47> staretl INFO (Message) - PL/SQL procedure successfully completed.
<02.13.2015 19:10:47> staretl INFO (Progress) - Finished Script resource_security.sql
<02.13.2015 19:11:54> staretl INFO (Message) - ORA-06512: at line 27
<02.13.2015 19:11:54> staretl INFO (Message) - Exception: Error during load for table W_PROJECT_SECURITY_S: ORA-00001: unique
<02.13.2015 19:11:54> staretl INFO (Message) - constraint (
<02.13.2015 19:11:54> staretl INFO (Message) - (100,W_PROJECT_SECURITY_SS,W_PROJECT_SECURITY_S,n/a,n/a)
<02.13.2015 19:11:54> staretl INFO (Message) - declare
<02.13.2015 19:11:54> staretl INFO (Message) - *
<02.13.2015 19:11:54> staretl INFO (Message) - ERROR at line 1:
<02.13.2015 19:11:54> staretl INFO (Message) - ORA-00001: unique constraint (STARUSER.W_PROJECT_SECURITY_S_KEY) violated
<02.13.2015 19:11:54> staretl INFO (Message) - ORA-06512: at line 126
<02.13.2015 19:11:54> staretl INFO (Progress) - Finished Script project_security.sql

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