WSUS Server Cleanup Wizard Timeout

[Michael Plakus]

Whenever I run the Server Cleanup Wizard on my WSUS 3.0SP1 server I get a
timeout error. What could be causing this and is there a way to increase the
timeout?

2008-08-27 16:14:21.465 UTC Info w3wp.200 WsusServiceUtility.Stop Stopping
WsusService
2008-08-27 16:14:21.496
UTC Info WsusService.16 ThreadEntry _ThreadPoolWaitCallback.PerformWaitCallback
2008-08-27 16:14:21.496
UTC Info WsusService.16 SusService.OnStop EventId=502,Type=Information,Category=WsusService,Message=Update Services Service Has Stopped
2008-08-27 16:14:22.496
UTC Info w3wp.200 WsusServiceUtility.Stop WsusService successfully stopped.
2008-08-27 16:14:22.496
UTC Info mmc.7 CleanupManager.PerformCleanup PerformCleanup(): Start
CleanupObsoleteUpdates.
2008-08-27 16:16:55.621
UTC Warning w3wp.6 SoapExceptionProcessor.SerializeAndThrow Discarding stack
trace for user <UserID>, IP Address <IP Address>, exception
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
at
Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at
Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
at
Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(DBConnection connection)
at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler, Int32
queryTimeoutInSeconds)
at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler)
at
Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPNoResult(String spName, DBParameterCollection args)
at
Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeleteUpdate(Int32 localUpdateID)
at
Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPDeleteUpdate(Int32
localUpdateID)

 

[PA Bear [MS MVP]]

Re: WSUS Server Cleanup Wizard Timeout

Right pew, wrong church. Forwarded to WSUS newsgroup
(microsoft.public.windows.server.update_services) via crosspost as a
convenience to OP.

On the web:
http://www.microsoft.com/communitie...crosoft.public.windows.server.update_services

In your newsreader:
news://msnews.microsoft.com/microsoft.public.windows.server.update_services

--
~PAB

Michael Plakus wrote:
> Whenever I run the Server Cleanup Wizard on my WSUS 3.0SP1 server I get a
> timeout error. What could be causing this and is there a way to increase
> the
> timeout?
>
> 2008-08-27 16:14:21.465 UTC Info w3wp.200 WsusServiceUtility.Stop Stopping
> WsusService
> 2008-08-27 16:14:21.496
> UTC Info WsusService.16 ThreadEntry
> _ThreadPoolWaitCallback.PerformWaitCallback 2008-08-27 16:14:21.496
> UTC Info WsusService.16 SusService.OnStop
> EventId=502,Type=Information,Category=WsusService,Message=Update Services
> Service Has Stopped 2008-08-27 16:14:22.496
> UTC Info w3wp.200 WsusServiceUtility.Stop WsusService successfully
> stopped.
> 2008-08-27 16:14:22.496
> UTC Info mmc.7 CleanupManager.PerformCleanup PerformCleanup(): Start
> CleanupObsoleteUpdates.
> 2008-08-27 16:16:55.621
> UTC Warning w3wp.6 SoapExceptionProcessor.SerializeAndThrow Discarding
> stack
> trace for user <UserID>, IP Address <IP Address>, exception
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> The statement has been terminated.
> at
> Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException
> e) at
> Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
> at
> Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(DBConnection
> connection) at
> Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
> spName, DBParameterCollection args, IExecuteSPHandler handler, Int32
> queryTimeoutInSeconds)
> at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
> spName, DBParameterCollection args, IExecuteSPHandler handler)
> at
> Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPNoResult(String
> spName, DBParameterCollection args) at
> Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeleteUpdate(Int32
> localUpdateID) at
> Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPDeleteUpdate(Int32
> localUpdateID)