Commit fails silently - no resolution

kakins-tamus · January 30, 2018 9:33PM

I have several objects selected for committing. I click the button and it moves through the next screen quickly, only to return to the original "Commit" screen with my objects not committed.

Something to note is that all the objects are tables, and the changes to the tables are removing an "ALTER INDEX" statement from the script:

Mike U · January 31, 2018 8:16AM

Can I ask which version of SQL Source Control you're using? There were some fixes in version 6.0.0 around handling DISABLEd indexes (issues SC-9520 and SOC-8863: https://documentation.red-gate.com/soc6/release-notes-and-other-versions/sql-source-control-6-0-release-notes)

kakins-tamus · January 31, 2018 3:42PM

I am using version 6.0.8.7147.

Mike U · February 1, 2018 8:54AM

I've reproduced the issue here, and recorded a bug with reference SOC-9337.

There is a workaround you can use though - if you delete the relevant `ALTER INDEX ... DISABLE` lines from the files in your version control system, commit the change (using the version control system's interface), and then do a Get Latest, the difference should disappear. Exactly how you do this depends on which version control system integration you're using - if you need help with that, can you tell me which system you're using and I'll give you more specific instructions.

Commit fails silently - no resolution

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk