My Oracle Support Banner

ETL Fails With Error "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at STARUSER.HIST_ROLLUP_PKG" (Doc ID 2594940.1)

Last updated on OCTOBER 28, 2019

Applies to:

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

Symptoms

The ETL job fails with error ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at "STARUSER.HIST_ROLLUP_PKG".

ETL log:


Complete load on W_WBS_SPREAD_F
[DONE] PROC_WBS_SPREAD_ROLL_UP
[DONE] WBS spread roll up, duration = 45 seconds
Complete update on W_PROJECT_HD
Complete load on
Complete load on W_PROJECT_HISTORY_F
[DONE] PROC_UPDATE_XLAT
[DONE] Update Xlat, duration = 199 seconds
[ERROR] PROC_AFTER_LOADING_PKG_SCD
[ERROR] 0 \-\ After SCD
[DONE] 1 /-/ Procedure - After SCD - UpdateWidsEpsHDWids
[DONE] 2 /-/ Procedure - After SCD - HistRollupActivity
[DONE] 3 /-/ Procedure - After SCD - HistRollupProject
[ERROR] 4 /-/ Procedure - After SCD - HistRollupWbs
ODI-1228: Task Procedure-After SCD-HistRollupWbs fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By:
java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at "STARUSER.HIST_ROLLUP_PKG",
line 449 ORA-06512: at line 2 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495) at

ODI Log:


oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108) at
Caused by: Error :
1452, Position : 0, Sql = begin hist_rollup_pkg.rollup_to_wbs_history(1); end;, OriginalSql = begin hist_rollup_pkg.rollup_to_wbs_history(1); end;,
Error Msg = ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at "STARUSER.HIST_ROLLUP_PKG", line 449
ORA-06512: at line 2 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499) ... 36 more
[ERROR] After loading package SCD, duration = 5 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 433 seconds

 

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.