My Oracle Support Banner

Traditional ETL Steps 45 and 65 Runs for Hours (Doc ID 2828474.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Primavera Analytics - Version 20.12 and later
Information in this document applies to any platform.

Symptoms

ETL runs for a long time for step 45 and step 65.

Step 45/79 Part 3/3 UpdateProjectEpsStepWids
Completed Step 45/79 Part 3/3 - DONE (6 hours, 51 minutes, 35 seconds, 398 milliseconds)

Step 63, Part 1
merge_wbs_history.sql - Processed 200430 rows in 34189.76/s at rate of 5.862/s
02:24:41.153 [main] INFO ETL.Progress - Step 63/79 Part 1/2 - DONE (9 hours, 29 minutes, 56 seconds, 405 milliseconds)

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
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.