WSUS Server Cleanup Wizard Timeout

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.DBConnecti on.DrainObsoleteConnections(SqlException e)
at
Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.ExecuteCommandNoResult()
at
Microsoft.UpdateServices.Internal.NoResultSPHandle r.ExecuteStoredProcedure(DBConnection connection)
at Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler, Int32
queryTimeoutInSeconds)
at Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler)
at
Microsoft.UpdateServices.Internal.DatabaseAccess.C ommonDataAccess.ExecuteSPNoResult(String spName, DBParameterCollection args)
at
Microsoft.UpdateServices.Internal.DatabaseAccess.A dminDataAccess.ExecuteSPDeleteUpdate(Int32 localUpdateID)
at
Microsoft.UpdateServices.Internal.ApiRemoting.Exec uteSPDeleteUpdate(Int32
localUpdateID)

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/communities... date_services

In your newsreader:
news://msnews.microsoft.com/microsof...pdate_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.DBConnecti on.DrainObsoleteConnections(SqlException
> e) at
> Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.ExecuteCommandNoResult()
> at
> Microsoft.UpdateServices.Internal.NoResultSPHandle r.ExecuteStoredProcedure(DBConnection
> connection) at
> Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
> spName, DBParameterCollection args, IExecuteSPHandler handler, Int32
> queryTimeoutInSeconds)
> at Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
> spName, DBParameterCollection args, IExecuteSPHandler handler)
> at
> Microsoft.UpdateServices.Internal.DatabaseAccess.C ommonDataAccess.ExecuteSPNoResult(String
> spName, DBParameterCollection args) at
> Microsoft.UpdateServices.Internal.DatabaseAccess.A dminDataAccess.ExecuteSPDeleteUpdate(Int32
> localUpdateID) at
> Microsoft.UpdateServices.Internal.ApiRemoting.Exec uteSPDeleteUpdate(Int32
> localUpdateID)