Azuredatastudio: No response to Add Connection on macOS

[etherwizard]

• SQL Operations Studio Version: sqlops 0.26.7 (723c7cb3bfd80d87fc8a1141632089cd4808495c, 2018-02-16T21:17:29.202Z)
• OS Version: Darwin x64 17.4.0
  

  - Extensions: none

Steps to Reproduce:

1. Open SQL Operations Studio in macOS
2. Click on Add Connection

[samirbehara]

Hello...I just installed the Feb Preview on my macOS and was able to see the Connection window after clicking on Add Connection. Can you quit SQL Ops Studio and try it again please?

[etherwizard]

Version 0.26.7 (0.26.7)

Quit and reopened. Getting the same result. No response to Add Connection. I also tried creating a server group, then right-clicking and selecting New Connection, and the New Connection button next to New Server Group.

[kburtram]

@etherwizard could you please open the developer console (Help -> Toggle Developer Tools, Console tab) and let me know if there are any errors there?

[antonpiatek-imanage]

Same issue seen on Ubuntu 17.10, installed via deb. Console tab shows nothing either

• SQL Operations Studio Version: sqlops 0.26.7 (723c7cb3bfd80d87fc8a1141632089cd4808495c, 2018-02-16T21:33:40.686Z)
• OS Version: Linux x64 4.13.0-36-generic
• Extensions: none

[etherwizard]

@kburtram: This is the error I see in the console:

_Activating extension Microsoft.mssql failed: Cannot find module '../resourceProvider/resourceProvider'._
_Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /private/var/folders/[etc]_

I am unable to install mssql using the Extensions Marketplace. It appears to be deactivated in this preview. Is mssql supposed to be integrated into SQL Operations Studio?

[vtomasr5]

Hi
Same here but in my case the OS is Linux (Ubuntu 16.04 x64)
In a clean installation when I click on "Add Connection" there is no response (no new dialog and no errors)
I've check the Developer Tools console but nothing strange shows up.

After a while of clicking a few times in the "Add Connection" button something happened. The "Extension Host" crashed and new error messages show up in the Web Console:

error.log

[kburtram]

On various Linux systems you may need to install libuwind8 manually for the .Net Core out-of-proc SQL Tools Service component to run (for example on Debian). Please check if installing that library helps.

For Ubuntu, this component should already be installed in most configurations, so I'm not sure what's going on there.

We'll be updating the DEB and RPM packages to automatically pull in this dependency to avoid that issue.

[antonpiatek-imanage]

Is libuwind8 supposed to be a deb? Because on Ubuntu 17.10 apt doesn't know about it

[kburtram]

@antonpiatek-imanage here is some info on libunwind8 https://packages.ubuntu.com/xenial/libunwind8. Sorry for the typo in previous comment.

[antonpiatek-imanage]

Thanks @kburtram, looks like a typo above was what was confusing me - installing libunwind8 on my ubuntu 17.10 artful box now makes the connect dialog appear and I can successfully connect to a local db

[vtomasr5]

Yeah, I can confirm that installing that package it works like a charm! :)

[etherwizard]

@kburtram

Any updates? Can we get the mssql extension bundled in the next preview for macOS? Or is there a way this extension can be copied to the app package manually?

[kburtram]

@etherwizard mssql extension is bundled with SQL Ops Studio. Are you still seeing this issue with March release 0.27.3?

[etherwizard]

@kburtram Thanks for following up. Yes, verified that version 0.27.3 is currently installed. The same error is being logged in the Developer Tools.

[kburtram]

@etherwizard I left the below comment on #1117 though I think this is the same step I'd recommend to follow-up here. Thanks!

...we've had a couple reports of similar behavior on macOS, but we still don't have an internal repro or additional diagnostic information. I suspect there is something regarding the environment that is causing issues with .Net Core 2.0.

If you have time, could you please try running the below command from a terminal window. The app should start without any output. You can close the process with Control+C.

"/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/mssql/sqltoolsservice/OSX/1.4.0-alpha.20/MicrosoftSqlToolsServiceLayer"

Please replace /Applications/SQL Operations Studio.app/ with the location that SQL Ops Studio is installed. Also, 1.4.0-alpha.20 will be different if you aren't using 0.28.3.

Please let me know if any error messages are omitted when running the above command. Thanks!

[etherwizard]

@kburtram : It was 1.4.0-alpha.16 for version 0.27.3. Running the MicrosoftSqlToolsServiceLayer utility didn't show any errors in Terminal.

_Activating extension Microsoft.mssql failed: Cannot find module '../resourceProvider/resourceProvider'_

I've seen similar broken dependency chain errors in Zone.js working with Angular 2 / 5 so I tried "npm install" in Contents/Resources/app. This error was reported from npm: "Cannot find module '/Applications/SQL Operations Studio.app/Contents/Resources/app/build/npm/preinstall.js'". The build folder doesn't exist in the app folder. Thought it might be worth a try.

