tOracleBulkExec

One Star

tOracleBulkExec

Hello,
I want to know why this error occured?
Please help me.
=========================================================================
connecting to socket on port 3541
connected
Exception in component tOracleBulkExec_2
java.io.IOException: Cannot run program "sqlldr": CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.tOracleBulkExec_2Process(TBMD_SPOT_ORD_TMP1.java:492)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.runJobInTOS(TBMD_SPOT_ORD_TMP1.java:858)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.main(TBMD_SPOT_ORD_TMP1.java:717)
Caused by: java.io.IOException: CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
at java.lang.ProcessImpl.start(ProcessImpl.java:30)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
... 6 more
disconnected
=============================================================
One Star

Re: tOracleBulkExec

Hi
The tOracleBulkExec component uses sqlldr program to load a flat file for better performance.
You need to make sure two things.
No.1: Check whether there is Oracle or sqlldr installed in your local machine.
No.2: Check whether you have set Oracle environment variables for sqlldr correctly.
Regards,
Pedro
One Star

Re: tOracleBulkExec

Thanks pedro.
How can I do setting sqlldr in tOracleBulkExec component?
And how can I do mapping from input data to output table?
tOracleInput ---------------- tFileOutputDelimited (input data)
|
|
|
tOracleBulkExec (output table)
One Star

Re: tOracleBulkExec

Hi
The setting of sqlldr, in fact, is an issue about Oracle. So do you install Oracle in your local machine?
For sqlldr environment variable, you might find info from google.
Besides, I think you'd better use tOracleOutputBulk instead of tFileOutputDelimited.
Regards,
Pedro
One Star

Re: tOracleBulkExec

Oracle 10g setting
NLS_LANG : AMERICAN_AMERICA.KO16MSWIN949

How do I set up in tOraclebulkExec??
Is it right?
One Star

Re: tOracleBulkExec

Hi
In fact, this is not an issue about how to configure tOraclebulkExec.
It's an issue about SQLLDR environment variables.
Type 'SQLLDR' in cmd. If this command is recognized and you can see parameters info about 'SQLLDR', tOracleBulkExec will work fine.
If not, you need to configure SQLLDR environment variables.
Here is the URL about SQLLDR.
http://www.ordba.net/Tutorials/OracleUtilities~SQLLoader.htm
In short, make sure 'sqlldr' can run in commandline.
Regards,
Pedro

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog