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)
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
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