ETL Process Fails at Step 15 Part 2 (Doc ID 2293388.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

The StarETL process fails and the following error occurs in the log:

ERROR

staretl [INFO] (Progress) - Step 15/50 Part 2/3 - [05/17/2017 14:03:04] SourceExtraction -- Extract data from source database (source_extract)
staretl [INFO] (Message) - Connecting to database...
staretl [DEBUG] (Progress) - DBConnection Manager getting connection
staretl [DEBUG] (Progress) - DBConnection Manager got connection in 0 hours, 0 minutes, 10 seconds, 657 milliseconds
staretl [INFO] (Message) - === Step 15, Part 2 ====================================================
staretl [INFO] (Message) - === Extract data from source database (source_extract)
staretl [ERROR] (Message) - Exception thrown running invoker (NullPointerException)
java.lang.NullPointerException
at com.primavera.er.util.SqlSetInvokerAction.doAction(Unknown Source)
at com.primavera.er.util.CommandInvoker.a(Unknown Source)
at com.primavera.er.util.CommandInvoker.invoke(Unknown Source)
at com.primavera.er.util.CommandInvoker.main(Unknown Source)
staretl [INFO] (Progress) - Step 15/50 Part 2/3 - FAILED (1) (0 hours, 0 minutes, 11 seconds, 329 milliseconds)


The issue can be reproduced at will with the following steps:
1. Run staretl.bat (/.sh).
2. The process fails with the reported error.


Due to this issue, the ETL process does not complete successfully.

Cause

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 hundreds of Community platforms