My Oracle Support Banner

Primavera Data Warehouse ETL Process Hangs At Step 43, Part 1 with Error: "Checkpoint not complete" (Doc ID 2223454.1)

Last updated on MARCH 21, 2018

Applies to:

Primavera Data Warehouse - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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:

Thread 1 advanced to log sequence 18671 (LGWR switch)

Current log# 2 seq# 18671 mem# 0: /u01/DATA/redo21.log

Current log# 2 seq# 18671 mem# 1: /u01/DATA/redo22.log

Thread 1 cannot allocate new log, sequence 18672

Checkpoint not complete

Current log# 2 seq# 18671 mem# 0: /u01/DATA/redo21.log

Current log# 2 seq# 18671 mem# 1: /u01/DATA/redo22.log

Wed Sep 14 12:31:40 2016

Thread 1 advanced to log sequence 18672 (LGWR switch)

Current log# 3 seq# 18672 mem# 0: /u01/DATA/redo31.log

Current log# 3 seq# 18672 mem# 1: /u01/DATA/redo32.log

Thread 1 cannot allocate new log, sequence 18673

Checkpoint not complete

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  

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!


In this Document
Symptoms
Changes
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.