Error: " Could not find log file $STARETL_Home\scripts\etl_calculations.log" When Running The STARETL Or Setup Process (Doc ID 2157918.1)

Last updated on JULY 08, 2016

Applies to:

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

Symptoms

 When attempting to run the STARETL or SETUP process, the following error occurs during the ETL Calculation step which utilizes an Oracle Client SQL Loader:

ERROR

TIMESTAMP setup [INFO] (Message) - === Step 13, Part 3 ====================================================
TIMESTAMP setup [INFO] (Message) - === Load metadata tables (etl_calculations.ldr)
TIMESTAMP setup [WARN] (Message) - Could not find log file C:\PrimaveraDataWarehouse\star\etl_homes\staretl1\scripts\etl_calculations.log
java.io.FileNotFoundException: C:\PrimaveraDataWarehouse\star\etl_homes\staretl1\scripts\etl_calculations.log (The system cannot find the file specified)
   at java.io.FileInputStream.open0(Native Method)
   at java.io.FileInputStream.open(FileInputStream.java:195)
   at java.io.FileInputStream.<init>(FileInputStream.java:138)
   at java.io.FileReader.<init>(FileReader.java:72)
   at com.primavera.er.util.SqlLoader$SqlLoaderCall.a(Unknown Source)
   at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(Unknown Source)
   at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(Unknown Source)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at java.lang.Thread.run(Thread.java:745)
TIMESTAMP setup [ERROR] (Message) - SqlLoaderSQL LOADER ACTION FAILED. [control=C:\PrimaveraDataWarehouse\star\etl_homes\staretl1\scripts\etl_calculations.ldr]
TIMESTAMP setup [INFO] (Message) - Connecting to database...
TIMESTAMP setup [INFO] (Progress) - Step 13/64 Part 3/4 - FAILED (-1) (0 hours, 1 minutes, 8 seconds, 828 milliseconds)

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