SharePoint Calculated Column: How to fix “failed to save modifications to the server” error while creating the calculated column?

No comments

 2,983 total views,  8 views today

While creating the calculated column in SharePoint, sometimes we may get the below error:

Failed to save modifications to the server. Error returned: ‘An unexpected error occurred (file ‘tmmdmodeltm.cpp’, line LineNumber, function ‘MDModelTM::CreateHierIterRequest’).

In this post, I will show how to fix “failed to save modifications to the server” error while creating the calculated column.

The root cause of the error:

Assume that you use a database with a compatibility level set to 1200 in Microsoft SQL Server 2016 Analysis Service (SSAS 2016) tabular model. When you process a table that has calculated columns or calculated tables, you may fail to save your modifications to the server and receive an error message that resembles the following:

Resolution:

This issue is fixed in the following cumulative update for SQL Server:

Cumulative Update 3 for SQL Server 2016 SP1

References:

https://support.microsoft.com/en-us/help/4018955/fix-error-when-you-process-a-calculated-column-on-a-database-with-comp

Summary:

Thus, in this troubleshooting technique, we have learned about how to fix t “failed to save modifications to the server” error while creating the calculated column in SharePoint.

See Also:

 

Free download SharePoint Online & Office 365 Administration eBook(238 Pages)

Get the PDF eBook from here:


 
FREE DOWNLOAD

Send download link to:

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.