fix refactor bug to commit the entire transaction

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