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:
Severity
0 - Rule Execution Failure
Category
Availability
Explanation
Procedure or function 'proc_SecRepairOrphanRoleAssignments' expects parameter '@fix', which was not supplied.
Remedy
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.
http://expertsharepoint.blogspot.de/2014/09/september-2014-cu-for-sharepoint-2013.html
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.