ETL Process Fails at Step 15 Part 2

(Doc ID 2293388.1)

Last updated on AUGUST 17, 2017

Applies to:

Primavera Data Warehouse - Version and later
Primavera Analytics - Version 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 Source)
at Source)
at Source)
at 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