Cannot change item-level permissions because this list or document library contains a column that enforces unique values - SharePoint 2010

User wanted to make some permission level changes on the survey. So that Users can read or edit only their surveys.

We went to the advanced settings. Tried to change it to

We got an error

"Cannot change item-level permissions because this list or document library contains a column that enforces unique values"

We then tried researching and then found that one column "Title"

had that option set to yes as below

We tried to make some changes in the same column from choice to single line of text and enforce unique values to no

However we got one more error.

"The type of this column cannot be changed because it is currently being indexed”

Ahhh... Now we first took a backup of the survey list.

We then created a new column which worked fine. Then deleted the Title Column

And we were able to make the changes.

We were able to now make the changes in the advanced settings. As there was only one column which had that option checked.

Product applies to:

SharePoint Server 2010

SharePoint Foundation 2010

SHAREPOINT DESIGNER START APPROVAL PROCESS ISSUE

Environment entities:

-Windows server 2008 R2

-SQL server 2008

-SharePoint Server 2010 with SP1

-Client: Windows 7 + IE7.0

Problem Description: In SharePoint designer 2010, whenever I use the “Start Approval Process” action on new or existing workflows and try to publish it, it’s throwing the following error.

Error Message#1: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)

Checked the SharePoint logs and found the following error:

Error Message#2: Errors were found when compiling the workflow. The workflow files were saved but cannot be run.

Right from the beginning Microsoft is playing a very important role in publishing knowledge base article which are very useful for the whole community.

Resolution: http://support.microsoft.com/kb/2557533

As per this article, we can increase this default value to 7000 by using the following command:

$app = get-spwebapplication http://portal.sharepoint2010.com

$app.UserDefinedWorkflowMaximumComplexity = 7000

$app.Update ()

Again the best practices are saying we need to take every step by considering the farm performance as the maximum limit is 10000 and you cannot increase more than that so it’s better if we restructure our workflows with respect to reusability.

If you have any queries/questions regarding the above mentioned information then please let me know. If you have any additional resolution or valuable inputs which would be useful for the whole SharePoint community then please share…

Thank you.