topic Re: TALEND UPDATE JOB in Talend Studio

TALEND UPDATE JOB

ML1702493884 — Fri, 15 Nov 2024 21:10:40 GMT

Hi,

I have a job that does the update to a dboutput. The job was working perfectly. Now I am facing a strange problem: the job doesn't update anymore, i rechecked everything, the data, the keys, the join... still no updates and with no errors.

I am working with Talend studio 7.3

Thank you in advance for your help

Re: TALEND UPDATE JOB

Anonymous — Thu, 14 Dec 2023 07:19:50 GMT

I will suggest you to check:

1- If the DBOutput component use an existing connection, make sure the changes have been commit using tDBCommit component.

2- Print the global variable which counts the total number of updated records to see how many records have been updated.

((Integer)globalMap.get("tDBOutput_1_NB_LINE_UPDATED"))

Regards

Shong

Re: TALEND UPDATE JOB

ML1702493884 — Thu, 14 Dec 2023 07:26:47 GMT

Hi Shong,

Thank you for your answer.

For the number of records updated, it still gives 0.

I will add the tDBCommit and run it again.

Regards,

Re: TALEND UPDATE JOB

Anonymous — Thu, 14 Dec 2023 08:34:08 GMT

the number 0 explains why you can't see the data are updated from DB side. For testing, check the 'Die on error' option on tDBOutput, the job will throw out the Java exception error if an error occurs and stop to run.

Re: TALEND UPDATE JOB

TBates1683209008 — Tue, 09 Jan 2024 05:58:43 GMT

Any update?

Re: TALEND UPDATE JOB

Anonymous — Tue, 09 Jan 2024 07:07:44 GMT

@Tyler Bates have you tried that checking the 'die on error' option on tDBOutput and see any error was throw out? the global variable shows 0 means no data was updated.