ETL Process Fails at Step 15 Part 2
Last updated on AUGUST 17, 2017
Applies to:Primavera Data Warehouse - Version 184.108.40.206 and later
Primavera Analytics - Version 220.127.116.11 and later
Information in this document applies to any platform.
The StarETL process fails and the following error occurs in the log:
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)
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.
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