Database DataWarehousing (MOSC)

MOSC Banner

While trying to run the ETL on App Server, I am getting an Java IO Exception error Intermittently

ETL throws intermittent error. Here is the version details

Primavera Datawarehouse Version - 16.1

Primavera Analytics - 16.1

Java - 8u291

Oracle DB - 12.1.0.2.v23

Please find detailed error detail as below. Any guidance will be greatly helpful.

java.io.IOException: Cannot run program ""sqlplus"": CreateProcess error=5, Access is denied

at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)

at java.lang.Runtime.exec(Runtime.java:621)

at java.lang.Runtime.exec(Runtime.java:451)

at java.lang.Runtime.exec(Runtime.java:348)

at com.primavera.er.util.ThreadedSqlScriptPool$SqlScriptRunner.call(Unknown Source)

at com.primavera.er.util.ThreadedSqlScriptPool$SqlScriptRunner.call(Unknown Source)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center