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

[Venkata_Sivaji1]

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.

[Anonymous · Accepted solution]

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

[Venkata_Sivaji1]

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.