Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

Reply
lsabetta
Frequent Visitor

Pipeline doesn't execute On Error

Hi community,

 

My pipeline is not running the notebook that has to run in case one of my activities fail. It stops just after the activity that has failed. I don't know if it is related but all the 3 notebooks run within the same Session Tag
Does anyone know why?

lsabetta_0-1759761312533.png

 

1 ACCEPTED SOLUTION
smeetsh
Continued Contributor
Continued Contributor

Sadly the "on fail"  is an AND and not an OR. In your case the notebook will only trigger if all parent activities fail and not just one of them.

 

This means you will have to create a notebook for each fail activity, which is indeed a pain if you have many activities in one pipeline. We created something similar, but with using the outlook activity to send an email if a specific step fails.

 

I have looked at using a notebook to just look at the whole pipeline and alert if the pipeline itself fails, but there are 2 downsides to that.

1: It won't give any detail, but the alert would tell you to go look at the log, since something is wrong

2: I would need to set  up an api-key etc, which I haven't done yet, and it would create more admin work

 

Hopefully this is of use to you.

 

Cheers

Hans

(If my answer is helpful give it a kudo and/or mark it as a solution)

Cheers

Hans

(If my solution was usefull, please give it a kudo, and mark it as a solution)

View solution in original post

3 REPLIES 3
smeetsh
Continued Contributor
Continued Contributor

Sadly the "on fail"  is an AND and not an OR. In your case the notebook will only trigger if all parent activities fail and not just one of them.

 

This means you will have to create a notebook for each fail activity, which is indeed a pain if you have many activities in one pipeline. We created something similar, but with using the outlook activity to send an email if a specific step fails.

 

I have looked at using a notebook to just look at the whole pipeline and alert if the pipeline itself fails, but there are 2 downsides to that.

1: It won't give any detail, but the alert would tell you to go look at the log, since something is wrong

2: I would need to set  up an api-key etc, which I haven't done yet, and it would create more admin work

 

Hopefully this is of use to you.

 

Cheers

Hans

(If my answer is helpful give it a kudo and/or mark it as a solution)

Cheers

Hans

(If my solution was usefull, please give it a kudo, and mark it as a solution)
tayloramy
Super User
Super User

Hi @lsabetta

 

The connections in a pipeline are treated as AND connections, so your nb_finish_error won't run unless all 4 other activities fail. 

So the behaviour you're seeing is expected. 

 

To have OR logic, you will need to use variables and build some custom logic. 

 

 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.





If you found this helpful, consider giving some Kudos.
If I answered your question or solved your problem, mark this post as the solution!

Join the Fabric Discord!

Proud to be a Super User!





apturlov
Super User
Super User

@lsabetta could you provide the output from a failed activity? It's also not obvious from your screenshot which activity actually failed.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.