topic tmysqlinput not fetching data properly in Talend Studio

tmysqlinput not fetching data properly

bhagyarekha — Tue, 07 May 2019 13:25:46 GMT

Hi Team,

i have one urgent requirement,

i already developed job it was working fine,now the problem from two days is am not getting proper result from my job.

i have tmysqlinput to fetch data from database and need to process to other components,

i have written one select query it is showing correct number of records in mysql workbench and copied same query into talend on mysqlinput,it is showing only some records(not showing recent records which are inserted) but totally number of records showing in workbench

Appreciate quick reply

regards

rekha

Re: tmysqlinput not fetching data properly

manodwhb — Tue, 07 May 2019 14:20:21 GMT

@bhagyarekha , can you show your job design?

Re: tmysqlinput not fetching data properly

bhagyarekha — Wed, 08 May 2019 06:07:32 GMT

Hi please find below screen shots

Note

with using trim and without using trim am getting same number of records in talend

Regards

bhagyarekha

Capture2.JPG
Capture.JPG

Re: tmysqlinput not fetching data properly

manodwhb — Wed, 08 May 2019 06:36:01 GMT

@bhagyarekha ,can you try to write to tLogrow ? and check the data that how many records fetched and writes to tLogRow?

Re: tmysqlinput not fetching data properly

bhagyarekha — Wed, 08 May 2019 06:37:28 GMT

Hi Team

got the solution ,mistake is our side only,database was different.

Thank you