What are the challenges you face when working across database platforms? Take the survey
Options

Builds now fail after installing SQL toolbelt

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?
Tagged:

Best Answers

  • Options
    XyzzyXyzzy Posts: 3 Bronze 1
    I 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.
  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi 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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

  • Options
    Xyzzy,

    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.
  • Options
    MichelDMichelD Posts: 8 Bronze 1
    edited December 18, 2017 9:42AM
    Same here, 'Fix' by disabling SQL Prompt works. First release of SQL Prompt 9 worked
  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    edited December 18, 2017 4:45PM
    Hi All,

    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Options
    XyzzyXyzzy Posts: 3 Bronze 1
    This has fixed this issues I was having in VS2015.
    Thanks
  • Options
    The update fixed my problem.
    Thank you for the quick workaround and fix!
Sign In or Register to comment.