sql database project failed to build Method not found: Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.get_DistributionColumns()

[ashdhalama]

Ashley_EDW.sqlproj.txt Type: Bug

I can build the project in VS2022 ok. But for the past few weeks I have not been able to build successfully with Azure Data Studios or Vscode.

I have other sqlproj build successfully in azure data studio.

[ Build ]

"C:\Program Files\dotnet\dotnet.exe" build "c:\Users\dhalama\source\repos\AshleyEDW\Ashley_EDW\Ashley_EDW.sqlproj" /p:NetCoreBuild=true /p:NETCoreTargetsPath="c:\Users\dhalama\.azuredatastudio\extensions\microsoft.sql-database-projects-1.4.1\BuildDirectory" /p:SystemDacpacsLocation="c:\Users\dhalama\.azuredatastudio\extensions\microsoft.sql-database-projects-1.4.1\BuildDirectory" stdout: MSBuild version 17.8.3+195e7f5a3 for .NET stdout: stdout: Determining projects to restore... stdout: stdout: Restored c:\Users\dhalama\source\repos\AshleyEDW\Ashley_EDW\Ashley_EDW.sqlproj (in 182 ms). stdout: stdout: Creating a model to represent the project... stdout: stdout: Loading project references... stdout: stdout: Loading project files... stdout: stdout: c:\Users\dhalama.azuredatastudio\extensions\microsoft.sql-database-projects-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: The "SqlBuildTask" task failed unexpectedly. [c:\Users\dhalama\source\repos\AshleyEDW\Ashley_EDW\Ashley_EDW.sqlproj] stdout: c:\Users\dhalama.azuredatastudio\extensions\microsoft.sql-database-projects-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: System.MissingMethodException->Microsoft.Build.Framework.BuildException.GenericBuildTransferredException: Method not found: 'System.Collections.Generic.IList`1 Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.get_DistributionColumns()'. [c:\Users\dhalama\source\repos\AshleyEDW\Ashley_EDW\Ashley_EDW.sqlproj]

Extension version: 1.4.1 Azure Data Studio version: azuredatastudio 1.47.1 (b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e, 2024-01-10T02:15:02.628Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info

|Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz (8 x 1690)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|15.41GB (2.17GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

[kisantia]

@ssreerama fyi

[hettic1]

Same error here and in Visual Studio 2022 it builds successful. To be precise. I'm using Azure Data Warehouse as my target platform.

_stdout: c:\Users.....vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: The "SqlBuildTask" task failed unexpectedly. [c:\Users\dev_gvanolst\source\repos\Edw.Datawarehouse\Edw.Datawarehouse.sqlproj] stdout: c:\Users.....vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: System.MissingMethodException: Method not found: 'System.Collections.Generic.IList`1 Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.getDistributionColumns()'.

Version: 1.86.0 (user setup) Commit: 05047486b6df5eb8d44b2ecd70ea3bdf775fd937 Date: 2024-01-31T10:28:19.990Z Electron: 27.2.3 ElectronBuildId: 26495564 Chromium: 118.0.5993.159 Node.js: 18.17.1 V8: 11.8.172.18-electron.0 OS: Windows_NT x64 10.0.19045