[resolved] Exception in component tOracleOutputBulkExec_1_tOBE
Hi all,
i have exported the job to my server then i have set the cron entry as generated by talend ,shown below:
30 1 * * * /usr/local/jdk1.6.0_13/jre/bin/java -Xms256M -Xmx1024M -cp /usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/mail.jar:/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/jt400_V5R3.jar:/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/jxl.jar:/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/ojdbc14-10g.jar:/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/ojdbc6-11g.jar:/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java/activation.jar:/usr/local/talend/.Java/classes::/usr/local/talend/Talend-Win32-r46802-V4.1.0M4/lib/java: a2o.as400tooracle_0_1.AS400ToOracle --context=Default $*
BUT when this CRON entry runs i get a following error in my log file:
Exception in component tOracleOutputBulkExec_1_tOBE
java.io.IOException: Cannot run program "sqlldr": java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:459)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
at as400_to_oracle.as400tooracle_0_1.AS400ToOracle.tAS400Input_1Process(AS400ToOracle.java:18779)
at as400_to_oracle.as400tooracle_0_1.AS400ToOracle.tOracleRow_1Process(AS400ToOracle.java:950)
at as400_to_oracle.as400tooracle_0_1.AS400ToOracle.tJava_1Process(AS400ToOracle.java:811)
at as400_to_oracle.as400tooracle_0_1.AS400ToOracle.runJobInTOS(AS400ToOracle.java:21588)
at as400_to_oracle.as400tooracle_0_1.AS400ToOracle.main(AS400ToOracle.java:21486)
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:452)
... 8 more
But when i run the cron entry mentioned above on the command prompt it runs properly without any errors.
the JDK version on my server is : jdk1.6.0_13
Please help Thanks in advance .
Regards,
---Koustubh Avadhani.
