SharePoint 2013 Troubleshooting: Content databases contain orphaned items

  • Article

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.

The Full Server Packages for September 2014 CU are available through the following links:

  1. Download SharePoint Foundation 2013 September 2014 CU
  2. Download SharePoint Server 2013 September 2014 CU
  3. Download Project Server 2013 September 2014 CU

Note:

  1. Be aware that all updates for SharePoint 2013 require SharePoint Server 2013 SP1 OR March 2013 PU for SharePoint 2013 to be installed first.
  2. Previous releases of the SharePoint Server 2013 cumulative update included both the executable and the .CAB file in the same self-extracting executable download. Because of the file size, the SharePoint Server 2013 package has been divided into several separate downloads. One contains the executable file, while the others contain the CAB file. All are necessary and must be placed in the same folder to successfully install the update. All are available by clicking the same Hotfix Download Available link in the KB article for the release. 
  3. After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.
  4.  Be aware that the SharePoint Server 2013 CU contains the SharePoint Foundation CU. And the SharePoint Server 2013 with Project Server CU contains Project Server CU, SharePoint Server CU and SharePoint Foundation CU.