Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to list views #21171

Closed
TimoBahama opened this issue Nov 9, 2022 · 10 comments · Fixed by #21561
Closed

Unable to list views #21171

TimoBahama opened this issue Nov 9, 2022 · 10 comments · Fixed by #21561
Assignees
Labels
Area - Object Explorer Bug Pri: 1 Size: M For a medium complexity issue - only when fixed with a PR Triage: Done

Comments

@TimoBahama
Copy link

I cant list my views anymore. Table listing is ok.

Version: 1.39.1
Commit: 7553f79
Date: 2022-08-30T01:12:48.559Z
VS Code: 1.62.0
Electron: 13.6.6
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Darwin x64 18.7.0

Screenshot 2022-11-09 at 9 55 43 AM

@lewis-sanchez
Copy link
Contributor

HI @TimoBahama, I was unable to reproduce this for a local SQL DB and an Azure SQL DB. Would you be able to share any warnings/errors you see in the dev tools console.

You can open the dev tools console like this, if you aren't sure on how to do that:
image

@github-actions
Copy link

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.

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.

@lewis-sanchez lewis-sanchez self-assigned this Nov 14, 2022
@TimoBahama
Copy link
Author

TimoBahama commented Nov 15, 2022

console.log
Archive.zip

Please kindly find the requested elements attached

@aasimkhan30
Copy link
Contributor

@TimoBahama , we have fixed this issue with the latest release 1.40.1. Can you please update your ADS and give it a try.

@aasimkhan30 aasimkhan30 added Pri: 2 Size: L For a large complexity issue - only when fixed with a PR Pri: 1 and removed Pri: 2 labels Dec 13, 2022
@TimoBahama
Copy link
Author

TimoBahama commented Dec 14, 2022 via email

@lewis-sanchez
Copy link
Contributor

@TimoBahama, do you still experience this issue in insider version 1.41.0?

@TimoBahama
Copy link
Author

TimoBahama commented Dec 21, 2022 via email

@cheenamalhotra
Copy link
Member

cheenamalhotra commented Jan 9, 2023

The root cause looks similar to #21541.. confirmed with logs attached above: #21171 (comment)
PR microsoft/sqltoolsservice#1801 addresses this issue from SqlToolsService.

@cheenamalhotra cheenamalhotra added Size: M For a medium complexity issue - only when fixed with a PR and removed Size: L For a large complexity issue - only when fixed with a PR Needs Logs labels Jan 9, 2023
@TimoBahama
Copy link
Author

TimoBahama commented Jan 10, 2023 via email

@cheenamalhotra cheenamalhotra linked a pull request Jan 10, 2023 that will close this issue
@TimoBahama
Copy link
Author

TimoBahama commented Jan 31, 2023 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Area - Object Explorer Bug Pri: 1 Size: M For a medium complexity issue - only when fixed with a PR Triage: Done
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants