Help - Sever Status Reports Failing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello SBS'ers,

I have been havine my morning reports failing for the last two - three weeks.

I have tried reinstalling the reports, and also, stopping and restarting the
service, but in the morning - same results.

I think the report is "timing out" before it can finish, but not sure. And
not sure if this can be adjusted or not.

I am uploading the error report, any help would be great.

Error Report for 9/18/2007:


Event Type: Error
Event Source: ServerStatusReports
Event Category: None
Event ID: 1
Date: 9/18/2007
Time: 6:20:41 AM
User: N/A
Computer: SBS1
Description:
Server Status Report:
URL: https://localhost/monitoring/perf.aspx?reportMode=0
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()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.




--
Sal Candela
.



Relevant Pages

  • Re: Help - Sever Status Reports Failing
    ... Can you view the Server Performance Report manually by clicking on the Monitoring and Reporting node of Standard Management? ... at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ... UpdateCategoryCollection updateCategories, UpdateClassificationCollection ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - Sever Status Reports Failing
    ... I usually use the WSUS console directly from the admin page. ... This error use to be listed in the morning status report, ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ... UpdateCategoryCollection updateCategories, UpdateClassificationCollection ...
    (microsoft.public.windows.server.sbs)
  • Network Error failed monitoring
    ... Server Status Report: ... at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ... UpdateCategoryCollection updateCategories, UpdateClassificationCollection ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 R2 + WSUS - KB948110, SBSMONITORING AND WSUS SNAP-IN fail
    ... I had a similar problem with an SBS 2003 R2 server and had to make a change ... at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ... UpdateCategoryCollection updateCategories, UpdateClassificationCollection ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS monitoring
    ... at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ... UpdateCategoryCollection updateCategories, UpdateClassificationCollection ...
    (microsoft.public.windows.server.sbs)