ETL Process Hangs At Step 43, Part 1 with Error: "Checkpoint not complete"
Last updated on JANUARY 26, 2017
Applies to:Primavera Data Warehouse - Version 184.108.40.206 and later
Information in this document applies to any platform.
When running the setup.sh (or setup.bat) to initiate STAR ETL process for Primavera Data Warehouse, the ETL process hangs at Step 43, Part 1 and does not complete ETL process for many hours. When terminating the ETL process, receive the below error message:
setup [ERROR] (Message) - The SQL script resource_assignment_spread.sql failed
setup [ERROR] (Message) - The SQL script activity_spread.sql failed
DIAGNOSING STEPS TAKEN TO ROOT CAUSE THIS ISSUE
1. From Alert.log, noticed many error as following:
2. From AWR report section "Active Session History (ASH) Report", we observed "log file switch(checkpoint incomplete)". See below detail:
|SQL ID||Planhash||Executions||% Activity||Event||% Event||Top Row Source||% RwSrc||SQL Text|
|123||123||300||22.06||CPU+Wait for CPU||12.13||** Row Source Not Available **||12.13||INSERT /*+ APPEND */ INTO W_AC...|
|log file switch(checkpoint incomplete)||9.12||** Row Source Not Available **||9.12|
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms