topic Re: Windows Task scheduler does not write data into the MySQL db in Talend Studio

Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Fri, 15 Nov 2024 23:08:26 GMT

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

Re: Windows Task scheduler does not write data into the MySQL db

Anonymous — Wed, 09 Mar 2022 23:25:51 GMT

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

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Thu, 10 Mar 2022 01:10:09 GMT

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.

Re: Windows Task scheduler does not write data into the MySQL db

Anonymous — Thu, 10 Mar 2022 04:02:26 GMT

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

Re: Windows Task scheduler does not write data into the MySQL db

Anonymous — Thu, 10 Mar 2022 11:01:21 GMT

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"

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Thu, 10 Mar 2022 16:20:46 GMT

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.

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Thu, 10 Mar 2022 18:31:00 GMT

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

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Thu, 10 Mar 2022 18:32:28 GMT

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

Re: Windows Task scheduler does not write data into the MySQL db

Anonymous — Thu, 10 Mar 2022 18:51:40 GMT

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?

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Thu, 10 Mar 2022 18:54:16 GMT

Yes, I have set it to Auto Commit

Re: Windows Task scheduler does not write data into the MySQL db

Anonymous — Fri, 11 Mar 2022 15:01:27 GMT

Do you have any deletes in this job? If not, I cannot understand why this would be happening. Unless when you run this on the command line, there are other things that are part of that command line run. Maybe another job that runs afterwards?

If data is written to a DB so that you can see it in the DB, unless there is a deletion taking place, the data will remain there.

Re: Windows Task scheduler does not write data into the MySQL db

SGaddipati1646839785 — Tue, 15 Mar 2022 14:39:06 GMT

Could you elaborate what other things can be part of the command line...