Tuesday, October 21, 2014

Content databases contain orphaned items. 'proc_SecRepairOrphanRoleAssignments'

 Content databases contain orphaned items. 'proc_SecRepairOrphanRoleAssignments'  

Issue : having an issue with the health analyzer rule 'Content databases contain orphaned items’. It seems to be no longer able to run without causing a rule execution failure and showing up under review problems and solutions. Content databases contain orphaned items. 

Error in Health Analyzer:

0 - Rule Execution Failure  


Procedure or function 'proc_SecRepairOrphanRoleAssignments' expects parameter '@fix', which was not supplied.

Enabling automatic repair for this rule will delete the orphaned items. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142694".

Cause: The issue seems to be the bug from April CU 2014 for SharePoint 2013.

Solution: The fix for the issue available with the Sept-CU 2014 released for SharePoint 2013.

Install the Sept-CU to fix the issue. Download the CU from below link.


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.