My Oracle Support Banner

ETL Submitted Via P6rdb Application Fails With "SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory" (Doc ID 2748242.1)

Last updated on FEBRUARY 08, 2021

Applies to:

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

Symptoms

When attempting to run the staretl via the Primavera Analytics administration,
the following error occurs.

ERROR

13:22:19.988 [main] INFO ETL.Progress - Step 1/78 Part 1/1 - [01/26/2021 13:22:19] InitialParameterUpdate -- Update ETL parameters (UpdateEtlParameters)
13:22:19.990 [main] INFO ETL.Message - === Step 1, Part 1 ====================================================
13:22:19.990 [main] INFO ETL.Message - === Update ETL parameters (UpdateEtlParameters)
13:22:19.990 [main] INFO ETL.Message - No Set Properties
13:22:20.076 [main] INFO ETL.Progress - Step 1/78 Part 1/1 - DONE (0 hours, 0 minutes, 1 seconds, 146 milliseconds)

13:22:20.721 [main] INFO ETL.Message - Reading Properties file
13:22:21.355 [main] INFO ETL.Message - Connecting to database...
13:22:21.654 [main] INFO ETL.Message - Connecting to database...
13:22:21.816 [main] INFO ETL.Progress - Step 2/78 Part 1/1 - [01/26/2021 13:22:21] StartProcess -- Start ETL Process (status_start_run.sql)
13:22:21.817 [main] INFO ETL.Message - === Step 2, Part 1 ====================================================
13:22:21.817 [main] INFO ETL.Message - === Start ETL Process (status_start_run.sql)
13:22:21.925 [Thread-4] WARN ETL.Message - Error 6 initializing SQL*Plus
13:22:21.925 [Thread-4] WARN ETL.Message - SP2-0667: Message file sp1<lang>.msb not found
13:22:21.925 [Thread-4] WARN ETL.Message - SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
13:22:21.929 [main] INFO ETL.Progress - Step 2/78 Part 1/1 - FAILED (1) (0 hours, 0 minutes, 1 seconds, 211 milliseconds)

13:22:22.563 [main] INFO ETL.Message - Reading Properties file
13:22:23.188 [main] INFO ETL.Message - Connecting to database...
13:22:23.489 [main] INFO ETL.Message - Connecting to database...
13:22:23.662 [main] INFO ETL.Message - ---------------------------------------------------------------------------------------
13:22:23.662 [main] INFO ETL.Message - No Set Properties
13:22:23.663 [main] INFO ETL.Message - Connecting to database...
Process Failed with Error


Steps to Reproduce

  1. In browser, access the p6rdb application (localhost:port/p6rdb).
  2. Choose to Run ETL.
  3. Refresh until the job "appears to complete".
  4. A startetlprocess job gets created on the "data warehouse" server in folder staretl1\log.  Review the file for error(s).

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.