Until activity succeeds even when one of the inner activity failed.

Kalidass Murugesan 96 Reputation points
2021-08-23T17:00:05.377+00:00

I have an until loop with some inner activities. Looks like the until activity is marked as succeeded even when one of the inner activity failed. It caused the rest of the activities after the until activity to be executed. Is there anything to do differently to make until activity Fail when one of the inner activity failed.

125741-image.png

125742-image.png

Update
Until activity reported failure when I updated the looping logic to end the iteration immediately upon the inner activity failure. Looks like the status of the Until activity is determined based on the status of the inner activities of the final iteration.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,997 questions
{count} votes

Accepted answer
  1. Kalidass Murugesan 96 Reputation points
    2021-08-27T22:22:20.06+00:00

    I just updated my original post.... but posting it again...

    Until activity reported failure when I updated the looping logic to end the iteration immediately upon the inner activity failure. Looks like the status of the Until activity is determined based on the status of the inner activities of the final iteration.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,456 Reputation points Microsoft Employee
    2021-08-24T06:43:33.963+00:00

    Hi @Kalidass Murugesan ,

    Welcome to Microsoft Q&A Platform. Thank you for posting query here.

    The Until activity provides the same functionality that a do-until looping structure provides in programming languages. It executes a set of activities in a loop until the condition associated with the activity evaluates to true.

    Your inner activites of Until fail or success it continues to run loop until the condition associated with the until activity evaluates to true.

    Hence, you can't make it explicity failed, but You can specify a timeout value for the until activity in Data Factory.

    By making until activity timeout u can make your pipeline execution to fail.

    Hope this will help. Please let us know if any further queries. Thank you.

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

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.
    0 comments No comments

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.