topic Re: Restart Job in Talend Studio

Restart Job

Anonymous — Sat, 16 Nov 2024 06:52:54 GMT

Hi!

I use an Oracle database engine, I would like to know how I can manage the exceptions due to the lack of availability of the database (restarts, connection, blocking of tables, among others), since the database has failed, the work (Talend) will stop automatically, but I want it to start again automatically when the database becomes available again.
How can I do this?

Thanks!

Re: Restart Job

avinashbasetty — Thu, 10 Jan 2019 14:33:35 GMT

Hi Fred,

While using DB Components, best way is to implement using prejob and postjob. we have used prejob for DB connections on either success or failure (ex. connection may fail because of invalid credentials or network issue) and postjob for commit and close connections. These DB connections we trigger through onComponentError/onComponentOK with the global variable message error. we capture it through tWarn or tDie components by adding the connection variables.

Error Message (tDie):

"Error in Oracle Connection"+((String)globalMap.get("tDBConnection_1_ERROR_MESSAGE"))

Success Message (tWarn):

"Connection is Successful"+((String)globalMap.get("tDBConnection_1_ERROR_MESSAGE"))

Use Commit and Rollback functionality for each subjob at the output component, which helps to save the transaction only if it completes.

Additionally,

we have used Error Recovery Check point for each subjob, while helps to recover the last failed job and it will continue the process

Adding the screenshot for your reference.

DB_BestPractice.JPG

Re: Restart Job

Anonymous — Thu, 10 Jan 2019 16:01:14 GMT

Thank you!

With this, at what point would the automatic restart of the job in case of database failure?

The component that you called "Connection Failure" is a tDie?

Re: Restart Job

avinashbasetty — Tue, 05 Feb 2019 06:00:50 GMT

yes, the main intention of using tDie is to exit the JVM Immediately. see the advanced settings in a tDie component.