Iterative Macro does not stop iterating
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everybody! I'm having a very weird issue:
I'm testing the workflows i just moved onto another computer to see if all files are pointing at the right place (both for macros and for output).
Once everything is good to let the computer process the whole dataset, I test a few records to see if it works fine, but the iteration won't stop going on even when all the data is processed.
In the picture below you can see that the 9 iterations I wanted were processed and saved into an xlsx file, but then the machine keeps iterating and i cannot explain what's the reason for that (note that this workflow has been used for months and not a single time this weird error occurred). Moreover, I have to stop it manually or it keeps iterating until i don't know, which is strange since once the 9 records are processed the workflow should stop by itself.
The error shown below is caused by a multi-row formula, which of course does not work since no data is fed into the process.
Do you have any ideas of what's going on and how to fix this?
- Labels:
- Iterative Macro
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @iegg ,
The stop conditions of Iterative Macro are once the loop output is empty or the maximum number of iterations is reached.
If you use the stop condition of once the loop output is empty, I think that you can set the maximum number to solve this problem.
Or it is helpful to watch the output of the loop output. If you want to watch it, you need to add the Iteration Number field by using formula tool with [Engine.IterationNumber] and to connect the Output Data tool before the macro output of the loop output.
