azuredatastudio: Select Top 1000 Records Stops working

Type: Bug

Right clicking on a table and selecting “Select Top 100 Records” only works the first time. Any subsequent attempts to use this command, on any table, does nothing. No response.

This is the developer tools logs after running the command the first, successful, time:

[Extension Host] (node:19636) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead.
(Use `azuredatastudio-insiders --trace-deprecation ...` to show where the warning was created) (at c:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\out\vs\workbench\api\node\extensionHostProcess.js:83:196474)
C @ console.ts:137
$logExtensionHostMessage @ mainThreadConsole.ts:39
_doInvokeHandler @ rpcProtocol.ts:457
_invokeHandler @ rpcProtocol.ts:442
_receiveRequest @ rpcProtocol.ts:370
_receiveOneMessage @ rpcProtocol.ts:296
(anonymous) @ rpcProtocol.ts:161
invoke @ event.ts:622
deliver @ event.ts:824
fire @ event.ts:785
fire @ ipc.net.ts:638
_receiveMessage @ ipc.net.ts:959
(anonymous) @ ipc.net.ts:832
invoke @ event.ts:622
deliver @ event.ts:824
fire @ event.ts:785
acceptChunk @ ipc.net.ts:382
(anonymous) @ ipc.net.ts:338
_ @ ipc.net.ts:70
emit @ node:events:526
addChunk @ node:internal/streams/readable:315
readableAddChunk @ node:internal/streams/readable:289
Readable.push @ node:internal/streams/readable:228
onStreamRead @ node:internal/stream_base_commons:190
log.ts:301  INFO Disconnect request sent for connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2 - deleting connection
log.ts:301  INFO Deleting connection connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2
log.ts:301  INFO Disconnect request sent for untitled:SQLQuery_2 - deleting connection
log.ts:301  INFO Deleting connection untitled:SQLQuery_2
log.ts:301  INFO Removing connection connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2
log.ts:313   ERR Cannot read properties of undefined (reading 'savePassword'): TypeError: Cannot read properties of undefined (reading 'savePassword')
    at q.disconnectConnection (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2890:41423)
    at vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2890:35010
    at h.invoke (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:145)
    at u.deliver (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:2266)
    at r.fire (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:1844)
    at ba._notifyDisconnected (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2712:44065)
    at vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2712:40643
    at _ZoneDelegate.invoke (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:409:30)
    at Zone.run (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:169:47)
    at C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:1326:38
    at _ZoneDelegate.invokeTask (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:443:35)
    at Zone.runTask (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:214:51)
    at drainMicroTaskQueue (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:632:39)
DevTools failed to load source map: Could not load content for https://sqlopsbuilds.blob.core.windows.net/sourcemaps/cdece24123139285de21ab25e9281786fca7d93b/node_modules/@vscode/vscode-languagedetection/dist/lib/index.js.map: Fetch through target failed: Target not supported; Fallback: Unknown error

Azure Data Studio version: azuredatastudio-insiders 1.45.0-insider (cdece24123139285de21ab25e9281786fca7d93b, 2023-06-19T05:36:45.774Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:

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 (16.21GB free)
Process Argv
Screen Reader no
VM 0%
Extensions (7)
Extension Author (truncated) Version
dacpac Mic 1.13.0
import Mic 1.5.5
schema-compare Mic 1.19.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
  • Comments: 23 (9 by maintainers)

Most upvoted comments

Also, the notification that shows the error (screenshot above), does not go away. It has the “status line” constantly moving, with no way to close it. Clicking the “Bell” icon will hide it, but it still shows as “not acknowledged.”

thanks for the feedback, I’ve fixed this just now, in case of error, the in progress indicator will be removed and a close button is added so you can close it.

image

@aasimkhan30 will look into the actual error here, he will let you know when the issue is fixed.

I have that setting on. I tried turning off (and restarting), but am getting the same incorrect behavior.