My Oracle Support Banner

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.