TALEND UPDATE JOB

[ML1702493884]

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

[Anonymous]

Hi

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

[ML1702493884]

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,

[Anonymous]

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.

[TBates1683209008]

Any update?

[Anonymous]

@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.