Failed to save modifications to the server error in SharePoint calculated column – SharePoint 2016

Failed to save modifications to the server: Error returned: while creating the SharePoint calculated column, 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 the “failed to save modifications to the server” error while creating the calculated column.

The root cause of the error: Failed to save modifications to the server

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: Failed to save modifications to the server

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: Failed to save modifications to the server

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: SharePoint Online PowerShell

You may also like the below SharePoint Online PowerShell tutorials:

• Office 365: Getting started with SharePoint PnP PowerShell – installation
• In 2 steps convert a classic SharePoint page to modern using PnP
• Office 365: Retrieve hub sites and associated sites using PnP Powershell
• Create a modern team site using PnP PowerShell in SharePoint
• In 4 steps access SharePoint online data using postman tool
• SharePoint admin center: Learn SharePoint online administration in an hour – step by step
• SharePoint REST API: GET vs POST vs PUT vs DELETE vs PATCH
• Office 365: Understanding the hub site in SharePoint online

Buy SharePoint Online & Microsoft 365 Administration eBook

Download SharePoint Online & Office 365 Administration eBook

Buy the premium version of SharePoint Online & Office 365 administration eBook from here:

 

Get the free demo PDF eBook from here:

FREE DOWNLOAD

Send download link to:

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

About Post Author

SP Doctor

I am your SharePoint and Power Platform doctor and guide. Sharing knowledge with my fellow colleagues, friends, and the tech community makes me utmost happy in my job.

See author's posts