topic Re: tFileInputDelimited reads 0 rows from large file in Talend Studio

tFileInputDelimited reads 0 rows from large file

_AnonymousUser — Tue, 15 Sep 2015 09:51:08 GMT

Hi all,

I am having an issue recently for a series of ETL jobs I have been running for monthly files in my company.
I have generated 6 jobs which for the past months were executed successfully for monthly files of data.

For the last monthly files although I executed all jobs and suddenly the tFileInputDelimited component feeds 0 rows to tMap in all my jobs for very large files (from 25k rows to 900k rows).
This is strange because files(format,delimiter) has not changed neither has the Talend job from previous month execution.

Everything runs fine, no errors or exceptions just that the component reads 0 rows for all Talend jobs and for all different files.

Can anyone help on this?

Thank you in advance.

Re: tFileInputDelimited reads 0 rows from large file

_AnonymousUser — Tue, 15 Sep 2015 10:22:46 GMT

Mystery solved...

It was the encoding in the advanced settings. Files were the same, but with different encoding this time.

Lesson learned! 🙂

Re: tFileInputDelimited reads 0 rows from large file

Anonymous — Fri, 18 Sep 2015 10:57:10 GMT

Hi,

Thanks for posting that you resolved it by yourself. Feel free to let us know if there is any help we can give.

Best regards
Sabrina