Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Windows Server Update Services encountered an error.

Posted on 2008-06-19
3
Medium Priority
?
698 Views
Last Modified: 2010-05-18
WhenI try to approve some updates I receive the following:
Windows Server Update Services encountered an error.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
[Show Details] [Close]"
When I press "Show Details", the following information is given:

System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
   at Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProcedure(DBConnection connection)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
   at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(Guid updateId, Int32 revisionNumber, Int32 deploymentAction, Guid targetGroupId, String adminName, DateTime deadline, Boolean isAssigned, DateTime goLiveTime, Int32 downloadPriority, Guid deploymentGuid, Boolean translateSqlException)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(UpdateRevisionId updateId, Int32 deploymentAction, Guid targetGroupId, DateTime deadline, String adminName)
   at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup, DateTime deadline)
   at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup)
   at Administration.Updates.UpdateProxy.Deploy(String xpostXml)
   at Administration.Updates.UpdateXPost.Page_Load(Object sender, EventArgs e)

   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
   at Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProcedure(DBConnection connection)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
   at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(Guid updateId, Int32 revisionNumber, Int32 deploymentAction, Guid targetGroupId, String adminName, DateTime deadline, Boolean isAssigned, DateTime goLiveTime, Int32 downloadPriority, Guid deploymentGuid, Boolean translateSqlException)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(UpdateRevisionId updateId, Int32 deploymentAction, Guid targetGroupId, DateTime deadline, String adminName)
   at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup, DateTime deadline)
   at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup)
   at Administration.Updates.UpdateProxy.Deploy(String xpostXml)
   at Administration.Updates.UpdateXPost.Page_Load(Object sender, EventArgs e)

Does anyone have some fixes?   I might add the approval time for a Single approval is very long.
-Sm
0
Comment
Question by:smantz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 total points
ID: 21831609
Try this one:
Enabling Large Patches to Install
http://blogs.msdn.com/heaths/archive/2006/09/22/767053.aspx

I run into it all the time when it is trying to do the Visual Studio SP.
0
 

Author Closing Comment

by:smantz
ID: 31468981
Looks like a reasonable solution.  Haven't had time to try it out.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 21910037
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question