topic Re: tOracleBulkExec - Cannot run program "sqlldr" in Talend Studio

tOracleBulkExec - Cannot run program "sqlldr"

param75 — Thu, 13 Sep 2012 16:15:55 GMT

Hello,
I try to use the component tOracleBulkExec but I always have the following message :
Exception in component tOracleBulkExec_1
java.io.IOException: Cannot run program "sqlldr": 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 java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
at sis.toraclebulk_0_1.tOraclebulk.tOracleBulkExec_1Process(tOraclebulk.java:406)
at sis.toraclebulk_0_1.tOraclebulk.runJobInTOS(tOraclebulk.java:789)
at sis.toraclebulk_0_1.tOraclebulk.main(tOraclebulk.java:620)
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)
... 6 more
I execute my job on a unix server from the TAC.
A oracle client is present on this server. I have tested sqlldr directly on commande line on this server and it's worked.
The variables $ORACLE_HOME and $PATH exists :
$ echo $ORACLE_HOME
/home/oracle/product/9.2.0
$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/data/pmtalend/bin:/home/oracle/product/9.2.0/bin:/data/pmtalend/bin:/appli/jdk/bin:/appli/mysql/bin/
So I don't how can I resolve the problem.
Can you help me please ?

My version of the studio, commandline and TAC is : v5.0.1 (Talend Enterprise Data Integration Professional Edition)

Thank you,
Carole

Re: tOracleBulkExec - Cannot run program "sqlldr"

Anonymous — Fri, 14 Sep 2012 09:50:25 GMT

Hi, PM_param
The solution to this post is at https://community.talend.com/t5/Design-and-Development/tOracleBulkExec/td-p/62079
Hope it will help you. Furthermore, you can use the function of Talend Search to find the similiar issue posted by other members.
Best Regards
Sabrina

Re: tOracleBulkExec - Cannot run program "sqlldr"

Anonymous — Wed, 20 May 2015 21:02:53 GMT

Hi, I'm getting a SQL loader issue as well, my error is:
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:470)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
Does anyone know what the issue may be, thanks for your help.
Regards,
Brad

Re: tOracleBulkExec - Cannot run program "sqlldr"

Anonymous — Thu, 21 May 2015 15:29:06 GMT

Hi, I figured out my issue above; issue was I was using a user account that did not have rights to SQLLDR program. To correct I did the following.
1) Granted read, write, execute privileges to Oracle user for TOS workspace where projects resided and that were created with different user.
2) Logged in as Oracle and opened Talend UI.
3) Ran project and SQLLDR worked fine.
Regards,
Brad