SharePoint Log - [MissingFeature] Database [SharePoint_Content] has reference(s) to a missing

原文参见：http://get-spscripts.com/2011/06/removing-features-from-content-database.html

Error Message:

[MissingFeature] Database [SharePoint_Content_Portal] has reference(s) to a missing feature: Id = [8096285f-1463-42c7-82b7-f745e5bacf29], Name = [My Feature], Description = [], Install Location = [Test-MyFeature]. The feature with Id 8096285f-1463-42c7-82b7-f745e5bacf29 is referenced in the database [SharePoint_Content_Portal], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary.

从错误信息中可以看出，名为“SharePoint_Content_Portal”的数据库中的一个feature，并没有安装在SharePoint farm中或者曾经安装过，但是已经被移除了。通常情况下，在移除solution的时候，会自动禁用feature，然后再移除solution，但是有些情况下，移除得并不干净，例如web application 级别的feature，或者没有移除自定义的event receiver或者webpart等等。

下面的powershell可以解决这个问题。

function Remove-SPFeatureFromContentDB($ContentDb, $FeatureId, [switch]$ReportOnly)
{
    $db = Get-SPDatabase | where { $_.Name -eq $ContentDb }
    [bool]$report = $false
    if ($ReportOnly) { $report = $true }
    
    $db.Sites | ForEach-Object {
        
        Remove-SPFeature -obj $_ -objName "site collection" -featId $FeatureId -report $report
                
        $_ | Get-SPWeb -Limit all | ForEach-Object {
            
            Remove-SPFeature -obj $_ -objName "site" -featId $FeatureId -report $report
        }
    }
}

function Remove-SPFeature($obj, $objName, $featId, [bool]$report)
{
    $feature = $obj.Features[$featId]
    
    if ($feature -ne $null) {
        if ($report) {
            write-host "Feature found in" $objName ":" $obj.Url -foregroundcolor Red
        }
        else
        {
            try {
                $obj.Features.Remove($feature.DefinitionId, $true)
                write-host "Feature successfully removed from" $objName ":" $obj.Url -foregroundcolor Red
            }
            catch {
                write-host "There has been an error trying to remove the feature:" $_
            }
        }
    }
    else {
        #write-host "Feature ID specified does not exist in" $objName ":" $obj.Url
    }
}

有两种方法使用以上代码，

1. 如果你只是想查找哪些站点或者站点集中包含缺失的feature，使用如下方法：

Remove-SPFeatureFromContentDB -ContentDB "SharePoint_Content_Portal" -FeatureId "8096285f-1463-42c7-82b7-f745e5bacf29" –ReportOnly

这个方法会遍历所有的站点，列出类似以下的内容：

Feature found in site : http://portal/site

2. 如果你想从数据库中移除缺失的feature，可以使用下面的方法：

Remove-SPFeatureFromContentDB -ContentDB "SharePoint_Content_Portal" -FeatureId "8096285f-1463-42c7-82b7-f745e5bacf29"

这个方法会输出类似如下的信息：

Feature successfully removed from site : http://portal/site