Error: "java.io.IOException: Cannot run program "sqlplus" (in directory "."): error=2, No such file or directory" Running The starETL As A Cron Job (Doc ID 1474637.1)

Last updated on FEBRUARY 03, 2016

Applies to:

Primavera P6 Reporting Database - Version R3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2014***

Symptoms

When running the startETL process as a Cron Job, the process fails at step 8 (Start ETL Process) and the following error is reported in the starETLProcess.log:

ERROR
-----------------------
staretl [INFO] (Message) - === Start ETL Process
staretl [ERROR] (Message) - Exception thrown running invoker (IOException)
java.io.IOException: Cannot run program "sqlplus" (in directory "."): error=2, No such file or directory
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
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: error=2, No such file or directory
at java.lang.UNIXProcess.forkAndExec(Native Method)
at java.lang.UNIXProcess.(Unknown Source)
at java.lang.ProcessImpl.start(Unknown Source)
... 6 more
staretl [INFO] (Progress) - Step 8/28 Part 1/1 - FAILED (1) (0 hours, 0 minutes, 0 seconds, 849 milliseconds)

Note: This issue does not occur if the starETL script is run manually, logged onto the server.

 

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