Restartability, recovery checkpoints and restart the job from the failed point

[AAA999]

Gurus, I need you inputs for the restartability process.

I have created 2 jobs for restartabilty test from the failed point. 

I followed the steps mentioned in Talend manual using both Studio and TAC but looks like there is something i am missing.

Process:

 Loading data from same source table to different target tables.

The job is failing when loading the data into the target table "address_test_2".

Re-running the job using TAC (ERROR RECOVERY MANAGEMENT) and clicking on Launch Recovery from the failed points, but the process starts loading Table 1 again and not from the point where it failed. (It should only load table2 as table1 has already been loaded)

I have attached the files for reference purpose.

Thanks

[manodwhb]

@AAA999 ,please check the below link about restart ability. have you implement the same way?

https://help.talend.com/reader/pzEsR9WAQlQkz4tFLp6TpA/omFXPdTqrImC7U0HX5iVVQ

[AAA999]

Manohar,

I implemented the same scenario but the issue is I don't want to the process to start from the first flow but from the second flow where loads data in Address_Test_1. Since Address_Test has already been loaded. Is this achievable in the same job? If not could you let me know the process?

Thanks 

[Anonymous]

You should be able to achieve this using the built-in Talend functionality. The way to do this would be to have each step in your process contained in a separate job. Let's say you load the data into a staging area first. Then you perform some filtering in another job. Then you carry out some transformation in another job. You then push the fully transformed data to your final table. That is 4 jobs. Each job would have a different DB table. Now if you have a main job which contains all 4 jobs running in sequence, you can use the built-in Talend functionality. If the first job runs successfully, but the second fails, your data will be in the table which receives the data at the end of the first job, so when the main job is re-run, it will pick up from the second inner job using the data that has been loaded into its source table. 

[AAA999]

Rhall, I did followed the steps as mentioned in the description by creating separate jobs and running them through the main job. I am stilling having the same issue. If I re-run the job it starts from the beginning and not from the failed point which is test_load_1. I am running them in sequence both through Tac and Studio. trunjob2 and 3 have same settings as 1. Attached is the job design.

Thanks

trunjob1_settings.JPG

[Anonymous · Accepted solution]

Are you trying this through the TAC? You need to follow the instructions here: https://help.talend.com/reader/pzEsR9WAQlQkz4tFLp6TpA/EkBQdeJjs8uqzWMpthrMNg

[AAA999]

Rhall,

Thank you for all your inputs. The job is executing as required.

Thanks

[Anonymous]

Glad you got it sorted 🙂