tdbOutputBulk Exec is failing while loading into oracle

Anonymous — Mon, 28 Oct 2019 08:06:24 GMT

I m trying to insert file data in Oracle using Bulk . After running the job i m getting below error :

Also 2 files are getting created on disk with .csv and .csv.ctl extenstion But data is not getting loaded into oracle

tistics] connected
Exception in component tDBOutputBulkExec_1_tOBE (TapNgo)
java.io.IOException: Cannot run program "sqlldr": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)
at java.lang.Runtime.exec(Runtime.java:620)
at java.lang.Runtime.exec(Runtime.java:450)
at java.lang.Runtime.exec(Runtime.java:388)
at local_project.tapngo_0_1.TapNgo.tFileInputDelimited_1Process(TapNgo.java:2839)
at local_project.tapngo_0_1.TapNgo.runJobInTOS(TapNgo.java:3812)
at local_project.tapngo_0_1.TapNgo.main(TapNgo.java:3663)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:386)
at java.lang.ProcessImpl.start(ProcessImpl.java:137)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1029)
... 6 more

Re: tdbOutputBulk Exec is failing while loading into oracle

Anonymous — Mon, 28 Oct 2019 08:14:20 GMT

Hi
The machine where the job is executed should have Oracle client tool installation.

Regards
Shong

topic tdbOutputBulk Exec is failing while loading into oracle in Talend Studio

tdbOutputBulk Exec is failing while loading into oracle

Re: tdbOutputBulk Exec is failing while loading into oracle