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)