error when running xmla on a azure analysis model

Question

sakuraime 2,336

Apr 20, 2022, 3:01 PM

I would like to use ssms to run a xmla script on a model (which add a column to a table), however i see the following error:

what should I do ?
I am already server admin

sakuraime 2,336 Reputation points

Apr 21, 2022, 12:21 PM

anyone has the idea ?
PRADEEPCHEEKATLA 90,576 Reputation points

Apr 21, 2022, 1:49 PM

Hello @sakuraime ,

Thanks for the question and using MS Q&A platform.

Could you please help with the SSMS version which you have installed? And also click on copy message and share here.

Meanwhile you can checkout the known issue with SSMS: Release notes for SQL Server Management Studio (SSMS)
sakuraime 2,336 Reputation points

Apr 21, 2022, 4:56 PM

it's 18.10 version
PRADEEPCHEEKATLA 90,576 Reputation points

Apr 22, 2022, 4:09 AM

Hello @sakuraime ,

Could you please try the below workaround and do let us know how does it goes?

Uninstalling and reinstalling SQL Server Management Studio. If not solved by reinstallation, close all instances of SSMS, backup and then remove %AppData%\Microsoft\SQL Server Management Studio and %LocalAppData%\Microsoft\SQL Server Management Studio.
sakuraime 2,336 Reputation points

Apr 22, 2022, 5:24 PM

amm.. ok . will need to try .

is it a bug ?

or install new version would work ?

1 answer

sakuraime 2,336 Reputation points

Apr 21, 2022, 12:21 PM

anyone has the idea ?
PRADEEPCHEEKATLA 90,576 Reputation points

Apr 21, 2022, 1:49 PM

Hello @sakuraime ,

Thanks for the question and using MS Q&A platform.

Could you please help with the SSMS version which you have installed? And also click on copy message and share here.

Meanwhile you can checkout the known issue with SSMS: Release notes for SQL Server Management Studio (SSMS)
sakuraime 2,336 Reputation points

Apr 21, 2022, 4:56 PM

it's 18.10 version
PRADEEPCHEEKATLA 90,576 Reputation points

Apr 22, 2022, 4:09 AM

Hello @sakuraime ,

Could you please try the below workaround and do let us know how does it goes?

Uninstalling and reinstalling SQL Server Management Studio. If not solved by reinstallation, close all instances of SSMS, backup and then remove %AppData%\Microsoft\SQL Server Management Studio and %LocalAppData%\Microsoft\SQL Server Management Studio.
sakuraime 2,336 Reputation points

Apr 22, 2022, 5:24 PM

amm.. ok . will need to try .

is it a bug ?

or install new version would work ?

Answer 1

PRADEEPCHEEKATLA 90,576

Apr 25, 2022, 5:45 AM

It's looks like a known issue with 18.10 version.

You can give a try to install new version. In case, if that doesn't work we can log a bug with the product.