Forum Discussion

Mnnleus's avatar
Mnnleus
Frequent Visitor
2 years ago

Get error messages from pipeline activities

Hello,

I retrieve information on failures (name and type of activity that failed) from Logs Analytics, in the "SynapseIntegrationActivityRuns" table. I use Logs Analytics, because I have a lot of failures due to connectivity problems (SQL, PySpark, ...). In this case, my monitoring tables fed into the pipelines are not updated.


I would like to classify my errors (data error, connectivity error, other), but I can't find a way to retrieve the error details (error message) for each activity. These details exist when Irun the pipeline, since they are visible, but I don't know how to "capture" them.

I saw in a blog response that it was possible to customize the logs. In that case, how do I go about it? Or do you have another method?

 

Thank you in advance.
Have a nice day,
Mnnleus

5 Replies

    • Mnnleus's avatar
      Mnnleus
      Frequent Visitor

      Hello,
      Thank you for taking the time to answer.
      My problem is that I can't put these "capture" errors in a table if the failure is due to a connectivity problem (SQL or PySpark), because that would require using a SQL script or a notebook. That's why I wanted to use the logs.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee

        Hi Mnnleus 

         

        Apologies for the inconvenience and delay in response.

        Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

        Please go ahead and raise a support ticket to reach our support team:

        https://support.fabric.microsoft.com/support

        After creating a Support ticket please provide the ticket number as it would help us to track for more information.

         

        Thank you.