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
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
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.
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.