microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.6k stars 909 forks source link

Import flat file wizard stuck on step 4 #22360

Open philipnye opened 1 year ago

philipnye commented 1 year ago

Issue Type: Bug

  1. Attempt to import an 18KB file with two columns and 650 rows.
  2. Go through steps 1-3 of the wizard fine, and have a strong 'AzureActiveDirectory - Universal with MFA support' connection - all other operations are working fine
  3. Import wizard hangs on step 4, and never seems to complete

I note that I'm basically describing the same experience as in the closed issue #12624

Extension version: 1.5.4 Azure Data Studio version: azuredatastudio 1.41.2 (0f0960d0e774e1ce903b79378addff96117c27a6, 2023-02-08T20:16:49.071Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-8365U CPU @ 1.60GHz (8 x 1896)| |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)|7.82GB (0.57GB free)| |Process Argv|--folder-uri file:///c%3A/Users/nyep/Institute%20for%20Government/Data%20-%20General/UK%20government%20and%20politics/Ministers/Ministers%20database| |Screen Reader|no| |VM|0%|
github-actions[bot] commented 1 year ago

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart ADS and repro your issue. Next there are two types of logs to collect:

Console Logs

philipnye commented 1 year ago

Logs as requested - with edits just to remove connection details. Also attached is the file I'm trying to import using the import wizard. Thanks. console.log 20230404T102453.zip Westminster_Parliamentary_Constituency_to_European_ElectoralRegions(December_2020)_Lookup_in_the_United_Kingdom.csv

aasimkhan30 commented 1 year ago

@cheenamalhotra , based on logs it seems related to #22999

cheenamalhotra commented 1 year ago

From the STS logs it seems there was an NRE:

Verbose: 0 : Processing message with id[11], of type[Request] and method[connection/getconnectionstring]
Error: 0 : connection/getconnectionstring : Object reference not set to an instance of an object.
Verbose: 0 : Sending message of id[11], of type[Response] and method[connection/getconnectionstring]

[Error - 10:26:39] Request connection/getconnectionstring failed.
  Message: Object reference not set to an instance of an object.
  Code: 0 

In the issue #22999 you could still get connection string but failed to connect with access token provided, so doesn't seem related directly... Have you seen something like that before?

cheenamalhotra commented 1 year ago

Moving to July, as it seems like a one time error than a consistent use-case, and we also haven't heard more reports on this.. However, I don't think this can be closed with #22999.

@philipnye Do you still face this issue or it went away with recent releases? Maybe you can give ADS latest stable v1.43 a try and let us know?

philipnye commented 1 year ago

Just tested this again on v1.43 and I'm afraid I'm still experiencing it!

I've attached new logs (I was trying to import the same file).

console.log 20230509T172621.zip

philipnye commented 1 year ago

Just to add: I've tested this with a handful of other CSVs (e.g. the attached) and having the same experience, so I don't think it's anything to do with the particular file I've been testing with. trees.csv

cheenamalhotra commented 1 year ago

Thanks for verifying.. I see below error:

[Error - 17:58:58] Request connection/listdatabases failed.
  Message: System.Exception: SpecifiedUri 'file:///c:/Users/***/Desktop/console.log' does not have existing connection
   at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.ListDatabases(ListDatabasesParams listDatabasesParams) in D:\a\_work\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 1080
   at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.<>c__DisplayClass86_0.<<HandleListDatabasesRequest>b__0>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 1312
  Code: 0 

@aasimkhan30 why would listdatabases call be made with file uri?

jatkins23 commented 1 year ago

I'm still having this issue on the Mac version as well

peterbud commented 1 year ago

This is still not working - any information when the fix will be released?

Joly0 commented 5 months ago

This issue is also affecting me. Is there a fix somehow?