cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

WSUS synch sql error

Hi Community,

Please help below situation. Thanks in advance.

The test bed:

WSUS 3.0 sp2 running on win2k8 r2, as replica server of sus-update.foundstone.com, deploy to scan engine.

Issues: I can see updates downloaded from the upstream server, however, the scheduled synchronisation always failed.

Synchronisation details:

Result: an error ocured with the server data store. when click on 'detail', below popup

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)

1 Reply
Highlighted

Re: WSUS synch sql error

Timeout errors during replica synchronization are a growing problem, and typically traced back to the state of the upstream server maintenance activity.

Here's a blog series at PatchZone.org that discusses the causes, remediations, and maintenance requirements to prevent Timeout Errors.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community