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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bcdobbs
Super User
Super User

Email on Error in Pipeline

I've built a pipeline that runs two notebooks and I'm wanting it to email on failure.

It looks like:

bcdobbs_0-1701769113553.png

With the Send Error Email connected on the fail nodes.

However it never triggers the outlook task:

bcdobbs_1-1701769174851.png

 

bcdobbs_2-1701769205113.png

Any suggestion on what I'm doing wrong or is there a better way to handle this?

 

Thanks

 

Ben



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 ACCEPTED SOLUTION

Yes @NandanHegde got it.

vgchennamsft_0-1701787396795.png


It looks like we don't have any issue with data factory, it is considered as a AND operator, not a OR operator.

@bcdobbs  I was able to trigger an email by creating a pipeline design like above.

View solution in original post

7 REPLIES 7
NandanHegde
Solution Sage
Solution Sage

Hey,

You right fully identified the cause that the email would be triggered only if both the notebook activities would fail as the expressions are AND scenario and that would never occur as the 2nd notebook would be trigerred only with the success of the 1st one.

 

So as a solution, you can have seperate notifications per activity but there is only a limitaion of 40 activities per pipeline.

So below blog though ADF related would have the same concpets for Fabric:

https://datasharkx.wordpress.com/2021/08/19/error-logging-and-the-art-of-avoiding-redundant-activiti...

which would be a cleaner way

Yes @NandanHegde got it.

vgchennamsft_0-1701787396795.png


It looks like we don't have any issue with data factory, it is considered as a AND operator, not a OR operator.

@bcdobbs  I was able to trigger an email by creating a pipeline design like above.

Hi @bcdobbs ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered. Otherwise, will respond back with the more details and we will try to help .

Hi @bcdobbs ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered. Otherwise, will respond back with the more details and we will try to help .

hey @bcdobbs 

Are there any queries w.r.t creating a flow within the pipelines ?

v-gchenna-msft
Community Support
Community Support

Hi @bcdobbs ,

Thanks for using Fabric Community.

As I tried to repro your scenario I have noticed this.

Case 1: Every thing worked well

vgchennamsft_2-1701771532862.png



Case 2: I can find the same issue you are facing

vgchennamsft_3-1701771666679.png

For time being try to link to only one Notebook Activity on failure.

In meantime I will check with internal to get some information on this behaviour.

Thank you

 

 

bcdobbs
Super User
Super User

Having looked at the JSON for the pipeline I now realise the way I'd built it would only trigger an error if both notebooks failed which couldn't happen in that setup.

I've added separate notification blocks and it now works.

bcdobbs_0-1701770214536.png

Is there however a cleaner way of doing this? Eg trigger an email on any failure anywhere in the pipeline?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.