Why does the For Each Result block go directly to the end of the block ("repeat"), skipping the remaining blocks, when an error occurs?
My native query returns a list of invoices. The For Each Result block processes each line item on the invoice. If the invoice isn't found at the destination, a Create block is used. If the invoice is found, an Update/Insert block is used.
At the bottom of the For Each Result block, I check to see if there was an error either in the Create or the Update/Insert blocks, and if there was, set the BoolVariable to true and I don't update the source record as being imported.
What is happening, though, is that if I get an error inside the Update/Insert block, rather than continuing on to the next block, the process goes directly to the end of the For Each Result block, so I'm unable to check if there was an error.