Failed to save modifications to the server. Error returned: 'An unexpected exception occurred. '.

Question

Hi, I get the same error as https://social.msdn.microsoft.com/Forums/en-US/2104c941-27b1-41ba-b533-9e89fa582b41/tabular-2019-compatibility-level-1500-unable-to-process-table-or-deploy?forum=sqlanalysisservices

Which is : Failed to save modifications to the server. Error returned: 'An unexpected exception occurred. '.

My question is, I have the version 15.0.32.50 Will upgrading to 15.0.34.1 fix it? ( https://support.microsoft.com/en-us/help/4536075/kb4536075-cumulative-update-2-for-sql-server-2019 )

ps: it took me long to find that post, because the error is posted as an image. Just to be clear and make this searchable, the entire error description I receive is: "Failed to save modifications to the server. Error returned: 'An unexpected exception occurred. '" this is the message that appears through the GUI after clicking "Process database"

Answer 1

Hi,

Seems from other user's experience , this error should be fixed with SQL Server 2019 CU2 - 15.0.34.1 . (The lasted post in the thread you post.)

Further more, since you have the SQL Server RTM version, I would suggest to your to upgrade to latest CU, that is Cumulative Update 8 for SQL Server 2019 . These updates contain several updates and fixes, I highly recommend to upgrade it.

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Hi,

You could search for key DAX functions words for the calculation group, i.e. , in the text file search for SELECTEDMEASURE , SELECTEDMEASURENAME, ISSELECTEDMEASURE , SELECTEDMEASUREFORMATSTRING.
If one of this function is contained , that means calculation group is used,
How they work
Regards,
Lukas

Answer 3

Hi, thanks for your input. Apparently this happens when using newer stuff like CALCULATION GROUPS.

I want to be 100% sure that upgrading to 15.0.34.1 will fix it...

I have one model that works and other that doesn't. If I open the .bim file as a text file, how can I search for newer stuff used like 'CALCULATION GROUPS.'?

(if I find any newer feature used in the one that doesn't work that would confirm that the issue comes from not upgrading).