Error when running a job with tOracleBulkExec

Overview

When running a job in the Talend Administration Console (TAC) an error is displayed:

"Exception in component tOracleBulkExec_1
java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory"

 

The same job runs without error when running in Talend Studio on the same machine.

The same user is running the TAC and the Studio.

 

Symptoms/Description

The job includes a tOracleBulk component. It runs well when executed locally, but fails when using the JobServer. The PATH used by Talend was not the same as the one on the Server. The database client software is running properly and the sqlldr external utility has been installed on the execution server. When logged using putty, environment variables are set correctly: ORACLE_HOME, PATH ..

 

When running the job via TAC, the error is:

 

java.io.IOException: Cannot run program "sqlldr": error=2, Aucun fichier ou dossier de ce type
java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory;1

When running it directly on the execution server, it runs fine.

 

Resolution

Check if you used the same login for the Studio and TAC, but a different one for the JobServer.

For example, was one of the Talend Services launched using root and all the others were launched using a user called talend?

Modify the setup starting script that launches all services to use the same login (for example, talend) and everything should work fine.

 

Bookshelf references

Installing database client software (for bulk mode)

tOracleBulkExec

Version history
Revision #:
7 of 7
Last update:
‎05-16-2017 08:12 PM
Updated by: