wsus无法同步计算机,Windows Server Update Service（WSUS）到 Microsoft 更新同步失败

摘要

运行与 WSUS 集成的独立 WSUS 或 System Center Configuration Manager 时，软件更新同步可能会间歇性失败，而后续同步可能会成功。 你可能会看到以下一个或多个错误。

来自 wsyncmgr.log(Configuration Manager 站点服务器日志)的注释项：

MM/dd/YYYY HH:mm:ss PM Synchronizing WSUS server contoso1.contoso.com ...

MM/dd/YYYY HH:mm:ss PM sync: Starting WSUS synchronization

MM/dd/YYYY HH:mm:ss PM sync: WSUS synchronizing categories

MM/dd/YYYY HH:mm:ss PM sync: WSUS synchronizing updates

MM/dd/YYYY HH:mm:ss PM Caught exception: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WsysSyncFailedException: ImportUpdateError: ~~ at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncWSUS(SyncMode syncMode)~~ at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DoSync()

MM/dd/YYYY HH:mm:ss PM Sync done. Getting sync info...

MM/dd/YYYY HH:mm:ss PM Got sync info. NumSynced = 0

MM/dd/YYYY HH:mm:ss PM Sync failed: ImportUpdateError: . Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncWSUS

MM/dd/YYYY HH:mm:ss PM STATMSG: ID=6703 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=CONTOSO1.CONTOSO.COM SITE=NEW PID=3196 TID=7588 GMTDATE=Day Mon dd HH:mm:ss.ssss YYYY ISTR0="Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncWSUS" ISTR1="ImportUpdateError: " ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0

MM/dd/YYYY HH:mm:ss PM Sync failed. Will retry in 60 minutes

SoftwareDistribution.log 中的相应条目：

YYYY-MM-dd HH:mm:ss.sss UTC Error WsusService.42 CatalogSyncAgentCore.GetAndSaveUpdateMetadata 2 update(s) could not be imported into the local db even with retry

YYYY-MM-dd HH:mm:ss.sss UTC Error WsusService.42 CatalogSyncAgentCore.GetAndSaveUpdateMetadata Bad Update Revision #0: b55a761f-98c3-4e8f-be39-9dcfd35ceefc/201

YYYY-MM-dd HH:mm:ss.sss UTC Error WsusService.42 CatalogSyncAgentCore.GetAndSaveUpdateMetadata Bad Update Revision #1: e0dd10bf-612b-4524-b382-9655a5ee7d6e/200

YYYY-MM-dd HH:mm:ss.sss UTC Info WsusService.42 CatalogSyncAgentCore.UpdateSyncResultAndGenerateReportingEvent CatalogSyncThreadProcess: report subscription One or more updates failed to import to local database.

YYYY-MM-dd HH:mm:ss.sss UTC Info WsusService.42 EventLogEventReporter.ReportEvent EventId=386,Type=Error,Category=Synchronization,Message=Synchronization failed. Reason: System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'RevisionID', table '@AtLeastOneBundle'; column does not allow nulls. INSERT fails.

Error loading information from upd:BundledUpdates/upd:AtLeastOne/upd:UpdateIdentity for updateB55A761F-98C3-4E8F-BE39-9DCFD35CEEFC\201. Some updaterevisions in bundle information are not already present in the database.

WSUS 控制台中的同步检查将显示状态为“已成功”和“已失败”的结果：

已失败的同步可能类似于以下内容(双击屏幕中的失败项以打开同步报告)：