question Re: ExecuteSQL - Failure Relationships in Support Questions

ExecuteSQL - Failure Relationships

leandrolinof — Tue, 31 May 2022 15:51:59 GMT

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

Re: ExecuteSQL - Failure Relationships

steven-matison — Wed, 01 Jun 2022 14:48:42 GMT

@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

Re: ExecuteSQL - Failure Relationships

leandrolinof — Wed, 01 Jun 2022 17:10:44 GMT

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

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

Re: ExecuteSQL - Failure Relationships

steven-matison — Wed, 01 Jun 2022 17:17:39 GMT

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

Re: ExecuteSQL - Failure Relationships

leandrolinof — Wed, 01 Jun 2022 17:59:21 GMT

@steven-matison thank you so much.