Rollbacks Are Not Complete Rollbacks
erodriguez
Posts: 10
I've been trying to pull down the latest from a SC 3 protected database and repository.
There's over 1400 items for me to grab. Not a problem, except a few had errors generated that were related to some invalid orphaned users and roles. No problem there either.
My problem comes when I attempt to roll back the items that were already applied once the error was thrown. My understanding was the check-ins are transaction based, and that an error on getting latest would not cause any items to be created. And the rollback is not a complete one. There are a group of database roles and users that are still showing after the rollback, and schemas edited to include some of these new roles and users.
What's more, the get latest window shows fewer objects to be pulled, which tells me that they in fact DO exist in my database. And I can't "undo changes" because they dont show as commits in the commit window. They are just "there".
Why does this still occur? What do I have to do to get the database fully rolled back?
There's over 1400 items for me to grab. Not a problem, except a few had errors generated that were related to some invalid orphaned users and roles. No problem there either.
My problem comes when I attempt to roll back the items that were already applied once the error was thrown. My understanding was the check-ins are transaction based, and that an error on getting latest would not cause any items to be created. And the rollback is not a complete one. There are a group of database roles and users that are still showing after the rollback, and schemas edited to include some of these new roles and users.
What's more, the get latest window shows fewer objects to be pulled, which tells me that they in fact DO exist in my database. And I can't "undo changes" because they dont show as commits in the commit window. They are just "there".
Why does this still occur? What do I have to do to get the database fully rolled back?
Comments
You can see that the GET operation fails, but there are 3 new users that are created even though the GET failed and there are no COMMIT actions to roll back.
http://screencast.com/t/ruVcrC8ozHGE
Thanks for your inquiry!
I have opened a ticket for this situation, and will contact you through the ticket to troubleshoot this issue further.
Thanks for your time!
Rick
Technical Support
Red Gate Software Ltd.