Windows Task scheduler does not write data into the MySQL db

[SGaddipati1646839785]

I have talend job that gets data from arest API and inserts into MySQL DB. WHen I run the job from Talend Studio manually, it inserts data into the db but when I run the job from command line or task scheduler, it inserts data but the db goes blank after the run is complete. Not able to understand why is this happening?

Can someone please help

[Anonymous]

You will need to give a bit more information here. Can you show the job design to start with?

[SGaddipati1646839785]

Sure..I have taken snapshots of the design and attached it in the word. When I manually run it, it completes the run and inserts data into db. After the run I get a message in red the "JSON string cannot be null" but no error on any component or error message.

[Anonymous]

Hello,

Could you please select the "Die on error" check box in the tDBOutput in your job to see if there is any error message printed on console?

Best regards

Sabrina

[Anonymous]

Are you saying that you see the data has been inserted into the database, but is then removed?

"it inserts data but the db goes blank after the run is complete"

[SGaddipati1646839785]

Yeah...When the job runs from task scheduler or cmd, I can refresh my database and see that the job is writing the data into db..but once the run is complete and I refresh the db there is no data in it.

[SGaddipati1646839785]

I selected the Die on Error checkbox and ran the job again manually. I don't get any error component shown but gets something like this displayed

[SGaddipati1646839785]

When I run manually for talend studio, the console displays like the below image, after the run. I don't get any other error message

[Anonymous]

I don't see a tDBCommit component in your job. I may have missed it. In your tDBConnection component, do you have it set to auto commit in the advanced settings?

[SGaddipati1646839785]

Yes, I have set it to Auto Commit