Error: "SqlLoaderCallSQL LOADER ACTION FAILED" When Running The ETL Process (Doc ID 1298813.1)

Last updated on NOVEMBER 25, 2013

Applies to:

Primavera P6 Reporting Database - Version R2 and later
Information in this document applies to any platform.
***Checked for relevance 25-Nov-2013***

Symptoms

The following is displayed in the etlprocess.log:

createdbs [ERROR] (Message) - SqlLoaderCallSQL LOADER ACTION FAILED.
java.io.IOException: Cannot run program "sqlldr" (in directory "."): java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at java.lang.Runtime.exec(Runtime.java:593)
at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(SqlLoader.java)
at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(SqlLoader.java)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: java.io.IOException: error=2, No such file or directory
at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
at java.lang.ProcessImpl.start(ProcessImpl.java:65)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
at java.lang.Runtime.exec(Runtime.java:593)
at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(SqlLoader.java)
at com.primavera.er.util.SqlLoader$SqlLoaderCall.call(SqlLoader.java)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
... 1 more


The console may also display the following timeout error:

[WARN] (ServerFacadeBase) - The session (id=A341393878922552B225D956E373C1A4) has been logged out due to time out.


In the r3.0 release, the error below can also be received in the etlprocess.log:

[INFO] (Message) - ORA-06512: at "STARUSER.LOAD2DIMENSION", line 75
[INFO] (Message) - Exception: Error during extract for table W_ACTIVITY_D: ORA-01747: invalid user.table.colum
[INFO] (Message) - (100,W_ACTIVITY_DS,W_ACTIVITY_D,n/a,n/a)
[INFO] (Message) - BEGIN
[INFO] (Message) - *
[INFO] (Message) - ERROR at line 1:
[INFO] (Message) - ORA-01747: invalid user.table.column, table.column, or column specification
[INFO] (Message) - ORA-06512: at "STARUSER.LOAD2DIMENSION", line 99'



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