How to abort iteration if something fails in ADF

Question

Hi Team,

I am running a process using a foreach activity, designed such that if the first iteration fails, it should abort and not proceed to the second iteration. However, this is not working as expected in my case. Could someone please assist me?

Please refer to the screenshot below.

In the screenshot, the first iteration failed. I added a fail activity to abort the process, but it still proceeded to the second iteration.

How can I resolve this issue?

Answer 1

In case of ADF, the For each activity would complete all iterations irrespective of failure in intermediate iteration.

There are 2 ways how you can abort :

1. use web activity to cancel the pipeline run in case if you want to abort post failure in any iteration
2. Have a log table wherein you flag whether the iteration is a success/failure. At the start of foreach, have a lookup activity to chcek whether the prev iteration is success, then proceed else skip