Variable Loop Condition End: Encountered duplicate row ID "Iteration 0"

[mwiegand]

Hi,

since recently I occasionally face this error with the Variable Loop Condition End node

ERROR Variable Condition Loop End 3:1126:0:1003 Execute failed: Encountered duplicate row ID "Iteration 0"

Variable Condition Loop End

The input tables do NOT have these row IDs!

That issue was raised before but never got resolved:

Variable Loop Condition Execute failed: Encountered duplicate row ID "Iteration 1"

Hello, I am doing my first experience with flow variables and loops. I was able to build a loop based on the Table to Variable Loop Start node and the Variable Condition Loop End. For some reason, I get the ERROR Variable Condition Loop End 4:1040 Execute failed: Encountered duplicate row ID “Iteration 1”. Sometimes I get this Error after the Iteration 4, 11, 20 or any other iteration. When I am taking only 3 iterations, it runs through successfully sometimes. I cant find any pattern. I…

Here is the thread dump:

240612 Variable Loop Condition End duplicate row ID Iteration 0 - Ticket 80323 - threaddump-1718186853844.tdump.txt (122.9 KB)

Update: Intriguingly, the end node has the options to add an iteration disabled. Maybe there is something wrong with that logic? The issue really only happens erratically. Resetting and starting the loop again make it execute.

Best
Mike

[k10shetty1]

Hi @mwiegand,

I attempted to replicate the issue described in the older thread but was unsuccessful. Could you please provide a sample workflow with some dummy data so I can attempt to recreate the issue?

Best,
Keerthan

[mwiegand]

The issue is not persistent and I could not identify circumstances related to it. If I do, I will follow this up.

[takbb]

This error has been cropping up for me, with no clear indication of the cause, when using the Variable Condition Loop End.

I have even tried setting rowid to a GUID. If the error message in the following screenshot is actually correct, then perhaps I should purchase a lottery ticket because it is incredibly statistically unlikely to be the case

[mwiegand]

You certainly should have played the lottery @takbb