SQL Compare "2 conflicts prevent checkout"
PatrickChasco
Posts: 3 Bronze 1
in SQL Compare
When attempting to generate scripts using SQL Compare it hangs for a few minutes at "Generating SQL" then bombs with the error "2 conflicts prevent checkout."
The first obvious issue is that SQL Compare is not reporting which things are in conflict, so I cannot resolve the issue.
The next is that the exception message is being thrown from LibGit2Sharp. We are not using the git backend. We're using Team Foundation Version Control.
Below is the exception message. I tried to use code tags, but they don't seem to work on this site. I'm seeing a pattern emerge...
-- Exception --
at LibGit2Sharp.Core.Ensure.HandleError(Int32 result) at LibGit2Sharp.Core.Proxy.git_checkout_tree(RepositoryHandle repo, ObjectId treeId, GitCheckoutOpts& opts) at LibGit2Sharp.Repository.CheckoutTree(Tree tree, IList`1 paths, IConvertableToGitCheckoutOpts opts) at LibGit2Sharp.Commands.Checkout(IRepository repository, Tree tree, CheckoutOptions checkoutOptions, String refLogHeadSpec) at LibGit2Sharp.Commands.Checkout(IRepository repository, String committishOrBranchSpec, CheckoutOptions options) at RedGate.Database.Helpers.PartialSchemas.GitRepository.Checkout(CommitRef commitRef) at RedGate.Database.Migrations.Synchronizer.Deployment.SourceAndTargetRetriever.RetrieveSource() at RedGate.Database.Migrations.Synchronizer.Deployment.Compare.CompareEnginePlanGenerator.Generate(IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeployableBlock.Generate(ISourceAndTargetRetriever statePairRetriever, IStagedDeploymentSqlGenerator stagedDeploymentSqlGenerator, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeploymentPlanGenerator.GenerateDeploymentPlans(BlockHistoryBuilder blockHistoryBuilder, IEnumerable`1 blocksToDeploy, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.Planner.GenerateOrderedDeploymentPlans(IScriptsFolder sourceScriptsFolder, IScriptsFolder targetDatabase, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeploymentScriptGenerator.GenerateDeploymentScript(IScriptsFolder sourceScriptsFolder, IScriptsFolder targetScriptsFolder, IDifferenceFilterer differenceFilterer) at RedGate.SQLToolsUI.MigrationBlocks.MigrationBlocksEngineWrapper.BuildDeploymentScript(IDirectoryInfoWrapper sourceFolder, Database targetDatabase, DeploymentOptions deploymentOptions, Differences differences, IDataSource databaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.GenerateMigrationDeploymentScript(Project project, String transactionIsolationLevel, Database sourceDatabase, Database targetDatabase, Differences differences, IDataSource databaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.CreateSqlFromDependencies(Database sourceDatabase, Database targetDatabase, Project project, Differences differences, String transactionIsolationLevel, IEnumerable`1 comparisonWarnings, IWork work, IDataSource targetDatabaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.<>c__DisplayClass4_1.b__1() at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Mappings.ViewModel.StatusEventArgsHandler.d__1`2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentGenerator.d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Model.Sync.SchemaSynchronizationState.<>c__DisplayClass44_0.<b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at FurHelper.FurUtils.d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Model.Sync.SchemaSynchronizationState.d__44.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__160.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__152.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__152.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizard.d__13.MoveNext()" Method="LibGit2Sharp.Core.Ensure.HandleError(Int32 result) (also happens if trying to link db to TFVS and doing get latest)
The first obvious issue is that SQL Compare is not reporting which things are in conflict, so I cannot resolve the issue.
The next is that the exception message is being thrown from LibGit2Sharp. We are not using the git backend. We're using Team Foundation Version Control.
Below is the exception message. I tried to use code tags, but they don't seem to work on this site. I'm seeing a pattern emerge...
-- Exception --
at LibGit2Sharp.Core.Ensure.HandleError(Int32 result) at LibGit2Sharp.Core.Proxy.git_checkout_tree(RepositoryHandle repo, ObjectId treeId, GitCheckoutOpts& opts) at LibGit2Sharp.Repository.CheckoutTree(Tree tree, IList`1 paths, IConvertableToGitCheckoutOpts opts) at LibGit2Sharp.Commands.Checkout(IRepository repository, Tree tree, CheckoutOptions checkoutOptions, String refLogHeadSpec) at LibGit2Sharp.Commands.Checkout(IRepository repository, String committishOrBranchSpec, CheckoutOptions options) at RedGate.Database.Helpers.PartialSchemas.GitRepository.Checkout(CommitRef commitRef) at RedGate.Database.Migrations.Synchronizer.Deployment.SourceAndTargetRetriever.RetrieveSource() at RedGate.Database.Migrations.Synchronizer.Deployment.Compare.CompareEnginePlanGenerator.Generate(IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeployableBlock.Generate(ISourceAndTargetRetriever statePairRetriever, IStagedDeploymentSqlGenerator stagedDeploymentSqlGenerator, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeploymentPlanGenerator.GenerateDeploymentPlans(BlockHistoryBuilder blockHistoryBuilder, IEnumerable`1 blocksToDeploy, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.Planner.GenerateOrderedDeploymentPlans(IScriptsFolder sourceScriptsFolder, IScriptsFolder targetDatabase, IDifferenceFilterer differenceFilterer) at RedGate.Database.Migrations.Synchronizer.Deployment.DeploymentScriptGenerator.GenerateDeploymentScript(IScriptsFolder sourceScriptsFolder, IScriptsFolder targetScriptsFolder, IDifferenceFilterer differenceFilterer) at RedGate.SQLToolsUI.MigrationBlocks.MigrationBlocksEngineWrapper.BuildDeploymentScript(IDirectoryInfoWrapper sourceFolder, Database targetDatabase, DeploymentOptions deploymentOptions, Differences differences, IDataSource databaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.GenerateMigrationDeploymentScript(Project project, String transactionIsolationLevel, Database sourceDatabase, Database targetDatabase, Differences differences, IDataSource databaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.CreateSqlFromDependencies(Database sourceDatabase, Database targetDatabase, Project project, Differences differences, String transactionIsolationLevel, IEnumerable`1 comparisonWarnings, IWork work, IDataSource targetDatabaseSource) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentScriptGenerator.<>c__DisplayClass4_1.b__1() at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Mappings.ViewModel.StatusEventArgsHandler.d__1`2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Services.Deployment.SchemaDeploymentGenerator.d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Model.Sync.SchemaSynchronizationState.<>c__DisplayClass44_0.<b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at FurHelper.FurUtils.d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.SqlServer.Comparison.Schema.UI.Model.Sync.SchemaSynchronizationState.d__44.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__160.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__152.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizardController.d__152.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Compare.CommonUI.Forms.SynchronizationWizard.SynchronizationWizard.d__13.MoveNext()" Method="LibGit2Sharp.Core.Ensure.HandleError(Int32 result) (also happens if trying to link db to TFVS and doing get latest)
Answers