ExecuteSQL - Failure Relationships

[#1]

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

[#2 · Accepted solution]

@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

[#3]

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

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

[#4]

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

[#5]

@steven-matison  thank you so much.