Azure Data factory pipeline activities error

Question

Hi,

Anyone can suggest, how to get/catch exact error message in azure data factory pipeline activity and send email.

Thanks
JR

Answer 1

I can see 2 problem statements here,

1. Get/catch exact error message:
   This can be resolved by following below steps:

• Define a pipeline variable
• Add 'Set variable' activity to your pipeline
• Pipe your existing activity failure head to the 'Set variable' activity.
• In Set variable activity use @activity('YourPrimaryAtivity').Error.Message
• Now your error message is captured in a variable which can be further passed to any data stores like SQL database, blob storage.

2. Send Email.
   This can be resolved by following below steps:
   • Set up an event trigger on your data store where you are logging error and create alerts from Azure monitor.

Answer 2

Hi @Anonymous

In addition to the above answer,

You can refer to this video for capturing error message and sending mail via logic apps

Hope it helps.

Thanks