Builds now fail after installing SQL toolbelt
MichaelStone
Posts: 3 New member
My local system was working fine with Visual Studio Pro 2017 building a SQL project.
Then I installed SQL Toolbelt (Backup, Compare, Data Compare, Data Generator, Doc, Prompt, Search, Test, SSMS Integration Pack) and I now get this error when I build.
C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\Microsoft\VisualStudio\v15.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(559,5): Error: MSB4018: The "SqlBuildTask" task failed unexpectedly.
System.MissingMethodException: Method not found: 'Void Microsoft.Data.Tools.Schema.Sql.Deployment.SqlCmdFileVerifier..ctor(Microsoft.SqlServer.TransactSql.ScriptDom.TSqlParser, System.Collections.Generic.IDictionary`2<System.String,System.String>, Boolean)'.
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecutePrePostScriptsValidationStep()
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__26.MoveNext()
Based on a recommendation from another post I went to [Tools] [Extensions & Updates...] [Updates] and found an update to Visual Studio 15.5.2 and installed it in hopes it would fix any missing files, but the problem still exists.
Any suggestions?
Then I installed SQL Toolbelt (Backup, Compare, Data Compare, Data Generator, Doc, Prompt, Search, Test, SSMS Integration Pack) and I now get this error when I build.
C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\Microsoft\VisualStudio\v15.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(559,5): Error: MSB4018: The "SqlBuildTask" task failed unexpectedly.
System.MissingMethodException: Method not found: 'Void Microsoft.Data.Tools.Schema.Sql.Deployment.SqlCmdFileVerifier..ctor(Microsoft.SqlServer.TransactSql.ScriptDom.TSqlParser, System.Collections.Generic.IDictionary`2<System.String,System.String>, Boolean)'.
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecutePrePostScriptsValidationStep()
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__26.MoveNext()
Based on a recommendation from another post I went to [Tools] [Extensions & Updates...] [Updates] and found an update to Visual Studio 15.5.2 and installed it in hopes it would fix any missing files, but the problem still exists.
Any suggestions?
Tagged:
Best Answers
-
Xyzzy Posts: 3 Bronze 1I have the same issue - it broke vs2017 and vs2015. I uninstalled SQLPropt, and my build went back to normal. Now I have to dig out SQLPrompt 8 and install that.
-
Alex B Posts: 1,153 Diamond 4Hi all,
The developers have fixed the issue in SQL Prompt v9.0.4.3408 (download here). I have confirmed it works for me in my replication here, but please do let us know that it works for you all also!
Kind regards,
Alex
Answers
You correctly isolated the problem to SQL Prompt.
If I go to [Tools] [Extensions and Updates...] [Installed] SQL Prompt and <Disable> it, my builds work. Toggle it back to <Enable> and they fail.
I have a support ticket open on this already.
I've just reproduced this here as well. It worked before I updated to SSDT 17.4 (using VS2015, SSMS 17.4, SQL Prompt 9.0.3.3299; annoyingly I didn't record the SSDT version...). After updating to SSDT 17.4 I get the error you are seeing at the top. I've let the developers know and will update when I have further information!
For the time being, here is a link to 9.0.2 since the SSDT builds work with it.
Kind regards,
Alex
Have you visited our Help Center?
Thanks
Thank you for the quick workaround and fix!