修复 SharePoint 2013 迁移中 Test-SPContentDatabase 的“MissingAssembly”错误

问题：
在 SharePoint 2013 迁移期间，我们运行 Test-SPContentDatabase cmdlet，并且输出报告包含多个 MissingAssembly 错误！

类别 : MissingAssembly
错误 : True
UpgradeBlocking : False
消息 : Assembly [DealEventEventhandler, Version=1.2.6.0, Culture=neutral, PublicKeyToken=b4122bae67581526]在数据库 [wss_content] 中引用，但未安装在当前场上。请安装包含此程序集的任何功能/解决方案。
补救措施 ：数据库 [wss_content] 中引用了一个或多个程序集，但未安装在当前场中。请安装包含这些程序集的任何功能或解决方案。

根本原因：
通常，MissingAssembly 错误发生在未安装和部署到场且仍在 SharePoint 列表或库中引用的事件接收器上！

解决方案：

将包含缺少程序集的缺少功能/解决方案安装到您的 SharePoint 场！很简单吧？但是等等，您可能并不总是能够执行此操作，有时您可能会继续从 SharePoint 中查找并删除丢失的程序集。

查找引用丢失程序集的所有位置并使用 PowerShell 删除：

让我们使用 PowerShell 查找正在使用特定程序集的所有位置并将其删除。该程序集可以作为 SharePoint 事件接收器的一部分。根据 Test-SPContentDatabase 结果在脚本中设置配置参数。

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

Function Run-SQLScript($SQLServer, $SQLDatabase, $SQLQuery)
{
    $ConnectionString = "Server =" + $SQLServer + "; Database =" + $SQLDatabase + "; Integrated Security = True"
    $Connection = new-object system.data.SqlClient.SQLConnection($ConnectionString)
    $Command = new-object system.data.sqlclient.sqlcommand($SQLQuery,$Connection)
    $Connection.Open()
    $Adapter = New-Object System.Data.sqlclient.sqlDataAdapter $Command
    $Dataset = New-Object System.Data.DataSet
    $Adapter.Fill($Dataset) 
    $Connection.Close()
    $Dataset.Tables[0]
}

#Define configuration parameters
$Server="Abj-SQL-001"
$Database="WSS_Content_KM"
$AssemblyInfo="DealEventHandler, Version=1.2.6.0, Culture=neutral, PublicKeyToken=d256f51c842671b3"           

#Query SQL Server content Database to get information about the MissingAssembly
$Query = "SELECT distinct Id, SiteId, WebId, HostId, HostType from EventReceivers where Assembly = '"+$AssemblyInfo+"'"
$QueryResults = Run-SQLScript -SQLServer $Server -SQLDatabase $Database -SQLQuery $Query # | select Id, Name, SiteId, WebId, HostId, HostType

#Iterate through results
foreach ($Result in $QueryResults)
{
    if($Result.id -ne $Null)
    {
        #Get the location where the event receiver is referred
        if ($Result.HostType -eq 0) #Site Event Receiver
        {
            $Site = Get-SPSite -Limit all | where {$_.Id -eq $Result.SiteId}
            $EventReceiver = $Site.EventReceivers | where {$_.Id -eq $Result.Id}
            #To Delete the Event Receiver
            #$EventReceiver.Delete()
            write-host "Site Event Receivers Found at $($Site.URL)" -foregroundcolor green
        }
        if ($Result.HostType -eq 1) #Web Event Receiver
        {
            $Site = Get-SPSite -Limit all | where {$_.Id -eq $Result.SiteId}
            $Web = $Site | Get-SPWeb -Limit all | where { $_.Id -eq $Result.WebId }
            $EventReceiver = $Web.EventReceivers | where {$_.Id -eq $Result.Id}
            #To Delete the Event Receiver
            #$EventReceiver.Delete()
            write-host "Web Event Receivers Found at $($web.URL)" -foregroundcolor green
        }
        if ($Result.HostType -eq 2) #List Event Receiver
        {
            $Site = Get-SPSite -Limit all | where {$_.Id -eq $Result.SiteId}
            $Web = $Site | Get-SPWeb -Limit all | where { $_.Id -eq $Result.WebId }
            $List = $web.Lists | where {$_.Id -eq $Result.HostId}
            $EventReceiver = $List.EventReceivers | where {$_.Id -eq $Result.Id}
            #To Delete the Event Receiver
            #$EventReceiver.Delete()
            write-host "List Event Receivers Found at $($web.url)/$($List.RootFolder.Url)" -foregroundcolor green
        }
    }
} 

该脚本查找引用特定程序集的所有位置。取消注释 EventReceiver.delete() 行以删除事件接收器。

这是另一篇文章，用于解决 SharePoint 2010 到 SharePoint 2013 迁移中的程序集缺失错误 修复 SharePoint 迁移中的“缺失事件接收器”问题