ADF : How to pass child pipeline failure status to master pipeline

Vindhya Sree Dharanikota 25 Reputation points
2023-04-20T15:21:34.5833333+00:00

Hi,
My parent pipeline is calling multiple child pipelines designed to run sequentially, like child1 will call child 2 on completion not necessarily successful so on so forth , so whenever one of the child execution is failed am expecting parent sequence status should be failed which is not the case always, parent sequence is sometimes getting a success status and sometime a failed status. Expectation : Assuming 3 child pipelines, case 1 : When Cild1 and Child 2 and Child3 pipelines are successful parent pipeline should be successful case2 : when Child1 or Child2 or Child 3 are failed Parent pipeline should be failed. Pl suggest if there is any possible setting in pipeline without adding a set variable and tracking status of each child pipeline to handle the situation as I do have multiple sequences where this fix is required with each parent pipeline having 10+ child pipelines. PFB screenshot : Note : All child pipelines are linked on completion as no dependency across pipelines but need to be scheduled to run one after other to balance the load on the cluster User's image

Thanks,
Vindhya

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2023-04-24T06:29:07.5166667+00:00

    Hi Vindhya Sree Dharanikota , Welcome to Microsoft Q&A platform and thanks for posting your questions here. As I understand your requirement is that the master pipeline should fail in case the activity in any of the child pipelines is failing , however, it's not happening for you. Please let me know if that is not the correct understanding.

    Kindly make sure that there is no error handling done in the child pipeline. If any activity is failing and there is an 'On Failure' conditional path attached to other activity , then it will render the pipeline to succeed. To avoid that, kindly ensure there is no try catch mechanism in the child pipelines.

    1. Child pipeline would fail leading to master pipeline failure as well if there is no activity attached to on failure case: PipelineFail
    2. Child pipeline would succeed leading to master pipeline success as well if there is an activity attached to on failure case: PipelineSuccess

    For more details kindly check Common error handling mechanism Hope it helps. Kindly accept the answer if it's helpful. Thankyou


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.