Azure Log analytics - adfpipeline fields error code erromessage are empty for failed pipelines

Question

I have enabled pipeline run log in default log analytics workspace. other fields are populating but ErrorCode and ErrorMessage fields of ADFPipeline table are empty even for Failed pipelines.

Could you please guide how to enable capturing error message in ADFPipelineRun log analytics table. Thanks!

Answer 1

Hi @Gehlot, Jitendra ,

Thank you for posting query in Microsoft Q&A Platform.

You are right, on ADFPipelinerun table you see ErrorCode & ErrorMessage Columns as empty. You need to consider using ADFActivityRun table. In ADFActivityRun table you will get data under ErrorCode & ErrorMessage Columns.

Technically, Pipeline failed means, failure happens on any one of the activities inside pipeline. Hence in ADActivityRun table you will see the ErrorCode and ErrorMessage details.

Please check below screenshot.

Hope this helps. Please let me know if any further queries.

----------------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Answer 2

ADFActivityRun
| where Status != 'InProgress' and Status != 'Queued'
| where TimeGenerated >= ago(24h)
| order by TimeGenerated desc

I still get nothing