Data flow Output metric Status as substatus instead of runstatus resulting error while capturing metrics for status using runstatus column for logging

Question

Getting Status as Substatus instead of runstatus for DataFlow in Azure data factory, We are using this column to log the status of the pipelines for all data flows & pipelines, Few pipelines are getting failed for the same and getting fixed automatically for next run.

Failure message: The expression 'String(if(contains(activity('ADFPL__df').output.runStatus.metrics,'MapInsert'),if(contains(activity('ADFPL_df').output.runStatus.metrics.MapInsert.sources,'SourceStage'),activity('ADFPL_df').output.runStatus.metrics.MapInsert.sources.SourceStage.rowsRead,0),0))' cannot be evaluated because property 'runStatus' doesn't exist, available properties are 'SubStatus, ComputeAcquisitionDuration, RecordTimestamp, MetricsPayload, effectiveIntegrationRuntime, executionDuration, durationInQueue'.

Answer 1

Hi Hanuman Devineni ,

Thankyou for using Microsoft Q&A platform and thanks for raising your query here.

This issue is an old issue which has resurfaced again due to outage in few regions. Backend service was restarted in impacted regions . As per the latest update from the team , the issue has been mitigated now and 'runstatus' should be coming as the output property.

Could you please retry now from your end and see if it is working or the error still persists.

Thankyou