Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


WSUS Synchronization Failure

Posted on 2012-08-20
Medium Priority
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
  • 2
LVL 17

Expert Comment

ID: 38313406
Have you run WSUS Cleanup Wizard on that server?

Author Comment

ID: 38316462
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

pjam earned 1000 total points
ID: 38316920
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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

564 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