Hi all,
This is my first post so I apologize if this is posted in the wrong place :S.
I've created a set of jobs that first Insert or Update if duplicate PK on a table and then,
after intermediate jobs
, another job, that UPDATE this same table.
The table created is then used for reporting purposes. At the point, everything looks OK.
However, since the beginning of the process, customers have told me there are some columns for some registers that sometimes are not updated.
To put you an example: Every end of month, the business updates the status on a 100 projects they run. This update status is then uploaded in the database with the process explained above, but some of those projects (around 10%) have some columns not updated (even though the data in the source is correctly captured by Talend...but not updated). It becomes stranger when, after finding that columns are not updated, I run the jobs again (without any modification in the code or the data) and then, the columns are correctly updated.
I find this very strange and honestly I do not know if this is a MySQL update issue, a Talend issue, a server where jobs are store issue....I do not know if you have any ideas.
Thank you!
Marc
