"parameter name already exists" while trying to Process Database on Azure Analysis Services in SSMS
If I try to Process Database in SQL Management Studio on either of my computers, I get the error:
"parameter name already exists",
"Parameter name: name (Microsoft.AnalysisServices.BackEnd).
It seems to be an error returning from the AAS server itself (it happens in SSMS 2017 version 17.3 two different PCs (Windows 8.1 and Windows 10 1703)).
Oddly, I can still successfully process the database if I run the refresh XMLA script above in SQL Management Studio or if I choose to process default or full under "Processing Option" in SSDT.
I have tried deleting the database and redeploying, I have tried creating a new Resource Group and deploying new AAS server and redploying model and still no luck!
I have noticed that the error occurs when my connection type is Active Directory - Universal with MFA Support, and the error does not occur if I connect using Active Directory - Password.
Upvotes: 1<=-=Nov 29 2017 7:17AM=-=>
Thank you for your feedback. I understand the issue and will investigate a fix. For now, please try one of the workarounds.
Kelly, Joe (Naas) commented
I too am getting the same error now :(
Srini Velamakanti commented
Still the same, any update on the fix?
yuvaraj mani commented
The issue still exist, when I shift to active directory password , I was able to process the data. Doesn't seem to work if I have logged in with MFA authentication
Aaron Giust commented
This is happening to me when processing individual tables in an Azure Analysis Services model using SSMS v18.4. It does not happen on SSMS v17.9.1.
Naveen Kuppili commented
Any update on this issue?