We have many talend jobs, connecting to external SQL server databases. I would like to know if there is any option in Talend to ignore the connection errors like (
java.sql.SQLException:Network error IOException: Connection timed out: connect
java.sql.SQLExceptionession Provider: Physical connection is not usable [xFFFFFFFF]
We run many jobs in parallel and If any of tMSSQLINPUT component failed for connection error, all other jobs failed.
It is very important for us, to get the other jobs continue running.
When you say you run many jobs in parallel, do you mean that you run many tRunJob components in parallel? If so, just untick Die on Child Error in the tRunJob
You'll need to implement some kind of off-premise DB connection, using a tJavaFlex, whereby you can code in a try...catch to catch the error and re-run/re-process whatever was being run at the time. You might also need to put in some recovery logic so you dont have to start back at the beginning again.
Thank you for reply, I tried unticking tDie on Error option before but it is not solving all scenarios on design. I have many jobs have multiple sources in the same Talend job; handled using tMSSQLINPUT. is there any Die on error option or any similar option on this component?
Thank you for the reply, actually I don;t want anything except continue running the same process (same jobs and all jobs after). Sometimes the source ca be disconnected for days, I don;t want to rerun the job (Just ignore the error and continue running). Next schedule running, if all servers are connected successfully then all missing data from last executions will be loaded.
Attached is a sample of my job.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables