On fail task not triggering

[dzav]

I've got a pipeline with multiple tasks (Data flows, invoke pipeline, notbook, etc) that all connect to an Office 365 Outlook task via an "on fail" connection so that I get an e-mail notification if any of these tasks fail. However, I noticed that this doesn't trigger on failure. With some testing, I realized that this only triggers if only one task is connected and fails. If multiple tasks are connected, they all need to trigger and fail. So, to correct this, I'd need to create an Office 365 Outlook task for each step.

What am I missing? Is that how pipeline on fail connections work in Synapse and ADF pipelines, too? If this is intended behavior, this seems illogical.

[dzav]

It sounds like the best solution for me would be to create a pipeline that runs this pipeline so that only one task ends up failing. Silly, but without robust alerting this is already a workaround.

[frithjof_v · Accepted solution]

Related threads:

https://community.fabric.microsoft.com/t5/Data-Pipelines/Email-on-Error-in-Pipeline/m-p/3568087

https://community.fabric.microsoft.com/t5/Data-Pipelines/How-to-send-failure-email-in-pipeline-witho...

https://community.fabric.microsoft.com/t5/Data-Pipelines/Notifications-on-pipeline-error/m-p/3735975