Thanks Matt for the explanation and clarification. I appreciate that. Regards, Uwe
> Am 21.10.2024 um 19:38 schrieb Matt Burgess <mattyb...@apache.org>: > > 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 >>
