locked
SCCM 2012 - Primary site to CAS SUP/WSUS Sync not working RRS feed

  • Question

  • Hi,

    We have one CAS site and two Primary sites in our SCCM hierarchy configured with SUP and WSUS roles. CAS synchronize from Microsoft for updates and SUPs on both Primary Sites are configured to Sync with CAS Site. Everything was working fine few days back but now WSUS/SUP on Primary Sites are not synchronizing with CAS Site.

    When we Sync WSUS manually from its console then it sync from CAS site but Software Update Synchronization Status doesn't reflect Last Sync Status in Monitoring tab on CAS console.

    We have reinstalled and reconfigured WSUS as well as SUP on both Primary Sites but no go yet on this issue and we are unable to figure out anything from WSUS log files on Primary Site servers.

    Due to this issue we are unable to deploy patch updates in our environment.

    Below are the logs from Primary Site Servers

    WSyncmgr.log (Primary Server 1)

    Wakeup by SCF change SMS_WSUS_SYNC_MANAGER 3/13/2014 10:29:24 AM 11188 (0x2BB4)
    Wakeup by SCF change SMS_WSUS_SYNC_MANAGER 3/13/2014 10:29:34 AM 11188 (0x2BB4)
    Wakeup by SCF change SMS_WSUS_SYNC_MANAGER 3/13/2014 10:29:49 AM 11188 (0x2BB4)
    Thread terminated by service request. SMS_WSUS_SYNC_MANAGER 3/13/2014 10:30:58 AM 11188 (0x2BB4)
    SMS_EXECUTIVE started SMS_WSUS_SYNC_MANAGER as thread ID 5828 (0x16C4). SMS_WSUS_SYNC_MANAGER 3/13/2014 10:34:36 AM 4376 (0x1118)
    Log level 2 SMS_WSUS_SYNC_MANAGER 3/13/2014 10:34:36 AM 5828 (0x16C4)
    Wakeup by SCF change SMS_WSUS_SYNC_MANAGER 3/13/2014 10:37:44 AM 5828 (0x16C4)
    Wakeup for a polling cycle SMS_WSUS_SYNC_MANAGER 3/13/2014 11:37:49 AM 5828 (0x16C4)
    Wakeup for a polling cycle SMS_WSUS_SYNC_MANAGER 3/13/2014 12:37:49 PM 5828 (0x16C4)
    Wakeup for a polling cycle SMS_WSUS_SYNC_MANAGER 3/13/2014 1:37:49 PM 5828 (0x16C4)
    Wakeup for a polling cycle SMS_WSUS_SYNC_MANAGER 3/13/2014 2:37:49 PM 5828 (0x16C4)

    WSyncmgr.log (Primary Server 2)

    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>SELECT SC.SiteType FROM SMSData S INNER JOIN SC_SiteDefinition SC ON SC.SiteCode = S.ThisSiteCode SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>SELECT dbo.fnIsSnapshotInitializing(N'Site Control Data', N'') SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>select DateLastModified from SiteControl where SiteCode = N'PS1' SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>select top 1 PkgID, Name, Source from vSoftwareUpdatesPackage where SourceSite=dbo.fnGetSiteCode() and PkgID>'' order by PkgID SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 2:29:09 PM 7260 (0x1C5C)
    Wakeup for a polling cycle SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>select SiteCode,SiteName,ReportToSite,Status,DetailedStatus,TimeStamp,SomeId,SiteType,BuildNumber,Version,SiteServer,InstallDir,TimeZoneInfo,LocaleID,ReplicatesReservedRanges,Mode from vSites   order by ReportToSite,SiteCode SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>SELECT SC.SiteType FROM SMSData S INNER JOIN SC_SiteDefinition SC ON SC.SiteCode = S.ThisSiteCode SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>SELECT dbo.fnIsSnapshotInitializing(N'Site Control Data', N'') SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>select DateLastModified from SiteControl where SiteCode = N'PS1' SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>select top 1 PkgID, Name, Source from vSoftwareUpdatesPackagewhere SourceSite=dbo.fnGetSiteCode() and PkgID>'' order by PkgID SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)
    SQL>>>>> Done. SMS_WSUS_SYNC_MANAGER 3/13/2014 3:29:09 PM 7260 (0x1C5C)

    Please help

    Thanks.



    Thursday, March 13, 2014 10:39 PM

