topic Re: problem with oracle bulk loader in Talend Studio

problem with oracle bulk loader

Anonymous — Tue, 09 Dec 2014 16:37:05 GMT

Hi, I have a problem with tOracleBulkExec component. The job is very simple: just the component itself, with this configuration (see attached images for Basic, Advanced, Schema tab)
Attached:
- A 10 row sample file I want to load:
- the .ctl file created by Talend
- The "log" file from the loader
- The "bad" file from the loader

The problem seems to be on the number format (Invalid Number on the COSUMO_STD field). I tried also to change the NLS Language component setting from "Default" to "AMERICAN", but it didn't change anything.
Thanks a lot,
Andrea

POST_BULK.zip_20141209-1742.zip

Re: problem with oracle bulk loader

Anonymous — Thu, 11 Dec 2014 14:30:16 GMT

Hi everybody,
any news? I'm in big trouble and I'm in a hurry, because it is a production enviroment and I need to load a big amount of data.
I'm not able to accomplish this task because of this issue.
Thank you everybody,
Andrea

Re: problem with oracle bulk loader

Anonymous — Thu, 12 Feb 2015 08:24:55 GMT

It was a number format problem, for what I understand numbers shouldn't have more than 12 decimals to be loaded with bulk loader. If I use a java round function to limit the decimals, the bulk load works with no errors.

Re: problem with oracle bulk loader

Anonymous — Thu, 26 Feb 2015 16:03:13 GMT

Hi
I have the same problem with bulk insert and to get round it I load data in string format.
The other problem that I have is the ROWS PER COMMIT : I specified 1000000 but I have only 3 rows per commit. Could somebody help me?
Thanks a lot.
Otmane.