[etherwizard]

These errors occur on opening immediately after clean install of 0.28.6 on macOS 10.13.4 (causes entire Electron window to be empty black with no user interaction possible):

/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 ERR Cannot set property 'groupId' of undefined: TypeError: Cannot set property 'groupId' of undefined
at Function.ConnectionProfile.createFromStoredProfile (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:13931:47)
at file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:99870:62
at Array.map (native)
at ConnectionConfig.getConnections (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:99869:47)
at ConnectionStore.getConnectionProfileGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:143714:66)
at ConnectionManagementService.getConnectionGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:263923:42)
at ConnectionManagementService.hasRegisteredServers (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:263962:53)
at new ConnectionManagementService (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:263418:53)
at create (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:8492:14)
at InstantiationService._createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92309:35)

ERR [createInstance] MainThreadAccountManagement depends on UNKNOWN service accountManagementService.: Error: [createInstance] MainThreadAccountManagement depends on UNKNOWN service accountManagementService.
at InstantiationService._createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92283:27)
at InstantiationService.createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92270:29)
at ExtensionService._createExtensionHostCustomers (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:181963:59)
at file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:181924:39
at Object.notifySuccess [as _notify] (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15308:59)
at Object.enter (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14990:30)
at _Base.Class.derive._creator._run (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15206:29)
at _Base.Class.derive._creator._completed (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15174:18)
at Object.notifySuccess [as _notify] (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15308:59)
at Object.enter (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14990:30)

[Extension Host] Activating extension 'Microsoft.account-provider-azure' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension Microsoft.account-provider-azure failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension 'vscode.git' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension vscode.git failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension 'vscode.merge-conflict' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension vscode.merge-conflict failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension 'Microsoft.mssql' failed: Cannot find module './resourceProvider/resourceProvider'.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
log @ workbench.main.js:24437
ExtensionHostProcessWorker._logExtensionHostMessage @ workbench.main.js:177641
(anonymous) @ workbench.main.js:177474
ZoneDelegate.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:421
Zone.runTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:188
ZoneTask.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:496
ZoneTask.ZoneTask.cancelFn.invoke @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:485
emitTwo @ events.js:106
emit @ events.js:194
process.nextTick @ internal/child_process.js:766
ZoneDelegate.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:421
Zone.runTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:188
ZoneTask.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:496
ZoneTask.ZoneTask.cancelFn.invoke @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:485
data.args.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:1316
_combinedTickCallback @ internal/process/next_tick.js:73
_tickCallback @ internal/process/next_tick.js:104
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Activating extension Microsoft.mssql failed: Cannot find module './resourceProvider/resourceProvider'
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251
log @ workbench.main.js:24437
ExtensionHostProcessWorker._logExtensionHostMessage @ workbench.main.js:177641
(anonymous) @ workbench.main.js:177474
ZoneDelegate.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:421
Zone.runTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:188
ZoneTask.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:496
ZoneTask.ZoneTask.cancelFn.invoke @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:485
emitTwo @ events.js:106
emit @ events.js:194
process.nextTick @ internal/child_process.js:766
ZoneDelegate.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:421
Zone.runTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:188
ZoneTask.invokeTask @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:496
ZoneTask.ZoneTask.cancelFn.invoke @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:485
data.args.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:1316
_combinedTickCallback @ internal/process/next_tick.js:73
_tickCallback @ internal/process/next_tick.js:104
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.…:2251 [Extension Host] Here is the error stack: Error: Cannot find module './resourceProvider/resourceProvider'
at Function.Module._resolveFilename (module.js:470:15)
at Function.Module._load (module.js:418:25)
at Function.load [as _load] (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/node/extensionHostProcess.js:44444:33)
at Module.require (module.js:498:17)
at Module.patchedRequire [as require] (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/git/node_modules/diagnostic-channel/dist/src/patchRequire.js:14:46)
at require (internal/module.js:20:19)
at Object. (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/mssql/out/main.js:23:28)
at Object. (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/mssql/out/main.js:165:3)
at Module._compile (module.js:571:32)
at Object.Module._extensions..js (module.js:580:10)

[etherwizard]

These errors occur on opening immediately after clean install of 0.29.3 on macOS 10.13.4 (causes entire Electron window to be empty black with no user interaction possible):

