locked
Getting sync error RRS feed

  • Question

  • Hi Team,

    Below are the environments.

    1 Upstream servers.
    18+ Downstream servers.

    Issue: Upstream server is working fine and getting sync with Microsoft without any error but none of the downstream servers are getting sync with upstream servers. This is the error we are getting:

    SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ReadOneRow()
       at Microsoft.UpdateServices.Internal.DataAccess.HideUpdatesForReplicaSync(String xmlUpdateIds)
       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ProcessHiddenUpdates(Guid[] hiddenUpdates)
       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ReplicaSync()
       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ExecuteSyncProtocol(Boolean allowRedirect)

    Please guide/help me on this.

    Thanks in Advance.

    Thanks & Regards,

    Praveen.

    Monday, April 25, 2016 1:46 PM

All replies

  • Am 25.04.2016 schrieb Velpulapk:

    Below are the environments.

    1 Upstream servers.
    18+ Downstream servers.

    Issue: Upstream server is working fine and getting sync with Microsoft without any error but none of the downstream servers are getting sync with upstream servers. This is the error we are getting:*SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.*

    Is KB3148812 installed on your Downstream- and/or on your Upstream?

    Winfried


    WSUS Package Publisher: http://wsuspackagepublisher.codeplex.com/
    http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
    http://www.wsuswiki.com/Home

    Monday, April 25, 2016 5:01 PM
  • Hi Velpulapk,

    1. As Winfried pointed out, check if you have installed KB3148812, if yes, then uninstall it, there is an known issue for that KB:

    http://blogs.technet.com/b/wsus/archive/2016/04/20/known-issues-with-kb3148812.aspx

    2. Check the WSUS event log, open event viewer, expand Customer Views>Server roles>Windows Server Update Services, check if there are errors in the log, especially event 364, if you see event 364, then post the detailed log here;

    3. Also check the network connection between downstream server and upstream server, check if you can ping between each other, if there are firewalls, then turn off the firewall temporarily and check the result.

    4. Check the Products and Classifications in downstream server and upstream server, ensure the upstream server actually have the updates downloaded locally.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, April 26, 2016 5:33 AM
  • Hi There,

    Sorry for the delay, Please find the responses below:

    Windows update KB3148812 is also not installed on the server.

    Event event 364 is not generating.

    Event 10022, 10032 and 13032 are getting generated.

    Also, upstream server has updates downloaded locally and there seems to be proper ping connectivity between upstream and downstream servers.

    Could you please help me on this.

    Thanks & Regards,

    Praveen.

    Thursday, May 5, 2016 6:36 AM
  • Hi Velpilapk,

    Check if reindex WSUS database on the upstream server could help:

    https://technet.microsoft.com/en-us/library/dd939795(v=ws.10).aspx

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Friday, May 6, 2016 9:25 AM
  • Thank you Anne.

    As per the URL, We have performed but we are getting the below error. Please find the screenshot below:

    Thanks in advance.

    Thanks & Regards,

    Praveen.

    Wednesday, May 18, 2016 5:32 AM
  • Hi Velpilapk,

    Do you on server 2012 or 2012 R2, if yes, use this command:

    SQLCMD -E -S np:\\.\pipe\MICROSOFT##WID\tsql\query -i <script location>

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.


    Wednesday, May 18, 2016 5:44 AM
  • Thank you Anne. We will perform this and keep posting.

    Thanks & Regards,

    Praveen.

    Wednesday, May 18, 2016 10:32 AM