fix refactor bug to commit the entire transaction

bug introduced with latest refactor around "TransactionScopeGuard":
last batch of transaction was rolled back by accident