My Oracle Support Banner

ETL Process Fails on LOAD_PLAN_DAILY Step Due to Duplicate Rows in Multiple Tables (Doc ID 2530308.1)

Last updated on OCTOBER 03, 2019

Applies to:

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

Symptoms

ETL Process fails and the following error occurs in the ETL logs:

[ERROR] PROC_AFTER_LOADING_PKG_PROJECT
  [DONE] PROC_MERGE_ACTIVITY_HISTORY_MONTH
  [ERROR] PROC_MERGE_PROJECT_HISTORY
  [DONE] 0 \-\ VAR_SCD_ONLY
  [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
  [ERROR] 1 \-\ Merge Project History
  [ERROR] 2 /-/ Procedure - Merge Project History - Merge Project History
  [DONE] PROC_LOAD_CBS_HIERARCHY
  [DONE] PROC_FILL_EXPENSE_FIELDS
  [DONE] PROC_FILL_RISK_FIELDS
  [DONE] PROC_UPDATE_PROJECT_ACTIVITY_COUNT
  [DONE] PROC_MERGE_ACTIVITY_HISTORY
  [DONE] PROC_MERGE_ACTIVITY_HISTORY_WEEK
  [DONE] PROC_MERGE_WBS_HISTORY
  [DONE] PROC_LOAD_WBS_HIERARCHY
  [ERROR] After loading package project, duration = 1423 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 3589 seconds

 

The issue can be reproduced at will with the following steps:
   1. Run the ETL process.
   2. Process fails with the reported error.

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!


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