Solved

SBS 2003 Server Status Report critical error

Posted on 2009-03-30
3
602 Views
Last Modified: 2012-05-06
I am running WSUS 2.0 on SBS 2003.  Over the last month or so, every few days I receive the following critical error in my Server Status Report:

Server Status Report:
  URL: http://localhost/monitoring/perf.aspx?reportMode=1&allHours=1 
  Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32 offset, Int32 len)
at System.Data.SqlClient.TdsParser.ReadString(Int32 length)
at System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32 length)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns, Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
at Microsoft.UpdateServices.Internal.DatabaseAccess.GenericReadableRow.ReadRow(IDataRecord record)
at Microsoft.UpdateServices.Internal.MultipleResultSetsSPHandler.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.DataAccess.ExecuteSPMultipleResultSets(String spName, DBParameterCollection args, Type[] resultTypes)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPCompleteUpdatesResult(String spName, DBParameterCollection args)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetAllUpdates(String preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime toSyncDate, Guid[] updateCategoryIds, Guid[] updateClassificationIds, Int32 publicationState)
at Microsoft.UpdateServices.Internal.BaseApi.Update.GetAll(ApprovedStates approvedStates, DateTime fromSyncDate, DateTime toSyncDate, UpdateCategoryCollection updateCategories, UpdateClassificationCollection updateClassifications, ExtendedPublicationState publicationState)
at Microsoft.UpdateServices.Internal.BaseApi.Update.GetAll(ApprovedStates approvedStates, DateTime fromSyncDate, DateTime toSyncDate, UpdateCategoryCollection updateCategories, UpdateClassificationCollection updateClassifications)
at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetUpdates(ApprovedStates approvedStates, DateTime fromSyncDate, DateTime toSyncDate, UpdateCategoryCollection updateCategories, UpdateClassificationCollection updateClassifications)
at Microsoft.SBS.UpdateServices.DataProvider.GetScheduledUpdates()
at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetStatusItems()
at usage.frmPerf.PopulateStatusItems()
at usage.frmPerf.renderReportWorker()
at usage.frmPerf.renderReport()

I receive a daily email of this report and when the error has occurred, the email says "The page cannot be displayed" and asks that I check a number of items.  I have researched this issue previously and have tried a number of things suggested solutions including re-running the ,"Set up Monitoring Reports and Alerts" wizard, running WSUSUtil deleteunneededrevisions, and restarting the server.  The day after running any of these, everything appears fine, but the following day the error recurs. Can someone please tell me what's happening here and  provide a long term solution?  Thanks.
Michael
0
Comment
Question by:msklein
  • 2
3 Comments
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 24021253
From here:

http://www.wsus.info/forums/lofiversion/index.php?t6658.html

Timeout Expired Error

Here is a break down of the fix:

1) Create a text file named addDeploymentIndex.sql

2) Add the following text to the sql file:
    USE SUSDB
    GO
    BEGIN TRAN
    IF NOT EXISTS (SELECT * FROM sysindexes where name='nc7DeploymentRevision')
    BEGIN
         CREATE NONCLUSTERED INDEX nc7DeploymentRevision ON dbo.tbDeployment(RevisionID, TargetGroupID, ActionID)
    END
    COMMIT TRAN
    GO
(note: the "create nonclusted" line probably word wrapped in this post... it will need to be one long line ending with "actionid)")

3) Place the file in c:\program files\update services\tools\osql.

4) On the WSUS server, open the command prompt and move to the osql directory. Run the following command:

    osql -E -S%servername%\WSUS -n -b -i addDeploymentIndex.sql

(note: %servername% is the name of your wsus server... there is no space between -S and the name, but I'm not sure if it is case sensitive or not... i used all caps for the name, and it seemed to work)

5) The script will run, then return you to command prompt. You will not get any notification if it was successful, but it will notify you if there are errors.

 You will need to run this script on each of your WSUS servers that are using MSDE, then synch them. You should see and immediate speed difference in approvals and server synchs. I hope this information helps!
0
 

Author Comment

by:msklein
ID: 24988676
It has taken me this long to try your solution as the error has started occurring every day.  I copied and pasted everything you wrote and ran as you suggested.  Unfortunately, it didn't correct the problem.  I used the non-fully qualified name for the server, i.e., I used SERVER01 instead of SERVER01.company.local.  Would this have made a difference?
0
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 500 total points
ID: 24990635
Upgrade your WSUS to version 3.0 and this should resolve the issue
 
http://www.microsoft.com/downloads/details.aspx?FamilyId=F87B4C5E-4161-48AF-9FF8-A96993C688DF&displaylang=en 
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

789 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