Incomplete Resource or Role Limit Data and the Analytics ETL Process Fails With Error "ORA-00001: unique constraint (STARUSER.NDX_W_RESOURCE_LIMIT_F_RDID) violated"

(Doc ID 2351950.1)

Last updated on APRIL 06, 2018

Applies to:

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

Symptoms

Primavera Analytics

Resource and/or role limit data is not being populated by analytics.  The ETL process may encounter the error below:

ETL process fails with error:

[ERROR] After Loading Package Global, duration = 875 seconds
[ERROR] PROC_AFTER_LOADING_PKG_GLOBAL
[DONE] 0 \-\ Load EPS Resource Role Hierarchies
[DONE] 1 /-/ Procedure - Load EPS Resource Role Hierarchies - LoadEpsResRoleHierarchies
[DONE] 1 \-\ VAR_LOAD_ALL_HIER_CODES
[DONE] 2 /-/ Variable - VAR_LOAD_ALL_HIER_CODES - null
[DONE] 2 \-\ Load Code Hierarchy
[DONE] 3 /-/ Procedure - Load Code Hierarchy - Load Code Hierarchy
[DONE] 3 \-\ VAR_LOAD_RESOURCE_ROLE_LIMIT
[DONE] 4 /-/ Variable - VAR_LOAD_RESOURCE_ROLE_LIMIT - null
[ERROR] 4 \-\ Load Resource Role Limit
[ERROR] 5 /-/ Procedure - Load Resource Role Limit - ResourceRoleLimit
ODI-1228: Task Procedure-Load Resource Role Limit-ResourceRoleLimit fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (STARUSER.NDX_W_RESOURCE_LIMIT_F_RDID) violated
ORA-06512: at "STARUSER.RES_ROLE_LIMIT_PKG", line 104



Steps to Reproduce
1.  Run the RunETL process via the P6 web utility. 

Note:  ODI (Oracle Data Integrator) is used to populate Star.


2.  Observe reported error.

Changes

 

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