1 Reply Latest reply on May 28, 2013 9:35 AM by lawrencegarvin

    WSUS synch sql error

    nothingfishy

      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(G uid[] hiddenUpdates)

         at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ReplicaSync()

         at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ExecuteSyncProtocol(Bo olean allowRedirect)