LocalRunGuide.md says it's installed in

C:\Users\xxx.vscode\extensions\usqlextpublisher.usql-vscode-ext-x.x.x\LocalRunDependency

C:\Users\xxx.vscode\extensions\usqlextpublisher.usql-vscode-ext-x.x.x\LocalRunService

I'm setting up now, so it's possible that I've made a mistake, but figured I'd log it before I forget.

I am getting the error "[Info] Failed to get storages due to Unexpected parameter : LastName.msvscode.azuredatalake" when trying to compile a usql code or navigating in data lake store.

My Windows login is "FirstName LastName" (containing a space), it seems that it is getting lost because the folder that the extension is looking for is "C:\Users\FirstName LastName\ .msvscode.azuredatalake", but it is not able to handle with the space, considering it a second parameter, and not a single parameter.

Hi,

I am having problems when trying to connect Azure Data Lake and see my ADL accounts.
Let me explain what I do and what happens after all.

1. Open command pallet, then click ADL:Login option.
2. Logging in from Azure portal using generated code in VSCode
3. In VsCode, opening command pallate and calling ADL:ListAccounts

This command is returning me following message

[Info] Start listing Data Lake Analytics accounts...
[Info] 

Then nothing is listed. Normally I would expect Azure Data Analytics account to be listed there. Not only this command was failing, Data Lake Explorer was showing my subscription fine but when I want to see the ADLA account, it was not working. Also I can not submit/compile any usql file.

At this point what I did is, as mostly suggested, I looked at the Developer tools.
In developer tools I found a error message as following.

As indicated in the error message, I found the authenticationManager.js file in the path which error message is referring to and following method in the file.

updateDatalakeServiceCredentials() {
    if (AuthenticationManager.azureAccount.status == 'LoggedIn') {
        AuthenticationManager.azureAccount.sessions.forEach(session => {
            let tokens = session.credentials["tokenCache"]._entries;
            let token = tokens.find(t => t.tenantId == session.tenantId);
            console.log(`updateDatalakeServiceCredentials ${session.tenantId}, ${token.accessToken}`);
            this.logger.debug(`updateDatalakeServiceCredentials ${session.tenantId}, ${token.accessToken}`
            this.credentialAdd(session.tenantId, token.accessToken);
        });
    }
}

It was not super easy to debug this method, but with a lot of console.log(object), I got to know that following lines is the one causing an exception.

let tokens = session.credentials["tokenCache"]._entries;
let token = tokens.find(t => t.tenantId == session.tenantId);

in the first method tokens is being assigned to null and therefore find function throws an error.

The reason why tokens is being null is because session.credentials["tokenCache"] object does not have property _entries

When I log the session.credentials["tokenCache"] to console, I noticed that expected _entries array is not there. In fact, _entries array is beneath target property. Please check following screenshot.

Hence the code was throwing an exception. I don't know whether this is general bug or not. But once I changed all
session.credentials["tokenCache"]._entries;
into
session.credentials["tokenCache"].target._entries;

Everything started to work as expected. It was tedious problem because suddenly my development environment stopped working. I just wanted to share in case if it requires any action from on developer of this add-in.

Regards

After installing MSSQL and then usqlextpublisher.usql-vscode-ext

files with .sql are colored with USQL formatting.

ie #temp becomes a comment (green) and -- is not colored.

All my USQL scripts are .USQL and my TSQL are .sql. If this is an intended outcome, maybe someone could suggest a user settings to prevent .sql files being colored as USQL.

What is the future of this extension? Will it get updated to support .Net Core 3? Can't get it working as it complains it needs .Net Core 2, which is EOL.

Please open browser with private mode or ignotino mode to login due to an known issue of Authentication in the back end.

Hi,
I have installed (twice) VS Code and the Azure Data Lake Tools and continue to get this message:

Data Lake extension is initializing or restarting. Try again a few seconds later. Restart VSCode if you have changed port setting

We have tested fresh install on other MacOS machine and get the same error. We have rebooted the machine multiple times but still get message above.

We have installed powershell and Az powershell module but still get same error above.

Please help, thank you!

I have successfully connected Visual Studio Code to my ADL account, and when I issue the command adl: list accounts it is listened as well.

When opening the folder I see I my u-sql file is connected to that account (the account is listened in the right bottom corner)

However, when I try to register an assembly using adl: register assembly I cannot pick any account. It says "There are no entries to pick from".

What am I doing wrong here?

This is the content of the configuration file:

{
    "scripts": [
        {
            "path": "adl_settings.json",
            "account": "xxx"
        },
        {
            "path": "query.usql",
            "account": "xxx",
            "optionalSettings": {
                "runtimeVersion": "",
                "priority": "",
                "degreeOfParallelism": "",
                "jobInformationOutputPath": ""
            }
        }
    ]
}

I have version: 1.41.1 of Visual Code for Mac installed and I'm trying to follow the https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-data-lake-tools-for-vscode guide to get Azure Data Lake Tools installed.

I have mono installed, version 6.4.0.198 and .NET Core 3.1.101 but when I re-start VS for Mac after having installed the Data Lake Tools I get a popup saying "There are unresolved dependencies. Please execute the restore command to continue." When I do that another popup appears saying "Please download and install .NET Core 2.0(remove any previous verison if you have)". Is the Azure Data Lake Tools not compatible with .NET Core higher than 2.0?

In a Mac M1 when I open the Azure Extension view. The Azure Data Lake Tools tool complains I get a prompt asking me to download and install .net core 2.

We should improve the detection code because this machine already has installed .net 6 and because .net core 2 is not supported on the mac anyway.

Also it seems this has been a neglected issue for a while #17 #20

Environment:
VS Code Environment:
Version: 1.72.0-insider
Commit: b9f7f85e90b4d51b38fcbf4232801ab04bd659cb
Date: 2022-09-23T08:15:07.186Z
Electron: 19.0.17
Chromium: 102.0.5005.167
Node.js: 16.14.2
V8: 10.2.154.15-electron.0
OS: Darwin arm64 21.6.0
Sandboxed: Yes

VS Code Extensions
Azure Data Lake Tools: v0.2.15

.net Environment
.net: 6.0.401

Operating System
macOS Monterrey 12.6
Macbook Air (M1, 2020)

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

I encountered

E_RUNTIME_SYSTEM_CODEGENFAILURE: .NET Framework 4.6 or later is not installed Description: A system failure has occurred during code generation. Resolution: Please contact support. Compilation failed with return value -1

when I was simply running the example here https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-data-lake-tools-for-vscode

I am sure I do have a .NET Framework 4.8 installed in my computer. Anyone knows what's going on?

"Create EXTRACT Script" doesn't seem to support any delimiters other than , ; & tab space. Wish there was a way I can use a pipe delimiter

In U-SQL project, when declaring Variable in U-SQL script, Intellisense reports an error
Intellisense: E_CSC_USER_INVALIDCSHARP: C# error CS0234: The type or namespace name 'Interfaces' does not exist in the namespace 'Microsoft.Analytics' (are you missing an assembly reference?)
![intellisense_e_csc_user_invalidcsharp_cs0234]
Following code presents an issue:
DECLARE @in1 string = "/sample/path/file.csv";
This is the script:
(https://user-images.githubusercontent.com/35380086/34890443-38d9b390-f7d2-11e7-9b0f-b3a59fcc8120.png)

"bool" is not highlighted as a type keyword.
U-SQL keywords are case-sensitive, but something like
"from"(not uppercase) is highlighted as keyword by mistake.

Right now repository is not used as it should be. I mean repository should contain a source code for the extension, so people could contribute to it.

My setup:

• Windows 10 1709
• vs code 1.22.1
• adl extension 0.2.11

To repro:

• install ADL extension from fresh
• reload vs code
• execute 'adl: start u-sql scripting' command
• accept EULA
• wait for binaries to download
• execute 'adl: start local run service' command
• from local run service console, hit 3, type path to local folder, hit enter
• from vs code test usql script (opened via 'adl: start u-sql scripting') execute 'adl: compile script'

enabling this means that the standard mssql colorizer no longer works for .sql files

e.g. with enabled

disabled

please fix

This extension uses version 0.0.11 of vscode-extension-telemtetry module.

The latest version of vscode-extension-telemtetry module (0.1.0) uses the latest version of applicationinsights module (1.0.6) which has the fix to prevent unnecessary patching of the require and other 3rd party modules.

For more details, please see microsoft/vscode-extension-telemetry#16

From @maikgroenewegen on January 15, 2018 8:46

• VSCode Version: 1.19.2
• OS Version: MacOS 10.13.2

Steps to Reproduce:

1. Installed the Azure Data Lake extension
2. Execute ADL: Login brings up binary dependencies messages
   3: Output shows:

[Debug] VSCode MachineId:b168731534c31d7701d568f1cff5de68fad64fa92654d8c11a6c06be6af911dd
[Info] Installing compilehost-0.0.6.tar.gz to /Users//.vscode/extensions/usqlextpublisher.usql-vscode-ext-0.2.8/compilehost
[Info] Attempting to download https://go.microsoft.com/fwlink/?linkid=862386
[Info] Installing reference-0.0.1.tar.gz to /Users//.vscode/extensions/usqlextpublisher.usql-vscode-ext-0.2.8/reference
[Info] Attempting to download https://go.microsoft.com/fwlink/?linkid=834604
[Info] Installing scopecompiler-0.0.8-mono.tar.gz to /Users//.vscode/extensions/usqlextpublisher.usql-vscode-ext-0.2.8/scopecompiler-mono
[Info] Attempting to download https://go.microsoft.com/fwlink/?linkid=859945
[Info] Installing DataLakeConsoleAppForDotNet-0.0.3-mono.tar.gz to /Users//.vscode/extensions/usqlextpublisher.usql-vscode-ext-0.2.8/DataLakeConsoleAppForDotNet-mono
[Info] Attempting to download https://go.microsoft.com/fwlink/?linkid=865110

4. Install does not continue
5. Developer Tools shows:
   [msazurermtools.azurerm-vscode-tools]Cannot read property 'indexOf' of null
   e.$onExtensionRuntimeError @ /Applications/Visual Studio Code.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:4056
   /Applications/Visual Studio Code.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:4056 TypeError: Cannot read property 'indexOf' of null
   at Function.CorrelationContextManager.patchError.AppInsightsAsyncCorrelatedErrorWrapper.orig.prepareStackTrace

Does this issue occur when all extensions are disabled?: Yes/No

Copied from original issue: microsoft/vscode#41610

Why I need to login even only play with Local Run?

Hi, I'm on the VS Code team. I noticed that your extension uses the vscode.previewHtml command which is deprecated and which we are actively working to remove: microsoft/vscode#62630

We've developed a webview API that provides a much better developer experience and offers a number of important security and compatibility benefits over previewHtml. We cannot fix previewHtml without breaking backwards compatibility, and have instead opted to remove it.

To ensure that your extension continues to work properly in VS Code, please try upgrading to use the new Webview API. You can find documentation on the API usage here. Let me know if you have any questions or concerns about this migration

I'm having trouble using this extension as I am unable to login using the "ADL Login" command. For some reason. I keep getting the below error:

I do have the latest .Net Core SDK and runtimes installed.
Please can anyone suggest a solution?