Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tdbOutputBulk Exec is failing while loading into oracle

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

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

Regards
Shong

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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

Regards
Shong