topic Re: tDBBulkExec sur Remote Engine in Talend Studio

tDBBulkExec sur Remote Engine

ajourdan1684153368 — Fri, 15 Nov 2024 21:48:12 GMT

I currently have a problem on Talend to use tDBBulkExec components. I have to truncate/insert on an oracle database, it works well on the studio locally and on the command line on the different servers but via the TMC or the studio running on the remotes engine it's KO.

I have this error:

tDBBulkExec_1 Cannot run program "sqlldr": CreateProcess error=2, The specified file could not be found

I have a bulk file generated in the right place and accessible on the execution server, the SQLLDR installation is on the same disk as the remote engine, I have admin rights on the server with the user used

For the environments I am on talend cloud 8 with a studio and remotes engine on the client's windows servers. An Oracle SQL Loader in instant client is installed on the servers.

The installations between the dev and the recipe are identical, the directories are the same, the only thing that changes is the user who is used for the executions, on the studio server I have in my name who has admin rights and on the remotes engine they have a specific admin user.

Has anyone had the same problem with a tDBBulkExec and sql loader?

Re: tDBBulkExec sur Remote Engine

Anonymous — Wed, 17 May 2023 08:02:53 GMT

Hello,

please check if you have setup the below os environment variables in the recipe server:

ORACLE_HOME ->point to the oracle home directory path
Set the PATH to contain the directory where the sqlldr is stored

please refer to the below article

https://community.talend.com/s/article/tOracleBulkExec-and-tOracleOutputBulkExec-fail-with-a-java-io-IOException-Cannot-run-program-sqlldr-error-No-such-file-or-directory-error-Gbnjq

Re: tDBBulkExec sur Remote Engine

ajourdan1684153368 — Wed, 17 May 2023 16:13:52 GMT

Hello,

Thanks to the answer.

Yes we have the Oracle_home environment variable, and the repository is good to the sqlldr.

Link seem's to not work.

Thanks,

Re: tDBBulkExec sur Remote Engine

Anonymous — Thu, 18 May 2023 06:57:25 GMT

please try the below link

tOracleBulkExec and tOracleOutputBulkExec fail with a 'java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory' error (talend.com)