I develop some jobs with Talend, and use Tlogcatcher to record errors on a database. It seems working for all jobs except one.
Here is how it work :
The first SQL connection read SQL statement from a database table, and for each of them, the tMSSqlRow read and execute it.
But when SQL failed (i.e delete not possible cause of constraint integrity), the error is not catch by the tLogCatcher component.
How I can do that ?
Thanks in advance.
The error should be a Java exception and it is thrown out on txxxRow, otherwise tLogCatcher can not capture them. What are the error message? Can you upload the full track messages?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema