azuredatastudio
azuredatastudio copied to clipboard
microsoft
Unable to add account
Issue Type: Bug
Unable to add account and it fails with error "no access token returned from microsoft oauth" username - [email protected]
Azure Data Studio version: azuredatastudio 1.38.0 (dff93c4736269ef2a7e8a225737a0d8354bf0246, 2022-07-26T17:24:38.381Z) OS version: Darwin x64 20.6.0 Restricted Mode: No
System Info
| Item | Value |
|---|---|
| CPUs | Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz (8 x 2800) |
| GPU Status | 2d_canvas: enabled gpu_compositing: enabled metal: disabled_off multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: disabled_off_ok video_decode: enabled webgl: enabled webgl2: enabled |
| Load (avg) | 2, 2, 3 |
| Memory (System) | 16.00GB (0.08GB free) |
| Process Argv | |
| Screen Reader | no |
| VM | 0% |
We need more info to debug your Azure Active Directory 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.
- In the settings menu, find the setting titled
Azure: Logging Leveland select theVerboseoption - Run the process that produces your error
- Open command palette (Click View -> Command Palette)
- Run the command:
Developer: Open Logs Folder - Follow this path to find the Azure Accounts log file:
[default log folder]/exthost1/output_logging_[earliest timestamp]/#-Azure Acounts.log - Please attach the Azure-Accounts.log file to the issue.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
@kburtram Followed above steps and attached the logs file above. Please check and let me know if any other info is required.
No access token returned from Microsoft OAuth
onDidChangeNotification @ workbench.desktop.main.js:1635
(anonymous) @ workbench.desktop.main.js:1635
fire @ workbench.desktop.main.js:137
addNotification @ workbench.desktop.main.js:1637
notify @ workbench.desktop.main.js:2419
(anonymous) @ workbench.desktop.main.js:2369
ZoneAwarePromise @ /Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:1340
_showMessage @ workbench.desktop.main.js:2369
$showMessage @ workbench.desktop.main.js:2369
_doInvokeHandler @ workbench.desktop.main.js:2378
_invokeHandler @ workbench.desktop.main.js:2378
_receiveRequest @ workbench.desktop.main.js:2378
_receiveOneMessage @ workbench.desktop.main.js:2378
(anonymous) @ workbench.desktop.main.js:2378
fire @ workbench.desktop.main.js:137
fire @ workbench.desktop.main.js:184
_receiveMessage @ workbench.desktop.main.js:184
(anonymous) @ workbench.desktop.main.js:184
fire @ workbench.desktop.main.js:137
acceptChunk @ workbench.desktop.main.js:184
(anonymous) @ workbench.desktop.main.js:184
k @ workbench.desktop.main.js:4048
emit @ events.js:315
addChunk @ internal/streams/readable.js:309
readableAddChunk @ internal/streams/readable.js:284
Readable.push @ internal/streams/readable.js:223
onStreamRead @ internal/stream_base_commons.js:188
workbench.desktop.main.js:854 ERR Cannot read property 'accountType' of undefined: TypeError: Cannot read property 'accountType' of undefined
at rl.renderElement (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:856:39117)
at rl.renderElement (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:856:39771)
at K.renderElement (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:264:1778)
at y.insertItemInDOM (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:246:18608)
at y._splice (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:246:14505)
at y.splice (vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:246:12767)
at vscode-file://vscode-app/Applications/Azure%20Data%20Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:67:67112
at Array.forEach (
thanks @BhavanaPilli11! @cssuh can you please take a look at the above error and provide a recommendation for possible workarounds?
Hi @BhavanaPilli11 have you been able to authenticate successfully in the past? Can you please try removing your account and re-adding it?
@cssuh I was never able to authenticate successfully and add the account in azure data studio. I don't have any accounts added.
@BhavanaPilli11 Can you try using Device Code Auth to get you unblocked for now? We'll continue looking into this issue.
Have never been able to authenticate. Already cleared account cache. Tried via Code Grant addition method and just got "Unidentified error with azure authentication".
ERR Cannot read property 'accountType' of undefined: TypeError: Cannot read property 'accountType' of undefined
at ll.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:856:39117)
at ll.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:856:39771)
at K.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:264:1778)
at w.insertItemInDOM (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:18608)
at w._splice (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:14505)
at w.splice (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:12767)
at vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:67:67112
at Array.forEach (
workbench.desktop.main.js:854 ERR An unknown error occurred. Please consult the log for more details.
Got this error while trying to add via device code. The loader just continues to spin after success in the browser
ERR Cannot read property 'accountType' of undefined: TypeError: Cannot read property 'accountType' of undefined
at ll.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:856:39117)
at ll.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:856:39771)
at K.renderElement (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:264:1778)
at w.insertItemInDOM (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:18608)
at w._splice (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:14505)
at w.splice (vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:246:12767)
at vscode-file://vscode-app/c:/Users/hollea/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:67:67112
at Array.forEach (
workbench.desktop.main.js:854 ERR An unknown error occurred. Please consult the log for more details.
workbench.desktop.main.js:149 [Extension Host] rejected promise not handled within 1 second: TypeError: Cannot read property 'write' of undefined b @ workbench.desktop.main.js:149 $logExtensionHostMessage @ workbench.desktop.main.js:2382 _doInvokeHandler @ workbench.desktop.main.js:2382 _invokeHandler @ workbench.desktop.main.js:2382 _receiveRequest @ workbench.desktop.main.js:2382 _receiveOneMessage @ workbench.desktop.main.js:2382 (anonymous) @ workbench.desktop.main.js:2382 fire @ workbench.desktop.main.js:137 fire @ workbench.desktop.main.js:184 _receiveMessage @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 fire @ workbench.desktop.main.js:137 acceptChunk @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 k @ workbench.desktop.main.js:4064 emit @ events.js:315 addChunk @ internal/streams/readable.js:309 readableAddChunk @ internal/streams/readable.js:284 Readable.push @ internal/streams/readable.js:223 onStreamRead @ internal/stream_base_commons.js:188
workbench.desktop.main.js:149 [Extension Host] stack trace: TypeError: Cannot read property 'write' of undefined at error (c:\Users\hollea\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\azurecore\dist\extension.js:2:674713) at processTicksAndRejections (internal/process/task_queues.js:93:5) b @ workbench.desktop.main.js:149 $logExtensionHostMessage @ workbench.desktop.main.js:2382 _doInvokeHandler @ workbench.desktop.main.js:2382 _invokeHandler @ workbench.desktop.main.js:2382 _receiveRequest @ workbench.desktop.main.js:2382 _receiveOneMessage @ workbench.desktop.main.js:2382 (anonymous) @ workbench.desktop.main.js:2382 fire @ workbench.desktop.main.js:137 fire @ workbench.desktop.main.js:184 _receiveMessage @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 fire @ workbench.desktop.main.js:137 acceptChunk @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 k @ workbench.desktop.main.js:4064 emit @ events.js:315 addChunk @ internal/streams/readable.js:309 readableAddChunk @ internal/streams/readable.js:284 Readable.push @ internal/streams/readable.js:223 onStreamRead @ internal/stream_base_commons.js:188
workbench.desktop.main.js:2887 [[object Object]]Cannot read property 'write' of undefined $onExtensionRuntimeError @ workbench.desktop.main.js:2887 _doInvokeHandler @ workbench.desktop.main.js:2382 _invokeHandler @ workbench.desktop.main.js:2382 _receiveRequest @ workbench.desktop.main.js:2382 _receiveOneMessage @ workbench.desktop.main.js:2382 (anonymous) @ workbench.desktop.main.js:2382 fire @ workbench.desktop.main.js:137 fire @ workbench.desktop.main.js:184 _receiveMessage @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 fire @ workbench.desktop.main.js:137 acceptChunk @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 k @ workbench.desktop.main.js:4064 emit @ events.js:315 addChunk @ internal/streams/readable.js:309 readableAddChunk @ internal/streams/readable.js:284 Readable.push @ internal/streams/readable.js:223 onStreamRead @ internal/stream_base_commons.js:188
workbench.desktop.main.js:2887 TypeError: Cannot read property 'write' of undefined at error (c:\Users\hollea\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\azurecore\dist\extension.js:2:674713) at processTicksAndRejections (internal/process/task_queues.js:93:5) $onExtensionRuntimeError @ workbench.desktop.main.js:2887 _doInvokeHandler @ workbench.desktop.main.js:2382 _invokeHandler @ workbench.desktop.main.js:2382 _receiveRequest @ workbench.desktop.main.js:2382 _receiveOneMessage @ workbench.desktop.main.js:2382 (anonymous) @ workbench.desktop.main.js:2382 fire @ workbench.desktop.main.js:137 fire @ workbench.desktop.main.js:184 _receiveMessage @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 fire @ workbench.desktop.main.js:137 acceptChunk @ workbench.desktop.main.js:184 (anonymous) @ workbench.desktop.main.js:184 k @ workbench.desktop.main.js:4064 emit @ events.js:315 addChunk @ internal/streams/readable.js:309 readableAddChunk @ internal/streams/readable.js:284 Readable.push @ internal/streams/readable.js:223 onStreamRead @ internal/stream_base_commons.js:188
@BhavanaPilli11 @aholler2 this is probably due to some proxy configuration, have you set the proxy configuration in ADS?
Hi @aholler2 , are your proxy variables configured as follows:
export http_proxy="http://userName@fqdn:[email protected]:8080"
export https_proxy="http://userName@fqdn:[email protected]:8080"
@cssuh Yes, they are both configured. They don't need authentication with username/password.
PS C:\Users\hollea> dir env:
Name Value
http_proxy http://proxy.mycompanydomain.com:80 https_proxy http://proxy.mycompanydomain.com:80
@aholler2 You also need to whitelist the following URLs:
https://management.azure.com/ https://login.microsoftonline.com/
you may need to whitelist additional URLs but this can sometimes vary on a case-by-case basis - in order to verify you aren’t blocking any URLs from going through, go to Help > Toggle Developer Tools and select the Network tab. Here you will see any URLs that are getting blocked that you may need to whitelist to successfully add your account.
Not able to repro, closing as there has been no activity. Please feel free to open a new issue or re-open this one if you are still seeing problems