If there is no inbound connection then there will be no FlowFile routed to failure, so you'd have to use GenerateFlowFile upstream to get an output FlowFile. It is odd that a timeout exception is not a SQLTransientException, IMO it should be routed to retry not failure but that's for PostgreSQL to specify.
Regards, Matt On Sun, Oct 20, 2024 at 6:43 AM u...@moosheimer.com <u...@moosheimer.com> wrote: > Dear NiFi experts, > > I use NiFi 1.26 and in my flow I use (a lot of) ExecuteSQL, which are > started via cron. > > If a timeout error occurs, then I get the bulletin > “*No FlowFile to route to failure*: org.postgresql.util.PSQLException: > ERROR: canceling statement due to statement timeout”. > > And unfortunately no FlowFile is routed to failure. > > Didn't this problem exist many years ago? > Unfortunately, I can't remember how it was solved. Is it better to use > GenerateFlowFile instead of Cron? > Or is the error possibly back again? > Or am I missing something completely different? > > Couldn't find anything in the docs either. Maybe someone can tell me > what the best way is? > > Thanks! > Uwe >
