topic No error in job processing but data is not loading to Mysql database in Talend Studio

No error in job processing but data is not loading to Mysql database

Venkata_Sivaji1 — Sat, 16 Nov 2024 03:14:32 GMT

Team,

I have a job as attached.When i run the job no warnings came and job also processing records but when i checked in mysql db no records inserted and i have mysql commit as well .What could be the reason.Can some one help me on this .Proper output is writing into tlogrow.

Re: No error in job processing but data is not loading to Mysql database

Anonymous — Tue, 18 Feb 2020 03:16:03 GMT

Hi
It is a design issue, you should commit the changes in next subjob, eg:
tFileInputXML....
|onsubjobok
tMysqlCommit.

BTW, please insert images into your post body instead of attaching it.

Regards
Shong

Re: No error in job processing but data is not loading to Mysql database

Venkata_Sivaji1 — Tue, 18 Feb 2020 05:33:57 GMT

Thanks!. But i have couple of jobs like the model i provided and those and all running without any issues to load the data.

Anyway i will try the solution provided and let you know the progress.