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.
ETL Process fails and the following error occurs in the ETL logs:
[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
[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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!