Import flat file wizard stuck on step 4

[philipnye]

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]]

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

• Open Developer Tools (Help -> Toggle Developer Tools)

• Click the Console tab

• Click in the log area and select all text (CTRL+A)

• Save this text into a file named console.log and attach it to this issue.

• Developer Tools can be closed via Help -> Toggle Developer Tools Application Logs

• Open command palette (Click View -> Command Palette)

• Run the command: Developer: Open Logs Folder

• This will open the log folder locally. Please zip up this folder and attach it to the issue.

[philipnye]

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_Electoral_Regions_(December_2020)_Lookup_in_the_United_Kingdom.csv

[aasimkhan30]

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

[cheenamalhotra]

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]

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]

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]

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]

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]

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

[peterbud]

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

[Joly0]

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