Extension doesn't support queries

[pmalits-anstee]

Type: Feature Request

Execution failed due to an unexpected error:
No Handler Registered

Extension version: 0.1.3
Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1, 2023-08-03T00:42:37.945Z)
OS version: Windows_NT x64 10.0.19045
Restricted Mode: No
Preview Features: Enabled
Modes:

[lewis-sanchez]

Hi @pmalits-anstee, can you provide additional details about what you're trying to do and what you're using (i.e. Postgres, SQL, etc) when you encounter this error? Any screenshots you can provide will also be helpful to identify the impacted area. Thanks!

[pmalits-anstee]

Hi there, I am managed to connect to an Oracle DB v19 via Azure Studio. However, if I want to query the database – SELECT TOP 100 – I receive the following error message. ***@***.*** Please advise.

…

------------------------------------------------ Philip Malits-Anstee, MSc, Dip-CII aka Phil Data Analytics Lead – Placement Operations ***@***.******@***.***> mobile: 07812265199 ***@***.*** 1 Tower Place, Tower Place East, 1sh Floor, London EC3R 5BU From: Lewis Sanchez ***@***.***> Sent: 05 September 2023 20:13 To: microsoft/azuredatastudio ***@***.***> Cc: Malits, Philip ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/azuredatastudio] Extension doesn't support queries (Issue #24282) Hi @pmalits-anstee<https://urldefense.com/v3/__https:/github.com/pmalits-anstee__;!!O7V3aRRsHkZJLA!AiF0__Zs2mcEXHCbdswBNoc38eJrT3rNfI-8HiZJxQnCBG4krtv6iGa-BUuCCMTq781g68PqPjFcUeuoqEv3zwgKrS4$>, can you provide additional details about what you're trying to do and what you're using (i.e. Postgres, SQL, etc) when you encounter this error? Any screenshots you can provide will also be helpful to identify the impacted area. Thanks! — Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/microsoft/azuredatastudio/issues/24282*issuecomment-1707179265__;Iw!!O7V3aRRsHkZJLA!AiF0__Zs2mcEXHCbdswBNoc38eJrT3rNfI-8HiZJxQnCBG4krtv6iGa-BUuCCMTq781g68PqPjFcUeuoqEv3SLaEtgM$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BCKXG6O5JOEEFES4YSEJMPTXY52UHANCNFSM6AAAAAA4KEXR34__;!!O7V3aRRsHkZJLA!AiF0__Zs2mcEXHCbdswBNoc38eJrT3rNfI-8HiZJxQnCBG4krtv6iGa-BUuCCMTq781g68PqPjFcUeuoqEv3pTdbBL0$>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

________________________________ For more information on how we use your personal data please see our Privacy Notice for Marsh https://www.marsh.com/uk/privacy-notice.html. If you do not wish to receive unsolicited marketing information or recommendations about our other products and services, please reply to this email requesting to unsubscribe. Marsh Operations, a division of Marsh Limited, provide services for and act on behalf of Marsh Limited, Marsh Ireland Brokers Limited or Marsh NV/SA. Marsh Limited is authorised and regulated by the Financial Conduct Authority for General Insurance Distribution and Credit Broking. Registered Office: 1 Tower Place West, Tower Place, London EC3R 5BU. Registered in England No 01507274. The following are trading names of Marsh Limited: Lavaretus, Bowring Marsh, Marsh JLT Specialty, Lloyd & Partners CONFIDENTIALITY NOTICE This message (and any attachment) is intended solely for the addressee and may contain confidential and / or legally privileged information. If you have received this message in error, please inform the sender, and immediately and permanently delete it. If you are not the intended recipient do not use, copy or disclose the information contained in this message or in any attachment. All incoming / outgoing e-mail is intercepted and monitored. Therefore, it should neither be expected nor intended that any email is private in nature.

[github-actions]

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.

1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
3. Run the repro scenarios.
4. Collect the following logs:

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.

5. Now you can revert the Log/Tracing levels changes made in step 1 and step 2.

[cssuh]

@pmalits-anstee What exactly is the error message you are seeing?

[pmalits-anstee]

Hello, It’s the same issue that was raised in #18268. Does not work with Oracle extension · Issue #18268 · microsoft/azuredatastudio (github.com)<#18268> It looks like queries are still not supported. Can you confirm please.

…

------------------------------------------------ Philip Malits-Anstee, MSc, Dip-CII aka Phil Data Analytics Lead – Placement Operations ***@***.******@***.***> mobile: 07812265199 ***@***.*** 1 Tower Place, Tower Place East, 1sh Floor, London EC3R 5BU From: github-actions[bot] ***@***.***> Sent: 07 September 2023 19:27 To: microsoft/azuredatastudio ***@***.***> Cc: Malits, Philip ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/azuredatastudio] Extension doesn't support queries (Issue #24282) 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. 1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio. 2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace. 3. Run the repro scenarios. 4. Collect the following logs: 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. 1. Now you can revert the Log/Tracing levels changes made in step 1 and step 2. — Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/microsoft/azuredatastudio/issues/24282*issuecomment-1710597724__;Iw!!O7V3aRRsHkZJLA!AsW6xEBY0m-sGIKY2YFxZ-KQOB7svL399Ez0xbFnmD8pweYn-_he3wO7LES96P1bonrsbsdw-7KwBiBgpvB97-wuHYs$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BCKXG6MRIMHP4L7PMPLCYOLXZIGWVANCNFSM6AAAAAA4KEXR34__;!!O7V3aRRsHkZJLA!AsW6xEBY0m-sGIKY2YFxZ-KQOB7svL399Ez0xbFnmD8pweYn-_he3wO7LES96P1bonrsbsdw-7KwBiBgpvB9n4TNLoo$>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

________________________________ For more information on how we use your personal data please see our Privacy Notice for Marsh https://www.marsh.com/uk/privacy-notice.html. If you do not wish to receive unsolicited marketing information or recommendations about our other products and services, please reply to this email requesting to unsubscribe. Marsh Operations, a division of Marsh Limited, provide services for and act on behalf of Marsh Limited, Marsh Ireland Brokers Limited or Marsh NV/SA. Marsh Limited is authorised and regulated by the Financial Conduct Authority for General Insurance Distribution and Credit Broking. Registered Office: 1 Tower Place West, Tower Place, London EC3R 5BU. Registered in England No 01507274. The following are trading names of Marsh Limited: Lavaretus, Bowring Marsh, Marsh JLT Specialty, Lloyd & Partners CONFIDENTIALITY NOTICE This message (and any attachment) is intended solely for the addressee and may contain confidential and / or legally privileged information. If you have received this message in error, please inform the sender, and immediately and permanently delete it. If you are not the intended recipient do not use, copy or disclose the information contained in this message or in any attachment. All incoming / outgoing e-mail is intercepted and monitored. Therefore, it should neither be expected nor intended that any email is private in nature.

[cheenamalhotra]

Closing as duplicate of #6724 - you may upvote the same so we can better track feature requests.