Cannot Create Calculated Column

Category: sharepoint 2013 development and programming

Question

Joooools on Fri, 04 Oct 2019 10:47:26


When I try to create a new column of type 'Calculated (calculation based on other columns)', as soon as I click the radio button for Calculated I get the error 'An unexpected error has occurred'. I have checked the log for the correlation ID and can see the following:

10/04/2019 11:17:26.83  w3wp.exe (0x1D44)                        0x4450 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (GET:http://sypa-sharepoint:80/sypa/_layouts/15/fldnew.aspx?Web=1&FieldTypeParam=Calculated&DisplayNameParam=testcalc&DescriptionParam=&GroupNameParam=Custom%20Columns&VldFormulaParam=&VldMessageParam=) 30870a9f-fae2-c060-1a3d-845ab6a11975
10/04/2019 11:17:26.83  w3wp.exe (0x1D44)                        0x4450 SharePoint Foundation          Authentication Authorization   agb9s Medium   Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|syja2000\p500, ClaimsCount=42 30870a9f-fae2-c060-1a3d-845ab6a11975

Can someone shed some light on this for me please?

Thanks


J Sykes

Replies

Habibur Rahaman on Sat, 05 Oct 2019 09:50:42


Hi J Skyes,

Can you check what is the database compatibility in SQL? Database with compatibility level set to 1200 - we cannot create a calculated column, when we try to create calculated column and save button we will get the error like "

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

Please refer the below Microsoft document for this to fix:

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

 

Lee__li on Mon, 07 Oct 2019 02:46:24


Hi,

Does Habibur’s reply helpful? You could mark the helpful post as answer so it would help others find helpful information quickly.

If you need further help, it would be better to provide more details for ULS log for troubleshooting.

Best Regards,

Lee

Joooools on Tue, 08 Oct 2019 10:18:09


Hi

Thanks for the reply.  We are running on SQL Server 2014 (SP3) and the compatibility level is 120 so I don't think this issue applies to our config.  Do you have any other possible solutions please.

Thanks

Lee__li on Thu, 10 Oct 2019 07:51:33


Hi ,

Could you share more detailed correlation ID related information of ULS log when you creating calculated column so we could try to research.

Best Regards,

Lee

Joooools on Thu, 10 Oct 2019 07:56:24


I'm afraid that's all the information that was available in the log.

Joooools on Thu, 10 Oct 2019 10:31:00


I have some further information on this....

I can create a calculated column at the very top level of my site collection, but I get the error when creating one on a sub site and within a Content Type in a sub site. However, I can create one directly on a list in a sub site.

I have also looked at some calculated columns that have been created previously in a sub site and they are now corrupt  - 'an unexpected error has occurred' when I try to edit them. 

Thank you.

Lee__li on Fri, 11 Oct 2019 08:02:39


Hi,

The error is too general, need more detailed information for researching.

Best Regards,

Lee

Joooools on Thu, 24 Oct 2019 13:58:48


The only information I get from the logs is shown in my initial post. There is nothing else I can tell you, this is why I'm finding it difficult to diagnose myself and so I'm looking for suggestions.

I hope someone can give me some ideas.

Thanks