cancel
Showing results for 
Search instead for 
Did you mean: 
nothingfishy
Level 7

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)

0 Kudos
1 Reply

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.

0 Kudos