My Oracle Support Banner

ETL Step 63 "MERGE_SPREAD_SNAP_HISTORY" Takes an Extended Time to Run (Doc ID 2983157.1)

Last updated on NOVEMBER 03, 2023

Applies to:

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

Symptoms

When running the ETL process for Primavera Data Warehouse release 20.12, the merge_spread_snap_history.sql step is taking many hours to run.

The following entries can be found in the ETL log file:

19:11:58.925 [pool-2-thread-5] INFO ETL.Progress - Starting Script merge_spread_snap_history.sql
11:28:26.344 [Thread-9] INFO ETL.Message - SPREAD SNAPSHOT HISTORY MERGE :: CURRENT RUN DATE: 13-SEP-23
11:28:26.345 [Thread-9] INFO ETL.Message - MergeSpreadSnahpshotHistory Insert Time for 446526 rows on table
11:28:26.345 [Thread-9] INFO ETL.Message - W_SPREAD_SNAP_HISTORY_F is 976.446 mins (58586.76s) at rate 7.622/s
11:28:26.345 [Thread-9] INFO ETL.Message - Complete load on W_SPREAD_SNAP_HISTORY_F for table W_SPREAD_SNAP_HISTORY_F
11:28:26.345 [Thread-9] INFO ETL.Message - rows=446526
11:28:26.345 [Thread-9] INFO ETL.Message - Processed 446526 rows in 58586.816/s at rate of 7.622/s
11:28:26.345 [Thread-9] INFO ETL.Message - PL/SQL procedure successfully completed.
11:28:26.516 [pool-2-thread-5] INFO ETL.Progress - Finished Script merge_spread_snap_history.sql
Step 63/79 Part 1/2 - DONE (16 hours, 16 minutes, 28 seconds, 730 milliseconds)

(note the 15.5-hour difference in the time stamps)

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.