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