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
=============================================================
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
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)
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
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
