My Oracle Support Banner

StarETL Fails With Error: Cannot run program "sqlplus" (in directory "."): CreateProcess error=2, The system cannot find the file specified (Doc ID 2180920.1)

Last updated on APRIL 18, 2018

Applies to:

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

Symptoms

When attempting to run the STARETL process, the following error occurs.

staretl [DEBUG] (Message) - Main Arguments(13) : [-s] [********] [@run$script.sql] [SCRIPTNAME:create_sequences.sql] [/ACTION:SQLP] [/STEP:10] [/STEP_CNT:59] [/PART_CNT:1] [/UPDATESTATUS:N] [/NAME:CreateSequences] [/PROCESS:staretl] [/PART:1] [/DESC:Create sequences]
staretl [DEBUG] (Message) - Command Arguments(4) : [-s] [********] [@run$script.sql] [SCRIPTNAME:create_sequences.sql]
staretl [INFO] (Progress) - Step 10/59 Part 1/1 - [09/07/2016 12:05:35] CreateSequences -- Create sequences (create_sequences.sql)
staretl [INFO] (Message) - === Step 10, Part 1 ====================================================
staretl [INFO] (Message) - === Create sequences (create_sequences.sql)
staretl [DEBUG] (Message) - SQL Plus(4) : [-s] [********] [@run$script.sql] [SCRIPTNAME:create_sequences.sql]
staretl [ERROR] (Message) - Exception thrown running invoker (IOException)
java.io.IOException: Cannot run program "sqlplus" (in directory "."): CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1047)
at java.lang.Runtime.exec(Runtime.java:617)
at com.primavera.er.util.SqlScriptInvokerAction.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)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.(ProcessImpl.java:385)
at java.lang.ProcessImpl.start(ProcessImpl.java:136)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1028)
... 5 more
staretl [INFO] (Progress) - Step 10/59 Part 1/1 - FAILED (1) (0 hours, 0 minutes, 0 seconds, 500 milliseconds)

Due to this issue, user cannot run the STARETL process successfully.

Changes

 

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!


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