Re: Help - Sever Status Reports Failing

Les,

If I open the child nodes - they all are fine - no problems.


--
Sal Candela


"Les Connor [SBS MVP]" wrote:

Sorry, my bad, issreset is a typo - iisreset is the correct command.

But a server restart trumps that, so don't bother to do it now.

What happens if you don't click the Update Services parent item, but instead
click the + sign to expand, and then click one of the child nodes?

I see Terrence has replied to the thread - he'll have access to more cases
and might have the solution.

Frankly, I've had my share of IIS issues with WSUS, and even with CSS help I
haven't been able to resolve them all.

--
Les Connor [SBS MVP]


"Sal Candela" <SalCandela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5CDFC312-ADA9-456A-81A5-5834AF245AC7@xxxxxxxxxxxxxxxx
Les,

Thanks for posting ...

I went down your list with no help, except for the last one (issreset) as
it
tells me that this command does not exist.

Also, when I click in the "update" window in the Standdard Management, I
receive a application error.

I restarted the server with no help, and also restarted the Server Reports
from scratch - no help.

I did google the problem, and there have been several posts of this error,
that stem for using SSL for the updates. Some have corrected the problem
by
disabling this, but I am not sure how to do.

I am think of just removeing the WSUS v3, reinstalling v2, what do you
think?

--
Sal Candela


"Les Connor [SBS MVP]" wrote:

Have you restarted the server recently?

If not, you can try these things ( increasing levels of heavy-hammers).

a) In IIS management | Application Pools > restart either the
DefaultAppPool
or the WsusPool, and see if you can view the server report now in the
Monitoring and Reporting node of Standard Management.

b) From IIS MMC, select your SBS computer object, right click > all tasks
>
restart IIS and wait until the process is completed.

c) From a command prompt, enter "issreset" (without the quotes).

d) restart the server.

In all cases except a), check the services to see that they've all
restarted
successfully.

--
Les Connor [SBS MVP]


"Sal Candela" <SalCandela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21B8C8EE-E376-4654-B181-94C2AC562DFA@xxxxxxxxxxxxxxxx
Les, thanks for getting back to me.

I updated from WSUS v2 to v3 a few weeks ago, and the this problem
seems
to
have started soon after.

I usually use the WSUS console directly from the admin page.

But, I do have an error in the application log for WSUS "self-update
tree"
not working. This error use to be listed in the morning status report,
but
I
still received my report every monring.

I cannot view the report manually anymore (been about a week now), but
I
was
able to.

I also just try to view the node from the Standard Managent - but now
fails
too with a "srcipt error".

I guess I should start down the trouble shooting tree for the WSUS
self-update tree?

What do you think?
--
Sal Candela


"Les Connor [SBS MVP]" wrote:

Hi Sal,

By the error, it seems it's failing on the SBSUpdate Services
reporting.
Is
SBSUpdate Services functioning correctly? Can you view that node in
Standard
Management without errors?

Are you using the default SBS R2 update services (WSUS v2), or have
you
switched to v3?

Can you view the Server Performance Report manually by clicking on the
Monitoring and Reporting node of Standard Management?

Are all automatic services started?

Any other errors in the event viewer that are related to SBS Update
services, WSUS, or IIS?

--
Les Connor [SBS MVP]


"Sal Candela" <SalCandela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C93C159B-5FF3-4B14-969F-C9F563ED4757@xxxxxxxxxxxxxxxx
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
    ... But a server restart trumps that, so don't bother to do it now. ... I restarted the server with no help, and also restarted the Server Reports ... and see if you can view the server report now in the ... >>> preferredCulture, Int32 approvedStates, DateTime fromSyncDate, ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - Sever Status Reports Failing
    ... Have you restarted the server recently? ... From IIS MMC, select your SBS computer object, right click> all tasks> restart IIS and wait until the process is completed. ... This error use to be listed in the morning status report, ... > UpdateCategoryCollection updateCategories, ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - Sever Status Reports Failing
    ... I have a server with that behaviour exactly. ... I can fix that error by restarting either the default app pool, or the wsus app pool, but within a day it's broken again so I don't bother anymore. ... This doesn't prevent the monitoring report from working though, so your issue might be related, but different. ... But a server restart trumps that, so don't bother to do it now. ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - Sever Status Reports Failing
    ... I restarted the server with no help, and also restarted the Server Reports ... I am think of just removeing the WSUS v3, reinstalling v2, what do you think? ... and see if you can view the server report now in the ... preferredCulture, Int32 approvedStates, DateTime fromSyncDate, DateTime ...
    (microsoft.public.windows.server.sbs)
  • Re: No Server Rmt Desktop after applying Msft June Updates
    ... the server did not actually restart. ... suspect it is in some type of "shutdown pending" state which is allowing ... On Monday I will have the customer complete the shutdown / restart. ... I'll report back here with results. ...
    (microsoft.public.windows.server.sbs)