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

TalendSolutionExpert — Fri, 09 Feb 2024 18:22:49 GMT

Talend Version	6.x 7.x 8.x
Summary	tOracleBulkExec and tOracleOutputBulkExec fail with the following error: java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory
Additional Versions
Product	Talend Data Integration
Component	JobServer,Remote Engine
Problem Description	tOracleBulkExec and tOracleOutputBulkExec fail with the following error: java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory
Problem root cause	PATH and ORACLE_HOME are not defined / not correctly set in the JobServer / Remote Engine process. To "dump" the environment variables defined in the JobServer / Remote Engine process, create a simple Job using a tJava component. Initialize the tJava component: In Basic settings, add the following: Map<String, String> env = System.getenv(); for (String envName : env.keySet()) { System.out.format("%s=%s%n", envName, env.get(envName)); } In Advanced settings, add the following: import java.util.Map; Run the Job to dump the environment variables. NOTE : for the Cloud (Remote Engine) replace the line : System.out.format("%s=%s%n", envName, env.get(envName)); by context.output += ( envName + " = " + env.get(envName) + "\n"); and display the context.output in the task log using a tJoblog Execute the task in the Cloud with "Execution log level" set to Info
Solution or Workaround	Modify the script launching the JobServer / Remote Engine start_rs.sh (JobServer/agent). Define ORACLE_HOME, for example: ORACLE_HOME=/apps/oracle/product/12.1.0/dbhome_1 export $ORACLE_HOME Set the PATH to contain the directory where the sqlldr is stored: PATH=$ORACLE_HOME/bin:$PATH export $PATH Notes: I - You can set the variables PATH and ORACLE_HOME at the OS level too. For more information, see the Oracle documentation. II - If the option "Run as" (user impersonation) is used , you'll need to update the file /etc/sudoers in order to add the lines : Defaults env_keep += "ORACLE_HOME" Defaults env_keep += "PATH" III - For Remote Engine launched as a service , you'll need to set the variables in the file <Remote Engine Folder>\etc\Talend Remote Engine-wrapper.conf Example : set.default.ORACLE_HOME=/data/oracle/product/19.0.0/client_1 set.default.PATH=/data/oracle/product/19.0.0/client_1/bin%WRAPPER_PATH_SEPARATOR%%PATH%%WRAPPER_PATH_SEPARATOR%.
JIRA ticket number

article tOracleBulkExec and tOracleOutputBulkExec fail with a 'java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory' error in Official Support Articles

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