To install the IUware version of Aqua Data Studio: It is a real shame, because the tool is otherwise perfect and great to see ongoing feature improvements.Back to top Install the application on your computer I notice a lot of new features being added at each release - am surprised that a show stopper bug. I have removed all extensions in case there was some interference there to no avail. Aside from my corporate network and VPN infrastructure, the client is the only constant here that I can see. I experience this same issue on all different clients I have used this on (Windows & Linux), connected to different SQL servers.
I am using this over a WAN connected via VPN (Cisco Anyconnect) - I personally believe there is a connection persistence issue at play. This has been on every version for the last 2+ years. Literally greater than 50% of the queries I execute have this issue - and although a restart usually fixes the next query, the problem returns shortly thereafter. after initiating execute with either mouse or keyboard shortcuts, the time counter stays at 00:00:00 for several minutes before starting).
Simple queries can take from 1 to 3 minutes to begin executing (i.e. In case it isn't clear to the devs, this problem that has persisted for several years now essentially makes the ADS tool unusable a significant percentage of the time. Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:2280 Unhandled Promise rejection: Canceled Zone: Task: Promise.then Value: Canceled: CanceledĪt Object.t.canceled (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:127:183)Īt cancel (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:236:737)Īt t.Client.requestEvent (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:1407:542)Īt Object.listen (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:1406:856)Īt Object.listen (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:522:290)Īt t.SearchChannelClient.fileSearch (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:4822:579)Īt file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/:6869:51Īt ZoneDelegate.invoke (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:388:26)Īt n (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:138:43)Īt /Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:872:34Īt ZoneDelegate.invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:421:31)Īt nTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:188:47)Īt drainMicroTaskQueue (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:595:35) Canceled: CanceledĪt drainMicroTaskQueue (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:595:35)Ĭonsole.
(u.type in ('U', 'S', 'G', 'C', 'K' ,'E', I killl that session, my original query in the other window starts running right away. LEFT OUTER JOIN sys.certificates AS cert ON cert.sid = u.sid LEFT OUTER JOIN sys.database_permissions AS dp ON dp.grantee_principal_id = u.principal_id and dp.type = OUTER JOIN sys.asymmetric_keys AS ak ON ak.sid = u.sid WHEN N'S' = u.type AND SUSER_SNAME(u.sid) is null AND u.authentication_type != 2 THEN 3 Intel(R) Core(TM) i7-6820HQ CPU 2.70GHz (8 x 2700)ĬAST(CASE WHEN u.principal_id < 5 OR u.principal_id = 16382 OR u.principal_id = 16383 THEN 1 ELSE 0 END AS bit) AS ,ĬASE WHEN N'U' = u.type THEN 0 WHEN N'G' = u.type THEN 1 WHEN N'S' = u.type THEN 2 WHEN N'C' = u.type THEN 3 WHEN N'K' = u.type THEN 4 WHEN N'E' = u.type THEN 5 WHEN N'X' = u.type THEN 6 END AS ,ĬAST(CASE dp.state WHEN N'G' THEN 1 WHEN 'W' THEN 1 ELSE 0 END AS bit) AS , OS version: Darwin 圆4 18.7.0 System Info Item I have to quit Azure Data Studio, reconnect to the SQL Server and then run the query and it works.Īzure Data Studio version: Azure Data Studio 1.11.0 ( 460c739, T17:14:33.682Z) Sometime when running queries it just sits there saying executing query and doesn't finish.