question

NamaSrikanth-3814 avatar image
NamaSrikanth-3814 asked ·

Unable to upgrade tabular level to compatibility level to 1500

We are in the midst of upgrading our tabular models compatibility level to 1500. They are currently on 1200 and they are on SSAS not Azure Analysis Services. We were successful in converting most of them to 1500 and deploy them.. However, we are not able to convert couple of them and getting an error when trying to deploy them. FYI, I was able to upgrade them to 1500, process & build successfully in VS2019 but not able to deploy to our Analysis server. I am getting the following error and as you can see the error is not telling much. Does anyone encountered similar problem has any idea(s) on how to resolve this issue?

Error :

 Failed to save modifications to the server. Error returned: ‘The operation cannot be performed because it references an object or property that is unavailable in the current edition of the server or the compatibility level of the database.’

Appreciate your input and help.

Thanks,
SN

azure-analysis-services
2 comments
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NamaSrikanth-3814 ,

Following up to see if you have got a chance to try updating the compatibility level manually in SSMS?


0 Votes 0 · ·

Hi @NamaSrikanth-3814 ,

Following up to see if you if the below suggestion was helpful to resolve your issue?

0 Votes 0 · ·
KranthiPakala-MSFT avatar image
KranthiPakala-MSFT answered ·

HI @NamaSrikanth-3814 ,


Thank you for reaching out. Could you please try updating the compatibility level manually in SSMS (with TMSL CreateOrReplace script) ?


Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SrikanthNAMA-9545 avatar image
SrikanthNAMA-9545 answered ·

Yes, it worked. But I was wondering why it(deploying) didn't work from VS but worked through SSMS.

1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @srikanthnama-9545,

Glad to know that your issue was resolved.
I suspect this could be an issue with VS SSDT where SSDT didn’t correctly figure out, that target server is still 1400 which pending to be upgraded.




Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.



0 Votes 0 · ·