azuredatastudio: Intellicode error shown upon launch

Issue Type: Bug

When launching ADS, an error activating Intellicode is shown.

Sorry, something went wrong activating IntelliCode support for SQL. Please check the "MSSQL" and "VS IntelliCode" output windows for details.
[2023-03-14 14:05:24.545] [exthost] [info] Extension host with pid 23196 started
[2023-03-14 14:05:24.621] [exthost] [info] ExtensionService#_doActivateExtension Microsoft.xml-language-features, startup: false, activationEvent: 'onLanguage:sql'
[2023-03-14 14:05:24.633] [exthost] [info] ExtensionService#_doActivateExtension VisualStudioExptTeam.vscodeintellicode, startup: false, activationEvent: 'onLanguage:sql'
[2023-03-14 14:05:24.763] [exthost] [info] ExtensionService#_doActivateExtension Microsoft.azurecore, startup: true, activationEvent: '*'
[2023-03-14 14:05:27.394] [exthost] [info] ExtensionService#_doActivateExtension vscode.git-base, startup: true, activationEvent: '*', root cause: vscode.git
[2023-03-14 14:05:27.404] [exthost] [info] ExtensionService#_doActivateExtension vscode.ipynb, startup: true, activationEvent: '*'
[2023-03-14 14:05:27.415] [exthost] [info] ExtensionService#_doActivateExtension Microsoft.mssql, startup: true, activationEvent: '*'
[2023-03-14 14:05:27.491] [exthost] [info] ExtensionService#_doActivateExtension Microsoft.notebook, startup: true, activationEvent: '*'
[2023-03-14 14:05:27.963] [exthost] [info] ExtensionService#_doActivateExtension vscode.git, startup: true, activationEvent: '*'
[2023-03-14 14:05:27.993] [exthost] [info] ExtensionService#_doActivateExtension vscode.github, startup: true, activationEvent: '*'
[2023-03-14 14:05:30.233] [exthost] [info] Eager extensions activated
[2023-03-14 14:05:30.243] [exthost] [info] ExtensionService#_doActivateExtension vscode.merge-conflict, startup: false, activationEvent: 'onStartupFinished'
[2023-03-14 14:05:30.417] [exthost] [error] Error: Could not load type 'Microsoft.SqlTools.Utility.Logger' from assembly 'Microsoft.SqlTools.Hosting, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.
	at c:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\extensions\mssql\dist\main.js:2:694018
	at c:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\extensions\mssql\dist\main.js:2:694312
	at Immediate.<anonymous> (c:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\extensions\mssql\dist\main.js:2:694673)
	at process.processImmediate (node:internal/timers:466:21) mssql.loadCompletionExtension {"value":"Microsoft.mssql","_lower":"microsoft.mssql"}
[2023-03-14 14:06:44.973] [exthost] [info] ExtensionService#_doActivateExtension vscode.github-authentication, startup: false, activationEvent: 'onAuthenticationRequest:github'

Intellicode Output tab:

Acquiring model 'intellisense-members' for sql
Querying IntelliCode service for available models.
Cached model is up to date.
vs-intellicode-SQL was passed a model: {"modelPath":"c:\\Users\\jtsombakos\\.azuredatastudio-insiders\\extensions\\visualstudioexptteam.vscodeintellicode-1.2.1\\cache\\99136CA159AB897D942412E976015B8C9EC2_6D6727BA7E6347BE9124EF572943AC5C","modelId":"99136CA159AB897D942412E976015B8C9EC2","outputId":"6D6727BA7E6347BE9124EF572943AC5C"}.
Error while activating SQL: {"code":0,"data":null}

Azure Data Studio version: azuredatastudio-insiders 1.43.0-insider (ef99e67cfe16ba993ccec2de266c5f973492e5de, 2023-03-14T05:32:31.464Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled

System Info
Item Value
CPUs Intel® Core™ i5-8500 CPU @ 3.00GHz (6 x 3000)
GPU Status 2d_canvas: enabled
canvas_oop_rasterization: disabled_off
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
skia_renderer: enabled_on
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: disabled_off
Load (avg) undefined
Memory (System) 31.78GB (15.91GB free)
Process Argv
Screen Reader no
VM 0%
Extensions (8)
Extension Author (truncated) Version
dacpac Mic 1.13.0
import Mic 1.5.4
schema-compare Mic 1.18.0
sql-database-projects Mic 0.22.0
sql-search Red 0.4.0
ADS-add-columns sof 0.0.12
vscodeintellicode Vis 1.2.1
poor-sql-formatter WSR 0.1.0

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Reactions: 3
  • Comments: 15 (5 by maintainers)

Most upvoted comments

This appears related to changes made in the SQL Tools Service component in 1.42 that are fixed by the linked PR. We’ll have the fix in insiders build once that’s merged over into ADS.

For additional context this is the error shown on ADS startup.

image