tmysqlinput not fetching data properly

[bhagyarekha]

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

[manodwhb]

@bhagyarekha , can you show your job design?

[bhagyarekha]

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

[manodwhb]

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

[bhagyarekha · Accepted solution]

Hi Team

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

Thank you