Skip to main content
leandrolinof
Gold ⭐️
May 31, 2022
Solved

ExecuteSQL - Failure Relationships

Good morning everyone,

 

I have a question regarding the Failure of the ExecuteSQL processor.

 

I would like to know if when accusing a failure in this processor I can give a Retry in the Processor with its own Failure.

 

Thanks

steven-matison
Platinum ⭐️⭐️
June 1, 2022

@leandrolinof I believe you are looking for a brand new nifi feature found in 1.16 which allows you to control failure and retry:

 


  • Framework Level Retry now supported.  For many years users build flows in various ways to make retries happen for a configured number of attempts.  Now this is easily and cleanly configured in the UI/API and simplifies the user experience and flow design considerably!  To those waiting for years for this thank you for your patience.

Reference: https://cwiki.apache.org/confluence/display/NIFI/Release+Notes#ReleaseNotes-Version1.16.0

 

You can find more about whats new in NiFi 1.16 in this video below. 

 

https://www.youtube.com/watch?v=8G6niPKntTc


Mark also shows a bit of the new retry mechanism around 11:50

4 replies

steven-matison
Platinum ⭐️⭐️
Platinum ⭐️⭐️
June 1, 2022

@leandrolinof I believe you are looking for a brand new nifi feature found in 1.16 which allows you to control failure and retry:

 


  • Framework Level Retry now supported.  For many years users build flows in various ways to make retries happen for a configured number of attempts.  Now this is easily and cleanly configured in the UI/API and simplifies the user experience and flow design considerably!  To those waiting for years for this thank you for your patience.

Reference: https://cwiki.apache.org/confluence/display/NIFI/Release+Notes#ReleaseNotes-Version1.16.0

 

You can find more about whats new in NiFi 1.16 in this video below. 

 

https://www.youtube.com/watch?v=8G6niPKntTc


Mark also shows a bit of the new retry mechanism around 11:50

Translate
leandrolinof
Gold ⭐️
June 1, 2022

@steven-matison This is exactly what I needed...

 

before Nifi version 1.16 this was not possible with Failure Relationships?

 

Translate
steven-matison
Platinum ⭐️⭐️
Platinum ⭐️⭐️
June 1, 2022

Yes, not available before 1.16.  Definitely a great new feature!!

Translate
leandrolinof
Gold ⭐️
June 1, 2022

@steven-matison  thank you so much.

Translate