WSUS Synchronization Failure

Posted on 2012-08-20
Last Modified: 2012-08-24
I am receiving an error on one of our WSUS downstream servers "Windows Server 2008 R2 Foundation," but all other WSUS downstream servers are not having this issue.
When I do a manual synchronization of WSUS from our clients server to our main WSUS server I receive the following error:
Synchronization Error Detail
An error occurred with the server's data store
SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
   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)

Also, I receive an event log error 10022 for Windows Server Update Services saying:
The last catalog synchronization attemp was unsuccessful.

Finally, when going into WSUS and bringing up reports on specific pc's WSUS will crash or stay stuck on generating report.  

Any help will be thankful.
Question by:ByteCafeSupport
    LVL 17

    Expert Comment

    Have you run WSUS Cleanup Wizard on that server?

    Author Comment

    I have run the WSUS cleanup wizard on the server and tried another manual sync, but still having the issue of WSUS timing out at 98%.  
    I try to click on the result details, but the report will not come up giving me any additional information.
    When I go into the event viewer I still see an event id 10022 and 13002.

    Anyone have any other suggestions to this issue?
    LVL 17

    Accepted Solution

    What version of WSUS do you have on that server?  If it isn't the latest i would upgrade to that. (SP2 (3.2.7600.226)

    The event ID 13002 indicates updates are failing because the files associated with those updates were deleted from the WSUS server.
    do you also get an "HTTP status 404: The requested URL does not exist on the server"?

    If so, run wsusutil reset to re-download the missing content, and then review the procedures you're using to manage the filesystem on your WSUS server.

    Good hunting

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
    New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
    This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now