tOracleBulkExec - Cannot run program "sqlldr"

One Star

tOracleBulkExec - Cannot run program "sqlldr"

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
Moderator

Re: tOracleBulkExec - Cannot run program "sqlldr"

Hi, PM_param
The solution to this post is at http://www.talendforge.org/forum/viewtopic.php?id=23729
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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleBulkExec - Cannot run program "sqlldr"

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
 
One Star

Re: tOracleBulkExec - Cannot run program "sqlldr"

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