ERR Cannot set property 'groupId' of undefined: TypeError: Cannot set property 'groupId' of undefined
at Function.ConnectionProfile.createFromStoredProfile (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:13924:47)
at file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:100472:62
at Array.map (native)
at ConnectionConfig.getConnections (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:100471:47)
at ConnectionStore.getConnectionProfileGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:144499:66)
at ConnectionManagementService.getConnectionGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265571:42)
at ConnectionManagementService.hasRegisteredServers (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265610:53)
at new ConnectionManagementService (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265066:53)
at create (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:8426:14)
at InstantiationService._createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92749:35)
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [uncaught exception]: TypeError: Cannot set property 'groupId' of undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 TypeError: Cannot set property 'groupId' of undefined
at Function.ConnectionProfile.createFromStoredProfile (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:13924:47)
at file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:100472:62
at Array.map (native)
at ConnectionConfig.getConnections (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:100471:47)
at ConnectionStore.getConnectionProfileGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:144499:66)
at ConnectionManagementService.getConnectionGroups (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265571:42)
at ConnectionManagementService.hasRegisteredServers (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265610:53)
at new ConnectionManagementService (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:265066:53)
at create (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:8426:14)
at InstantiationService._createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92749:35)
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 ERR [createInstance] MainThreadAccountManagement depends on UNKNOWN service accountManagementService.: Error: [createInstance] MainThreadAccountManagement depends on UNKNOWN service accountManagementService.
at InstantiationService._createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92723:27)
at InstantiationService.createInstance (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92710:29)
at ExtensionService._createExtensionHostCustomers (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:183307:59)
at file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:183268:39
at Object.notifySuccess [as _notify] (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15301:59)
at Object.enter (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14983:30)
at _Base.Class.derive._creator._run (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15199:29)
at _Base.Class.derive._creator._completed (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15167:18)
at Object.notifySuccess [as _notify] (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15301:59)
at Object.enter (file:///Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14983:30)
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 WARNING: Promise with no error callback:68
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 Object
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 Error: [createInstance] MainThreadAccountManagement depends on UNKNOWN service accountManagementService.
at InstantiationService._createInstance (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92723)
at InstantiationService.createInstance (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:92710)
at ExtensionService._createExtensionHostCustomers (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:183307)
at /Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:183268
at Object.notifySuccess [as _notify] (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15301)
at Object.enter (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14983)
at _Base.Class.derive._creator._run (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15199)
at _Base.Class.derive._creator._completed (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15167)
at Object.notifySuccess [as _notify] (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:15301)
at Object.enter (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:14983)
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] WARNING: Promise with no error callback:2
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host]% Object
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension 'Microsoft.account-provider-azure' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension Microsoft.account-provider-azure failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension 'vscode.git' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension vscode.git failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension 'vscode.merge-conflict' failed: {1}.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension vscode.merge-conflict failed: undefined
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Here is the error stack: undefined
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension 'Microsoft.mssql' failed: Cannot find module './resourceProvider/resourceProvider'.
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Activating extension Microsoft.mssql failed: Cannot find module './resourceProvider/resourceProvider'
Zone.__load_patch.consoleMethods.forEach.console.(anonymous function) @ /Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251
/Applications/SQL Operations Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:2251 [Extension Host] Here is the error stack: Error: Cannot find module './resourceProvider/resourceProvider'
at Function.Module._resolveFilename (module.js:470:15)
at Function.Module._load (module.js:418:25)
at Function.load [as _load] (/Applications/SQL Operations Studio.app/Contents/Resources/app/out/vs/workbench/node/extensionHostProcess.js:44795:33)
at Module.require (module.js:498:17)
at Module.patchedRequire [as require] (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/git/node_modules/diagnostic-channel/dist/src/patchRequire.js:14:46)
at require (internal/module.js:20:19)
at Object. (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/mssql/out/main.js:23:28)
at Object. (/Applications/SQL Operations Studio.app/Contents/Resources/app/extensions/mssql/out/main.js:165:3)
at Module._compile (module.js:571:32)
at Object.Module._extensions..js (module.js:580:10)

[gscht]

I got the same error. The hard disk was formatted with case-sensitive APFS.

After I formatted the disk with case-insensitive APFS, the error was gone.

macOS: 10.13.5
SQL Operations Studio: 0.29.3

[etherwizard]

@gscht Thanks for reporting this! Unfortunately reformatting with APFS case-insensitive isn't an option for me. I wonder if this has anything to do with the default case-insensitive collation in SQL Server?

[kburtram]

@etherwizard we're investigating a similar missing resourceProvider issue at https://github.com/Microsoft/sqlopsstudio/issues/1718. I pushed a test build that may help with this issue https://sqlopsbuilds.blob.core.windows.net/stage/sqlops-macos-0.31.1-resourceprovider.zip. Please let me know if you still hit this problem with this build.

[kburtram]

There is a fix available for the resourceProvider issue on macOS with case-sensitive filesytems in the test build mentioned above. This fix will be included in subsequent insiders and stable builds. Please reactive if there are additional issues not resolved in those builds.

[etherwizard]

@kburtram: I can confirm that the test build linked in your post above is working correctly on macOS 10.13.5 with case-sensitive APFS. Many thanks for your attention to this!

[kburtram]

@etherwizard thanks for confirming! It's nice to finally close out this long standing bug.