Answers

  • A CAS and two primaries? So you must be managing more than 100.000 clients? Right?

    The logfiles don't help at all because they don't contain any error. Please upload both logs to Skydrive.
    Is DRS replication working fine between all sites?


    Torsten Meringer | http://www.mssccmfaq.de

    • Marked as answer by Juke Chou Monday, March 31, 2014 3:08 AM
    Friday, March 14, 2014 8:12 AM
  • When the CAS finishes syncing with Microsoft Update Server, it will generate a alert to wake up the child sites' SUP to sync with itself. The log files we need are wsusctrl.log, WCM.log, WSyncmgr.log. Please upload the logs of both CAS and PRI to Skydrive.

    Juke Chou

    TechNet Community Support

    • Marked as answer by Juke Chou Monday, March 31, 2014 3:09 AM
    Sunday, March 16, 2014 4:12 PM
  • Ajeet,

    I have looked at the logs and it seems that the CAS completes the sync and then drops a <ChildSiteCode>.SYN file. Note that this file does not replicate via DRS but through the legacy file replication way.

    The flow would be replmgr-> secheduler -> sender on CAS

    and despool -> replmgr -> wsyncmgr on primary.

    Please verify if the file based replication is working fine.

    -Umair

    • Proposed as answer by Garth JonesMVP Saturday, March 29, 2014 2:12 PM
    • Marked as answer by Juke Chou Monday, March 31, 2014 3:08 AM
    Monday, March 17, 2014 12:46 PM

All replies

  • A CAS and two primaries? So you must be managing more than 100.000 clients? Right?

    The logfiles don't help at all because they don't contain any error. Please upload both logs to Skydrive.
    Is DRS replication working fine between all sites?


    Torsten Meringer | http://www.mssccmfaq.de

    • Marked as answer by Juke Chou Monday, March 31, 2014 3:08 AM
    Friday, March 14, 2014 8:12 AM
  • When the CAS finishes syncing with Microsoft Update Server, it will generate a alert to wake up the child sites' SUP to sync with itself. The log files we need are wsusctrl.log, WCM.log, WSyncmgr.log. Please upload the logs of both CAS and PRI to Skydrive.

    Juke Chou

    TechNet Community Support

    • Marked as answer by Juke Chou Monday, March 31, 2014 3:09 AM
    Sunday, March 16, 2014 4:12 PM
  • Hi Juke,

    Thanks for your reply.

    I have uploaded wsusctrl.log, WCM.log, WSyncmgr.log to Skydrive for CAS and both Primary Sites.

    Link is given below.

    http://1drv.ms/1d6l6qm

    and once CAS finishes sync with Microsoft Update, it is sending Sync notification to both Primary Sites as I can see in WSyncmgr.log file on CAS site but it stuck up on below mgs.

    "Sending sync notification to child site(s): Primary1, Primary2
    SQL Replication type has not been set for E:\SCCM Directory\inboxes\wsyncmgr.box\outbox\CAS.SYN, replicating to (PS1, PS2), inbox: E:\SCCM Directory\inboxes\replmgr.box"

    Nothing in happening after above message in WSyncmgr.log file and there is NO update in log files on both Primary Sites.

    Please look into log file and help us to get this resolved.

    Thanks.


    Monday, March 17, 2014 11:19 AM
  • A CAS and two primaries? So you must be managing more than 100.000 clients? Right?

    The logfiles don't help at all because they don't contain any error. Please upload both logs to Skydrive.
    Is DRS replication working fine between all sites?


    Torsten Meringer | http://www.mssccmfaq.de

    Hi Torsten,

    Thank you  for your reply.

    We are managing around 15000 thousand machines using SCCM presently and it my extend in future.

    DRS replication is working fine among CAS, Primary and Secondary Sites. Any changes in CAS site like if I create Software Update Groups then it will immediately reflects on Primary sites.

    I have uploaded wsusctrl.log, WCM.log, WSyncmgr.log to Skydrive for CAS and both Primary Sites.

    Below is the link for Skydrive.

    http://1drv.ms/1d6l6qm

    Please look into log file and help us to get this resolved.

    Thanks.

    Monday, March 17, 2014 11:25 AM
  • Ajeet,

    I have looked at the logs and it seems that the CAS completes the sync and then drops a <ChildSiteCode>.SYN file. Note that this file does not replicate via DRS but through the legacy file replication way.

    The flow would be replmgr-> secheduler -> sender on CAS

    and despool -> replmgr -> wsyncmgr on primary.

    Please verify if the file based replication is working fine.

    -Umair

    • Proposed as answer by Garth JonesMVP Saturday, March 29, 2014 2:12 PM
    • Marked as answer by Juke Chou Monday, March 31, 2014 3:08 AM
    Monday, March 17, 2014 12:46 PM
  • Tuesday, April 22, 2014 9:46 PM