Unanswered

Do until action doesn't stop running when the error happens in action inside do until action

(0) Share

Report

Posted on by Sammy Salo

Have anybody noticed same, if for example execute sql action fails due syntax error, do until action does not stop and keep running until canceling run manually ?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

carloxvii 95 on at

Like (0)

Report
Copy link

Link copied!

Hi there @SammyS

Try to add a configuration after an action fails,

Here is a sample flow:

The Status variable will be set to false if the action fails.

To Configure it:

Then check this one:

I think this will stop the process from looping.

Also you can add condition after that to cancel the flow because we can't use terminate inside do until.

Was this reply helpful? Yes No
Sammy Salo 4 on at

Like (1)

Report
Copy link

Link copied!

Thanks @carloxvii for good pointers.
I tried to add Terminate action inside loop but Your samle opens my eyes how to do it.

I'll try that and got also idea how to add SQL Begin Tran Commit Rollback sequence that shouldn't interrupt on those For each inside Do until loops.

Was this reply helpful? Yes No