topic Re: tInputDelimited file is not exporting properly all rows to MySQL DB in Talend Studio

tInputDelimited file is not exporting properly all rows to MySQL DB

cemonteverde — Fri, 15 Nov 2024 22:33:22 GMT

Hello, I have the following issue...I have my tInputDelimited component which is exporting 82100 rows to MySQL DB component, it seems that everything is okay, but when I look up in my DB there are only 82000 rows, there are missing 100 rows. Could it be an issue regarding MySQL component?

Also I tried to get an output in a tOutputDelimited file next to the DB component and for that it works. So I think that maybe the issue is in the DB.

Re: tInputDelimited file is not exporting properly all rows to MySQL DB

Anonymous — Wed, 14 Sep 2022 11:06:40 GMT

Can you show us a screenshot of your job and also a screenshot of your MySQL component (the settings) used to insert the data?

Re: tInputDelimited file is not exporting properly all rows to MySQL DB

Anonymous — Thu, 15 Sep 2022 02:58:01 GMT

Hello,

Could you please try to capture rejected records from tMysqlOutput manually to see if these 100 rows are rejected by your MySql DB?

Best regards

Sabrina