Hi All, Having a WSUS Sync issue for last few days, anyone got any ideas?
SCCM 2007 SP2 R2 on W2K3 (its an old server that is only used for patching a small set of machines in a legacy forest). I've already tried: Deleting SUP\reinstall wsus Deleting SUP and deinstalling WSUS totally. Installing SUP, then WSUS - let it do a full sync over many hours. The KB it keeps failing on, we dont even need, tried deselect Service Packs\Office 2013 updates (which its under) but still syncs. Been through the "Troubleshooting Software Updates Synchronization Failures" technet page - http://technet.microsoft.com/en-us/library/bb735874.aspx Section - Wsyncmgr.log Shows Error 12 and Invalid Schema If you see the following entries in the wsyncmgr.log, there is a problem with SQL Server: sp_SetupSDMPackage returns an error DCM digest has invalid schema Possible Solution Restart the SQL Server service. << --Tried this, tried restarting the server too. Eventvwr lists Event Type: Error Event Source: SMS Server Event Category: SMS_WSUS_SYNC_MANAGER Event ID: 6703 Date: 21/03/2014 Time: 06:43:05 User: N/A Computer: ServerName Description: On 21/03/2014 06:43:05, component SMS_WSUS_SYNC_MANAGER on computer ServerName reported: SMS WSUS Synchronization failed. Message: Failed to sync some of the updates. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WSyncAction.WSyncAction.SyncUpdates. The operating system reported error 2148734464: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. wsusctrl.log shows no issues. Error during sync, wsyncmgr.log reports sync: SMS synchronizing updates, processed 16300 out of 16797 items (97%) SMS_WSUS_SYNC_MANAGER 21/03/2014 06:28:43 4596 (0x11F4) sync: SMS synchronizing updates, processed 16400 out of 16797 items (97%) SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:00 4596 (0x11F4) sync: SMS synchronizing updates, processed 16500 out of 16797 items (98%) SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:17 4596 (0x11F4) Synchronizing update 4546e0b9-9e23-4a36-9535-6a60d1076a49: *Service Pack 1 for Microsoft SharePoint Server 2013 (KB2850035) *SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:20 4596 (0x11F4) *sp_SetupSDMPackage returns an error 12 * SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:56 4596 (0x11F4) *DCM digest has invalid schema* SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:56 4596 (0x11F4) Failed to sync update 4546e0b9-9e23-4a36-9535-6a60d1076a49. Error: Failed to create SDM package Site_A3351862-439D-40C1-9E88-A3B250E156BF/SUM_4546e0b9-9e23-4a36-9535-6a60d1076a49(1). CSDMTypeSource error: 12. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate SMS_WSUS_SYNC_MANAGER 21/03/2014 06:29:56 4596 (0x11F4) Then carrys on to 99% and... sync: SMS synchronizing updates, processed 18100 out of 18133 items (99%) SMS_WSUS_SYNC_MANAGER 21/03/2014 06:41:55 4596 (0x11F4) Sync failures summary: SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:04 4596 (0x11F4) Sync failures summary: SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:04 4596 (0x11F4) Failed to sync update 4546e0b9-9e23-4a36-9535-6a60d1076a49. Error: Failed to create SDM package Site_A3351862-439D-40C1-9E88-A3B250E156BF/SUM_4546e0b9-9e23-4a36-9535-6a60d1076a49(1). CSDMTypeSource error: 12. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:04 4596 (0x11F4) Sync failed: Failed to sync some of the updates. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WSyncAction.WSyncAction.SyncUpdates SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:05 3464 (0x0D88) STATMSG: ID=6703 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=CORSHWDSSMS03 SITE=P00 PID=10180 TID=3464 GMTDATE=Fri Mar 21 06:43:05.052 2014 ISTR0="Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WSyncAction.WSyncAction.SyncUpdates" ISTR1="Failed to sync some of the updates" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:05 3464 (0x0D88) Sync failed. Will retry in 60 minutes SMS_WSUS_SYNC_MANAGER 21/03/2014 06:43:05 3464 (0x0D88) Then Repeats over and over again. Thanks in advance.
