none
Microsoft August Patches Synchronization RRS feed

  • Question

  • Hello,

    SCCM 1906

    During the monthly synchronization several errors are logged in wsyncmgr.log and repeating each hour since yesterday...

    Synchronizing update 490dea5d-cc7c-4965-9254-b6291882fd2e - Microsoft .NET Framework 4.7.2 for Windows 7 for x64 (KB4054530) SMS_WSUS_SYNC_MANAGER 8/13/2019 9:16:26 PM 21704 (0x54C8)

    Synchronizing update 490dea5d-cc7c-4965-9254-b6291882fd2e - Microsoft .NET Framework 4.7.2 for Windows 7 for x64 (KB4054530)	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:26 PM	21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914848, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:27 PM	21704 (0x54C8)
    *** [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. : sp_SetupCI	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:27 PM	21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914848, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:27 PM	21704 (0x54C8)
    *** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 2627, Level 14, State 1, Procedure tr_vCI_ContentFiles_upd, Line 17, Message: Violation of UNIQUE KEY constraint 'CI_Files_AK'. Cannot insert duplicate key in object 'dbo.CI_Files'. The duplicate key value is (SHA1:BCC5A1D0E9AFEC8C01C745F7B88F511A3269BC21, windows6.1-kb4019990-x64.cab, 0x8ddfabc5ffd149ebdd0885c3732648e0262af9c8). : spRethrowError	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:27 PM	21704 (0x54C8)
    Failed to sync update 490dea5d-cc7c-4965-9254-b6291882fd2e. Error: Failed to save update 88a1c71a-5210-4ab9-95b7-a3b7fcc066af. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:27 PM	21704 (0x54C8)
    Synchronizing update 62f28bd3-d612-46bc-acee-cc43abbdaf55 - Microsoft .NET Framework 4.7.2 for Windows Server 2012 for x64 (KB4054542) SMS_WSUS_SYNC_MANAGER 8/13/2019 9:16:28 PM 21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914996, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:28 PM	21704 (0x54C8)
    *** [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. : sp_SetupCI	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:28 PM	21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914996, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:28 PM	21704 (0x54C8)
    *** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 2627, Level 14, State 1, Procedure tr_vCI_ContentFiles_upd, Line 17, Message: Violation of UNIQUE KEY constraint 'CI_Files_AK'. Cannot insert duplicate key in object 'dbo.CI_Files'. The duplicate key value is (SHA1:20718782BE358BC6DF6533E41A06B7ED6871240D, windows8-rt-kb4019990-x64.cab, 0x3d3fd16f0390af3f8adefd32e90aa8963344e544). : spRethrowError	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:28 PM	21704 (0x54C8)
    Failed to sync update 62f28bd3-d612-46bc-acee-cc43abbdaf55. Error: Failed to save update 4d42b688-f416-4e0a-a921-8999d5d1a68e. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:28 PM	21704 (0x54C8)
    Synchronizing update 7155376c-87e9-4f55-80f1-0d7c64eb8b5d - Microsoft .NET Framework 4.7.2 for Windows 7 (KB4054530) SMS_WSUS_SYNC_MANAGER 8/13/2019 9:16:28 PM 21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914840, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:30 PM	21704 (0x54C8)
    *** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 2627, Level 14, State 1, Procedure tr_vCI_ContentFiles_upd, Line 17, Message: Violation of UNIQUE KEY constraint 'CI_Files_AK'. Cannot insert duplicate key in object 'dbo.CI_Files'. The duplicate key value is (SHA1:A1C5F3C6AC7519F692791960092C07C745C48481, windows6.1-kb4019990-x86.cab, 0xc591f16ff97c9725c03e10528996d059f3dd936f). : spRethrowError	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:30 PM	21704 (0x54C8)
    Failed to sync update 7155376c-87e9-4f55-80f1-0d7c64eb8b5d. Error: Failed to save update 9f6cfa34-72f4-4fe6-9131-5fb03d1af361. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:16:30 PM	21704 (0x54C8)
    Synchronizing update 8d575ead-f8c4-414c-84d7-90ef4ff0fe80 - Microsoft .NET Framework 4.7.2 for Windows Server 2008 R2 for x64 (KB4054530) SMS_WSUS_SYNC_MANAGER 8/13/2019 9:18:31 PM 21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914844, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:18:31 PM	21704 (0x54C8)
    *** [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. : sp_SetupCI	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:18:31 PM	21704 (0x54C8)
    *** declare @rc int, @errxml xml, @errmsg nvarchar(max); EXEC @rc=sp_SetupCI 16914844, default, @errxml output, @errmsg output; select @rc, @errxml, @errmsg	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:18:31 PM	21704 (0x54C8)
    *** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 2627, Level 14, State 1, Procedure tr_vCI_ContentFiles_upd, Line 17, Message: Violation of UNIQUE KEY constraint 'CI_Files_AK'. Cannot insert duplicate key in object 'dbo.CI_Files'. The duplicate key value is (SHA1:BCC5A1D0E9AFEC8C01C745F7B88F511A3269BC21, windows6.1-kb4019990-x64.cab, 0x8ddfabc5ffd149ebdd0885c3732648e0262af9c8). : spRethrowError	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:18:31 PM	21704 (0x54C8)
    Failed to sync update 8d575ead-f8c4-414c-84d7-90ef4ff0fe80. Error: Failed to save update 9ca8fb88-eb83-4b01-b7dd-5712615f90c0. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:18:31 PM	21704 (0x54C8)

    .............

    sync: SMS synchronizing updates, processed 7176 out of 7176 items (100%)	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Sync failures summary:	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Failed to sync update 490dea5d-cc7c-4965-9254-b6291882fd2e. Error: Failed to save update 88a1c71a-5210-4ab9-95b7-a3b7fcc066af. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Failed to sync update 62f28bd3-d612-46bc-acee-cc43abbdaf55. Error: Failed to save update 4d42b688-f416-4e0a-a921-8999d5d1a68e. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Failed to sync update 7155376c-87e9-4f55-80f1-0d7c64eb8b5d. Error: Failed to save update 9f6cfa34-72f4-4fe6-9131-5fb03d1af361. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Failed to sync update 8d575ead-f8c4-414c-84d7-90ef4ff0fe80. Error: Failed to save update 9ca8fb88-eb83-4b01-b7dd-5712615f90c0. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	21704 (0x54C8)
    Sync failed: Failed to sync some of the updates. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncUpdates	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	25648 (0x6430)
    STATMSG: ID=6703 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=VRPSCCMPR01.AD.MEDCTR.UCLA.EDU SITE=UCP PID=15324 TID=25648 GMTDATE=Wed Aug 14 04:21:43.736 2019 ISTR0="Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncUpdates" ISTR1="Failed to sync some of the updates" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	25648 (0x6430)
    Sync failed. Will retry in 60 minutes	SMS_WSUS_SYNC_MANAGER	8/13/2019 9:21:43 PM	25648 (0x6430)

    Any idea?

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL




    • Edited by Felyjos Wednesday, August 14, 2019 3:03 PM
    Wednesday, August 14, 2019 2:44 PM

Answers

  • MS has now released new revisions to WSUS.

    Rolf Lidvall, Swedish Radio (Ltd)

    • Marked as answer by Felyjos Tuesday, August 27, 2019 9:20 PM
    Wednesday, August 21, 2019 8:09 AM
  • Thanks for the update ... Checking WSUS as I declined the previous ones including

    4054542 republished under same name

    4054530 republished under same name

    4019990 unchanged

    Approving for Install on 4019990.

    Windows 7 does not seem to download and deploy.... checking ...

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL




    • Edited by Felyjos Wednesday, August 21, 2019 2:41 PM
    • Marked as answer by Felyjos Tuesday, August 27, 2019 9:20 PM
    Wednesday, August 21, 2019 2:06 PM

All replies

  • Same here. It seems some .net framework 4.7.2 updates were updated this month and they are causing this issue. As a workaround for now, I declined these four problematic updates in WSUS directly:

    - Microsoft .NET Framework 4.7.2 for Windows Server 2012 for x64 (KB4054542)

    - Microsoft .NET Framework 4.7.2 for Windows Server 2008 R2 for x64 (KB4054530)

    - Microsoft .NET Framework 4.7.2 for Windows 7 for x64 (KB4054530)

    - Microsoft .NET Framework 4.7.2 for Windows 7 (KB4054530)

    I also declined kb4019990 which was being referenced in the logs. We don't use any of these OSes by the way.

    • Proposed as answer by Fletch F Fletch Thursday, August 15, 2019 4:47 PM
    • Unproposed as answer by Fletch F Fletch Thursday, August 15, 2019 4:47 PM
    • Proposed as answer by DerFolke Monday, August 19, 2019 8:54 AM
    Wednesday, August 14, 2019 2:55 PM
  • Same problem here! is stopping my replicas from Syncing
    Wednesday, August 14, 2019 3:28 PM
  • The workaround that I mentioned above allows the sync to finish successfully.
    Wednesday, August 14, 2019 3:32 PM
  • Thanks for the workaround. Hopefully MS will fix soon.
    Wednesday, August 14, 2019 4:01 PM
  • Same problem here.  SCCM 1810.  We're going to hold off on the workaround and give MS a chance to fix.

    Wednesday, August 14, 2019 5:37 PM
  • Same problem here on SCCM 1902 running on server 2019, Glad to see were not the only one with these exact updates failing. Hopefully they resolve the issue fairly quickly.
    Wednesday, August 14, 2019 6:57 PM
  • I was also running into this issue. Confirmed that declining in WSUS allows it to sync.  
    Wednesday, August 14, 2019 8:49 PM
  • Hello,

    Confirmed that declining in WSUS allows it to synchronize.

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Wednesday, August 14, 2019 8:56 PM
  • Same issue here running SCCM 1810 :(
    Thursday, August 15, 2019 5:26 AM
  • Exact same here as well with 1902.  Thanks for the Decline suggestion :)
    Thursday, August 15, 2019 9:59 AM
  •   Thanks.  I had done cleanup in SQL and was running out of ideas.

    Thursday, August 15, 2019 4:48 PM
  • Yep, I've talked to the support team and they've confirmed that this is a bug in ConfigMgr that they are working to address.

    In the meantime, declining the update in WSUS should help resolve the sync problem but you obviously won't get the update.  Supposedly the .NET team is going to republish the update in a way that should avoid this problem while the ConfigMgr product team comes up with a more permanent solution.

    Friday, August 16, 2019 8:04 PM
  • This worked for me as well! However now those updates are failing to sync with a different error on each of those updates:

    *** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 2627, Level 14, State 1, Procedure tr_vCI_ContentFiles_upd, Line 17, Message: Violation of UNIQUE KEY constraint 'CI_Files_AK'. Cannot insert duplicate key in object 'dbo.CI_Files'. The duplicate key value is (SHA1:BCC5A1D0E9AFEC8C01C745F7B88F511A3269BC21, windows6.1-kb4019990-x64.cab, 0x8ddfabc5ffd149ebdd0885c3732648e0262af9c8). : spRethrowError

    Monday, August 19, 2019 5:33 PM
  • Im seeing same issue with SCCM 1902 at customer with latest hotfix.

    Configmanagerguru www.configmanagerguru.com

    Tuesday, August 20, 2019 3:10 PM
  • MS has now released new revisions to WSUS.

    Rolf Lidvall, Swedish Radio (Ltd)

    • Marked as answer by Felyjos Tuesday, August 27, 2019 9:20 PM
    Wednesday, August 21, 2019 8:09 AM
  • Thanks for the update ... Checking WSUS as I declined the previous ones including

    4054542 republished under same name

    4054530 republished under same name

    4019990 unchanged

    Approving for Install on 4019990.

    Windows 7 does not seem to download and deploy.... checking ...

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL




    • Edited by Felyjos Wednesday, August 21, 2019 2:41 PM
    • Marked as answer by Felyjos Tuesday, August 27, 2019 9:20 PM
    Wednesday, August 21, 2019 2:06 PM