MSSQL$SBSMONITORING - problem since KB948110 install

I have had SBS Monitoring and Reorting running fine for months but the last
week it has not produced a single daily performance report. The email is
sent but just says 'Page cannot be dispayed'. Same error when I try running
it in Server Management.

I've tried the suggested solutions such as restarting the server, which in
the past has resolved the issue, but still the same error. I'm sure it has
happened since installing the KB948110 update to MSDE 2000 SQL databases.

When I upgraded to R2, I recall the SBSMONITORING instance didn't support
SQL 2005, has this changed now? Can I run it from SQL 2005 instead?

If not, does anyone have any similar issues with this update?

Event Viewer shows an error (Event ID:1) just after 6am when email is due:
Server Status Report:
URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
Error Message: The specified item could not be found in the database.
Stack Trace: at
Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String id)
at
Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
at
Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
start, DateTime end, String GroupName)
at
Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider dataProvider, WSUS_GROUPS groupID)
at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
at usage.frmPerf.renderReportWorker()
at usage.frmPerf.renderReport()

Any help much appreciated.
Thanks

Chris

On Jul 21, 11:47*am, Chris <Ch...@discussions.microsoft.com> wrote:
> I have had SBS Monitoring and Reorting running fine for months but the last
> week it has not produced a single daily performance report. *The email is
> sent but just says 'Page cannot be dispayed'. *Same error when I try running
> it in Server Management.
>
> I've tried the suggested solutions such as restarting the server, which in
> the past has resolved the issue, but still the same error. *I'm sure ithas
> happened since installing the KB948110 update to MSDE 2000 SQL databases.
>
> When I upgraded to R2, I recall the SBSMONITORING instance didn't support
> SQL 2005, has this changed now? *Can I run it from SQL 2005 instead?
>
> If not, does anyone have any similar issues with this update?
>
> Event Viewer shows an error (Event ID:1) just after 6am when email is due:
> Server Status Report:
> * * * * URL: * * * * * *http://localhost/monitoring/perf.asp...e=1&allHours=1
> * * * * Error Message: *The specified item could not be found in the database.
> * * * * Stack Trace: * * * at
> Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPG*etComputerById(String id)
> * *at
> Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
> * *at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> * *at
> Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTi*me
> start, DateTime end, String GroupName)
> * *at
> Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGrou*p(DataProvider dataProvider, WSUS_GROUPS groupID)
> * *at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> * *at usage.frmPerf.renderReportWorker()
> * *at usage.frmPerf.renderReport()
>
> Any help much appreciated.
> Thanks
>
> Chris

I'll take a swing at it:

Have you tried starting the SQL servers from SQL Server Service
Manager? I had similar problems with WSUS and various reporting
services. After clicking around *way* to long, I checked the SQL Agent
and found that some SQL servers simply weren't running. After
selecting the affected servers from the drop-down menu, I clicked the
"Start/Continue" button, and things have been fine ever since.
Joseph

Hi chris,

Exactly the same issue here on 2x SBS servers. I didn't know it was related
to the kb install.
-Would appreciate soem advice from those in the know.

Rob.

"Chris" wrote:

> I have had SBS Monitoring and Reorting running fine for months but the last
> week it has not produced a single daily performance report. The email is
> sent but just says 'Page cannot be dispayed'. Same error when I try running
> it in Server Management.
>
> I've tried the suggested solutions such as restarting the server, which in
> the past has resolved the issue, but still the same error. I'm sure it has
> happened since installing the KB948110 update to MSDE 2000 SQL databases.
>
> When I upgraded to R2, I recall the SBSMONITORING instance didn't support
> SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
>
> If not, does anyone have any similar issues with this update?
>
> Event Viewer shows an error (Event ID:1) just after 6am when email is due:
> Server Status Report:
> URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> Error Message: The specified item could not be found in the database.
> Stack Trace: at
> Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String id)
> at
> Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
> at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> at
> Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> start, DateTime end, String GroupName)
> at
> Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider dataProvider, WSUS_GROUPS groupID)
> at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> at usage.frmPerf.renderReportWorker()
> at usage.frmPerf.renderReport()
>
> Any help much appreciated.
> Thanks
>
> Chris
>

This Explains it.
http://blogs.technet.com/sbs/archive...ng-948110.aspx


Russ

--
Russell Grover - SBITS.Biz
Microsoft Gold Certified Partner
Microsoft Small Business Specialist
World Wide Remote SBS2003 Support - http://www.SBITS.Biz
Get Help Now! http://www.crossloop.com/SBITSdotBiz


"Chris" <Chris@discussions.microsoft.com> wrote in message
news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
>I have had SBS Monitoring and Reorting running fine for months but the last
> week it has not produced a single daily performance report. The email is
> sent but just says 'Page cannot be dispayed'. Same error when I try
> running
> it in Server Management.
>
> I've tried the suggested solutions such as restarting the server, which in
> the past has resolved the issue, but still the same error. I'm sure it
> has
> happened since installing the KB948110 update to MSDE 2000 SQL databases.
>
> When I upgraded to R2, I recall the SBSMONITORING instance didn't support
> SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
>
> If not, does anyone have any similar issues with this update?
>
> Event Viewer shows an error (Event ID:1) just after 6am when email is due:
> Server Status Report:
> URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> Error Message: The specified item could not be found in the database.
> Stack Trace: at
> Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> id)
> at
> Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> id)
> at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> at
> Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> start, DateTime end, String GroupName)
> at
> Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> dataProvider, WSUS_GROUPS groupID)
> at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> at usage.frmPerf.renderReportWorker()
> at usage.frmPerf.renderReport()
>
> Any help much appreciated.
> Thanks
>
> Chris
>

Hi Russ, thanks for the info.
Both my instances, companyweb is fine, just monitoring that's munged.
Anomally?

Rob.

"Russ (www.SBITS.Biz)" wrote:

> This Explains it.
> http://blogs.technet.com/sbs/archive...ng-948110.aspx
>
>
> Russ
>
> --
> Russell Grover - SBITS.Biz
> Microsoft Gold Certified Partner
> Microsoft Small Business Specialist
> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> Get Help Now! http://www.crossloop.com/SBITSdotBiz
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> >I have had SBS Monitoring and Reorting running fine for months but the last
> > week it has not produced a single daily performance report. The email is
> > sent but just says 'Page cannot be dispayed'. Same error when I try
> > running
> > it in Server Management.
> >
> > I've tried the suggested solutions such as restarting the server, which in
> > the past has resolved the issue, but still the same error. I'm sure it
> > has
> > happened since installing the KB948110 update to MSDE 2000 SQL databases.
> >
> > When I upgraded to R2, I recall the SBSMONITORING instance didn't support
> > SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
> >
> > If not, does anyone have any similar issues with this update?
> >
> > Event Viewer shows an error (Event ID:1) just after 6am when email is due:
> > Server Status Report:
> > URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> > Error Message: The specified item could not be found in the database.
> > Stack Trace: at
> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> > id)
> > at
> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> > id)
> > at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> > at
> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> > start, DateTime end, String GroupName)
> > at
> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> > dataProvider, WSUS_GROUPS groupID)
> > at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> > at usage.frmPerf.renderReportWorker()
> > at usage.frmPerf.renderReport()
> >
> > Any help much appreciated.
> > Thanks
> >
> > Chris
> >
>
>
>

Hi Joseph,
Thanks for yuor reply. I think the SQL Service Manager only handles SQL
server instances and not MSDE 2000 ones, which my SBSMONITORING database runs
on.
Also, the services are running ok.
Thanks
Chris


"Joseph O'Brien" wrote:

> On Jul 21, 11:47 am, Chris <Ch...@discussions.microsoft.com> wrote:
> > I have had SBS Monitoring and Reorting running fine for months but the last
> > week it has not produced a single daily performance report. The email is
> > sent but just says 'Page cannot be dispayed'. Same error when I try running
> > it in Server Management.
> >
> > I've tried the suggested solutions such as restarting the server, which in
> > the past has resolved the issue, but still the same error. I'm sure it has
> > happened since installing the KB948110 update to MSDE 2000 SQL databases.
> >
> > When I upgraded to R2, I recall the SBSMONITORING instance didn't support
> > SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
> >
> > If not, does anyone have any similar issues with this update?
> >
> > Event Viewer shows an error (Event ID:1) just after 6am when email is due:
> > Server Status Report:
> > URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> > Error Message: The specified item could not be found in the database.
> > Stack Trace: at
> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGÂ*etComputerById(String id)
> > at
> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
> > at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> > at
> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTiÂ*me
> > start, DateTime end, String GroupName)
> > at
> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGrouÂ*p(DataProvider dataProvider, WSUS_GROUPS groupID)
> > at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> > at usage.frmPerf.renderReportWorker()
> > at usage.frmPerf.renderReport()
> >
> > Any help much appreciated.
> > Thanks
> >
> > Chris
>
> I'll take a swing at it:
>
> Have you tried starting the SQL servers from SQL Server Service
> Manager? I had similar problems with WSUS and various reporting
> services. After clicking around *way* to long, I checked the SQL Agent
> and found that some SQL servers simply weren't running. After
> selecting the affected servers from the drop-down menu, I clicked the
> "Start/Continue" button, and things have been fine ever since.
> Joseph
>
>

Hi Les,
You say you have the same issue with the SBS Reporting but if you reboot the
server does it start working ok again? I've this issue on average once a
month but after a reboot the report runs ok again. That was until this week
after the KB install and now it won't run the report even after a reboot.

I understand your point about WSUS, but my WSUS console runs fine, reports
included. I know SBS does some funny integration of WSUS into the Server
Manager but it's a shame the whole monitoring and reporting function fails
when it comes across an error.

I'll try uninstalling the KB fix to day to see if that helps.
Regards

Chris

"Les Connor [SBS MVP]" wrote:

> I'm not sure the update has anything to do with the monitoring report issue.
> The monitoring report thing is happening all over the place, me included,
> and I don't have the updates installed at this time.
>
> There are, however, a couple of different error messages produced. While
> they're both WSUS related, one is a time-out and another seems to be
> something in the WSUS database 'not found'.
>
> The R2 monitoring report will fail entirely if there's any issue with the
> SBS Update Servcies section of the report. Shame.
>
> --
> Les Connor [SBS MVP]
> ________________________
> Get the SBS BPA here:
> http://support.microsoft.com/kb/940439/en-us
>
>
> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > Hi Russ, thanks for the info.
> > Both my instances, companyweb is fine, just monitoring that's munged.
> > Anomally?
> >
> > Rob.
> >
> > "Russ (www.SBITS.Biz)" wrote:
> >
> >> This Explains it.
> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> >>
> >>
> >> Russ
> >>
> >> --
> >> Russell Grover - SBITS.Biz
> >> Microsoft Gold Certified Partner
> >> Microsoft Small Business Specialist
> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> >>
> >>
> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> >> >I have had SBS Monitoring and Reorting running fine for months but the
> >> >last
> >> > week it has not produced a single daily performance report. The email
> >> > is
> >> > sent but just says 'Page cannot be dispayed'. Same error when I try
> >> > running
> >> > it in Server Management.
> >> >
> >> > I've tried the suggested solutions such as restarting the server, which
> >> > in
> >> > the past has resolved the issue, but still the same error. I'm sure it
> >> > has
> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> >> > databases.
> >> >
> >> > When I upgraded to R2, I recall the SBSMONITORING instance didn't
> >> > support
> >> > SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
> >> >
> >> > If not, does anyone have any similar issues with this update?
> >> >
> >> > Event Viewer shows an error (Event ID:1) just after 6am when email is
> >> > due:
> >> > Server Status Report:
> >> > URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> >> > Error Message: The specified item could not be found in the database.
> >> > Stack Trace: at
> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> >> > id)
> >> > at
> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> >> > id)
> >> > at
> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> >> > at
> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> >> > start, DateTime end, String GroupName)
> >> > at
> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> >> > dataProvider, WSUS_GROUPS groupID)
> >> > at
> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> >> > at usage.frmPerf.renderReportWorker()
> >> > at usage.frmPerf.renderReport()
> >> >
> >> > Any help much appreciated.
> >> > Thanks
> >> >
> >> > Chris
> >> >
> >>
> >>
> >>
>

WSUS continues to work fine, it's just the monitoring report that isn't
generating.

There's a lot of this going on at the moment. In many cases, the issue is
random - some days the report is fine, others not. Logging onto the server
and generating a report most often works, but sometimes not. A restart isn't
a practical resolution, or even a resolution at all.

I don't have the latest updates installed, and am still seeing random
failures of the report, averaging 30% of my installed SBS customers.

--
Les Connor [SBS MVP]
________________________
Get the SBS BPA here:
http://support.microsoft.com/kb/940439/en-us


"Chris" <Chris@discussions.microsoft.com> wrote in message
news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> Hi Les,
> You say you have the same issue with the SBS Reporting but if you reboot
> the
> server does it start working ok again? I've this issue on average once a
> month but after a reboot the report runs ok again. That was until this
> week
> after the KB install and now it won't run the report even after a reboot.
>
> I understand your point about WSUS, but my WSUS console runs fine, reports
> included. I know SBS does some funny integration of WSUS into the Server
> Manager but it's a shame the whole monitoring and reporting function fails
> when it comes across an error.
>
> I'll try uninstalling the KB fix to day to see if that helps.
> Regards
>
> Chris
>
> "Les Connor [SBS MVP]" wrote:
>
>> I'm not sure the update has anything to do with the monitoring report
>> issue.
>> The monitoring report thing is happening all over the place, me included,
>> and I don't have the updates installed at this time.
>>
>> There are, however, a couple of different error messages produced. While
>> they're both WSUS related, one is a time-out and another seems to be
>> something in the WSUS database 'not found'.
>>
>> The R2 monitoring report will fail entirely if there's any issue with the
>> SBS Update Servcies section of the report. Shame.
>>
>> --
>> Les Connor [SBS MVP]
>> ________________________
>> Get the SBS BPA here:
>> http://support.microsoft.com/kb/940439/en-us
>>
>>
>> "Rob C" <RobC@discussions.microsoft.com> wrote in message
>> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
>> > Hi Russ, thanks for the info.
>> > Both my instances, companyweb is fine, just monitoring that's munged.
>> > Anomally?
>> >
>> > Rob.
>> >
>> > "Russ (www.SBITS.Biz)" wrote:
>> >
>> >> This Explains it.
>> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
>> >>
>> >>
>> >> Russ
>> >>
>> >> --
>> >> Russell Grover - SBITS.Biz
>> >> Microsoft Gold Certified Partner
>> >> Microsoft Small Business Specialist
>> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
>> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
>> >>
>> >>
>> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
>> >> >I have had SBS Monitoring and Reorting running fine for months but
>> >> >the
>> >> >last
>> >> > week it has not produced a single daily performance report. The
>> >> > email
>> >> > is
>> >> > sent but just says 'Page cannot be dispayed'. Same error when I try
>> >> > running
>> >> > it in Server Management.
>> >> >
>> >> > I've tried the suggested solutions such as restarting the server,
>> >> > which
>> >> > in
>> >> > the past has resolved the issue, but still the same error. I'm sure
>> >> > it
>> >> > has
>> >> > happened since installing the KB948110 update to MSDE 2000 SQL
>> >> > databases.
>> >> >
>> >> > When I upgraded to R2, I recall the SBSMONITORING instance didn't
>> >> > support
>> >> > SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
>> >> >
>> >> > If not, does anyone have any similar issues with this update?
>> >> >
>> >> > Event Viewer shows an error (Event ID:1) just after 6am when email
>> >> > is
>> >> > due:
>> >> > Server Status Report:
>> >> > URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
>> >> > Error Message: The specified item could not be found in the
>> >> > database.
>> >> > Stack Trace: at
>> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
>> >> > id)
>> >> > at
>> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
>> >> > id)
>> >> > at
>> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
>> >> > at
>> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
>> >> > start, DateTime end, String GroupName)
>> >> > at
>> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
>> >> > dataProvider, WSUS_GROUPS groupID)
>> >> > at
>> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
>> >> > at usage.frmPerf.renderReportWorker()
>> >> > at usage.frmPerf.renderReport()
>> >> >
>> >> > Any help much appreciated.
>> >> > Thanks
>> >> >
>> >> > Chris
>> >> >
>> >>
>> >>
>> >>
>>

With the two servers I am experiancing the issue with, they both failed on
the same day. 14th July fine, and the 15th onwards caput. I cannot tally this
with any update at that time.

Rob.

"Les Connor [SBS MVP]" wrote:

> WSUS continues to work fine, it's just the monitoring report that isn't
> generating.
>
> There's a lot of this going on at the moment. In many cases, the issue is
> random - some days the report is fine, others not. Logging onto the server
> and generating a report most often works, but sometimes not. A restart isn't
> a practical resolution, or even a resolution at all.
>
> I don't have the latest updates installed, and am still seeing random
> failures of the report, averaging 30% of my installed SBS customers.
>
> --
> Les Connor [SBS MVP]
> ________________________
> Get the SBS BPA here:
> http://support.microsoft.com/kb/940439/en-us
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > Hi Les,
> > You say you have the same issue with the SBS Reporting but if you reboot
> > the
> > server does it start working ok again? I've this issue on average once a
> > month but after a reboot the report runs ok again. That was until this
> > week
> > after the KB install and now it won't run the report even after a reboot.
> >
> > I understand your point about WSUS, but my WSUS console runs fine, reports
> > included. I know SBS does some funny integration of WSUS into the Server
> > Manager but it's a shame the whole monitoring and reporting function fails
> > when it comes across an error.
> >
> > I'll try uninstalling the KB fix to day to see if that helps.
> > Regards
> >
> > Chris
> >
> > "Les Connor [SBS MVP]" wrote:
> >
> >> I'm not sure the update has anything to do with the monitoring report
> >> issue.
> >> The monitoring report thing is happening all over the place, me included,
> >> and I don't have the updates installed at this time.
> >>
> >> There are, however, a couple of different error messages produced. While
> >> they're both WSUS related, one is a time-out and another seems to be
> >> something in the WSUS database 'not found'.
> >>
> >> The R2 monitoring report will fail entirely if there's any issue with the
> >> SBS Update Servcies section of the report. Shame.
> >>
> >> --
> >> Les Connor [SBS MVP]
> >> ________________________
> >> Get the SBS BPA here:
> >> http://support.microsoft.com/kb/940439/en-us
> >>
> >>
> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> >> > Hi Russ, thanks for the info.
> >> > Both my instances, companyweb is fine, just monitoring that's munged.
> >> > Anomally?
> >> >
> >> > Rob.
> >> >
> >> > "Russ (www.SBITS.Biz)" wrote:
> >> >
> >> >> This Explains it.
> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> >> >>
> >> >>
> >> >> Russ
> >> >>
> >> >> --
> >> >> Russell Grover - SBITS.Biz
> >> >> Microsoft Gold Certified Partner
> >> >> Microsoft Small Business Specialist
> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> >> >>
> >> >>
> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> >> >> >I have had SBS Monitoring and Reorting running fine for months but
> >> >> >the
> >> >> >last
> >> >> > week it has not produced a single daily performance report. The
> >> >> > email
> >> >> > is
> >> >> > sent but just says 'Page cannot be dispayed'. Same error when I try
> >> >> > running
> >> >> > it in Server Management.
> >> >> >
> >> >> > I've tried the suggested solutions such as restarting the server,
> >> >> > which
> >> >> > in
> >> >> > the past has resolved the issue, but still the same error. I'm sure
> >> >> > it
> >> >> > has
> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> >> >> > databases.
> >> >> >
> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance didn't
> >> >> > support
> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005 instead?
> >> >> >
> >> >> > If not, does anyone have any similar issues with this update?
> >> >> >
> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when email
> >> >> > is
> >> >> > due:
> >> >> > Server Status Report:
> >> >> > URL: http://localhost/monitoring/perf.asp...e=1&allHours=1
> >> >> > Error Message: The specified item could not be found in the
> >> >> > database.
> >> >> > Stack Trace: at
> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> >> >> > id)
> >> >> > at
> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> >> >> > id)
> >> >> > at
> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> >> >> > at
> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> >> >> > start, DateTime end, String GroupName)
> >> >> > at
> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> >> >> > dataProvider, WSUS_GROUPS groupID)
> >> >> > at
> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> >> >> > at usage.frmPerf.renderReportWorker()
> >> >> > at usage.frmPerf.renderReport()
> >> >> >
> >> >> > Any help much appreciated.
> >> >> > Thanks
> >> >> >
> >> >> > Chris
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
>

What anti-virus product do you folks have installed, where you're seeing
this issue?

--
Les Connor [SBS MVP]
________________________
Get the SBS BPA here:
http://support.microsoft.com/kb/940439/en-us


"Rob C" <RobC@discussions.microsoft.com> wrote in message
news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> With the two servers I am experiancing the issue with, they both failed on
> the same day. 14th July fine, and the 15th onwards caput. I cannot tally
> this
> with any update at that time.
>
> Rob.
>
> "Les Connor [SBS MVP]" wrote:
>
>> WSUS continues to work fine, it's just the monitoring report that isn't
>> generating.
>>
>> There's a lot of this going on at the moment. In many cases, the issue is
>> random - some days the report is fine, others not. Logging onto the
>> server
>> and generating a report most often works, but sometimes not. A restart
>> isn't
>> a practical resolution, or even a resolution at all.
>>
>> I don't have the latest updates installed, and am still seeing random
>> failures of the report, averaging 30% of my installed SBS customers.
>>
>> --
>> Les Connor [SBS MVP]
>> ________________________
>> Get the SBS BPA here:
>> http://support.microsoft.com/kb/940439/en-us
>>
>>
>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
>> > Hi Les,
>> > You say you have the same issue with the SBS Reporting but if you
>> > reboot
>> > the
>> > server does it start working ok again? I've this issue on average once
>> > a
>> > month but after a reboot the report runs ok again. That was until this
>> > week
>> > after the KB install and now it won't run the report even after a
>> > reboot.
>> >
>> > I understand your point about WSUS, but my WSUS console runs fine,
>> > reports
>> > included. I know SBS does some funny integration of WSUS into the
>> > Server
>> > Manager but it's a shame the whole monitoring and reporting function
>> > fails
>> > when it comes across an error.
>> >
>> > I'll try uninstalling the KB fix to day to see if that helps.
>> > Regards
>> >
>> > Chris
>> >
>> > "Les Connor [SBS MVP]" wrote:
>> >
>> >> I'm not sure the update has anything to do with the monitoring report
>> >> issue.
>> >> The monitoring report thing is happening all over the place, me
>> >> included,
>> >> and I don't have the updates installed at this time.
>> >>
>> >> There are, however, a couple of different error messages produced.
>> >> While
>> >> they're both WSUS related, one is a time-out and another seems to be
>> >> something in the WSUS database 'not found'.
>> >>
>> >> The R2 monitoring report will fail entirely if there's any issue with
>> >> the
>> >> SBS Update Servcies section of the report. Shame.
>> >>
>> >> --
>> >> Les Connor [SBS MVP]
>> >> ________________________
>> >> Get the SBS BPA here:
>> >> http://support.microsoft.com/kb/940439/en-us
>> >>
>> >>
>> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
>> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
>> >> > Hi Russ, thanks for the info.
>> >> > Both my instances, companyweb is fine, just monitoring that's
>> >> > munged.
>> >> > Anomally?
>> >> >
>> >> > Rob.
>> >> >
>> >> > "Russ (www.SBITS.Biz)" wrote:
>> >> >
>> >> >> This Explains it.
>> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
>> >> >>
>> >> >>
>> >> >> Russ
>> >> >>
>> >> >> --
>> >> >> Russell Grover - SBITS.Biz
>> >> >> Microsoft Gold Certified Partner
>> >> >> Microsoft Small Business Specialist
>> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
>> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
>> >> >>
>> >> >>
>> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
>> >> >> >I have had SBS Monitoring and Reorting running fine for months but
>> >> >> >the
>> >> >> >last
>> >> >> > week it has not produced a single daily performance report. The
>> >> >> > email
>> >> >> > is
>> >> >> > sent but just says 'Page cannot be dispayed'. Same error when I
>> >> >> > try
>> >> >> > running
>> >> >> > it in Server Management.
>> >> >> >
>> >> >> > I've tried the suggested solutions such as restarting the server,
>> >> >> > which
>> >> >> > in
>> >> >> > the past has resolved the issue, but still the same error. I'm
>> >> >> > sure
>> >> >> > it
>> >> >> > has
>> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
>> >> >> > databases.
>> >> >> >
>> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance didn't
>> >> >> > support
>> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005
>> >> >> > instead?
>> >> >> >
>> >> >> > If not, does anyone have any similar issues with this update?
>> >> >> >
>> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when
>> >> >> > email
>> >> >> > is
>> >> >> > due:
>> >> >> > Server Status Report:
>> >> >> > URL:
>> >> >> > http://localhost/monitoring/perf.asp...e=1&allHours=1
>> >> >> > Error Message: The specified item could not be found in the
>> >> >> > database.
>> >> >> > Stack Trace: at
>> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
>> >> >> > id)
>> >> >> > at
>> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
>> >> >> > id)
>> >> >> > at
>> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
>> >> >> > at
>> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
>> >> >> > start, DateTime end, String GroupName)
>> >> >> > at
>> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
>> >> >> > dataProvider, WSUS_GROUPS groupID)
>> >> >> > at
>> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
>> >> >> > at usage.frmPerf.renderReportWorker()
>> >> >> > at usage.frmPerf.renderReport()
>> >> >> >
>> >> >> > Any help much appreciated.
>> >> >> > Thanks
>> >> >> >
>> >> >> > Chris
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>>

Interesting you mention Antivirus.
They run AVG 7.5 Network edition. Another SBS server I admin has the same
AVG but is working fine. All three SBS's are R2 Exchange SP2.
I just noticed I have not run KB948110 on the server that WSUS is functioning.
It must be this that is causing it.
Safe to uninstall the KB from affected machines?

Rob.

"Les Connor [SBS MVP]" wrote:

> What anti-virus product do you folks have installed, where you're seeing
> this issue?
>
> --
> Les Connor [SBS MVP]
> ________________________
> Get the SBS BPA here:
> http://support.microsoft.com/kb/940439/en-us
>
>
> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > With the two servers I am experiancing the issue with, they both failed on
> > the same day. 14th July fine, and the 15th onwards caput. I cannot tally
> > this
> > with any update at that time.
> >
> > Rob.
> >
> > "Les Connor [SBS MVP]" wrote:
> >
> >> WSUS continues to work fine, it's just the monitoring report that isn't
> >> generating.
> >>
> >> There's a lot of this going on at the moment. In many cases, the issue is
> >> random - some days the report is fine, others not. Logging onto the
> >> server
> >> and generating a report most often works, but sometimes not. A restart
> >> isn't
> >> a practical resolution, or even a resolution at all.
> >>
> >> I don't have the latest updates installed, and am still seeing random
> >> failures of the report, averaging 30% of my installed SBS customers.
> >>
> >> --
> >> Les Connor [SBS MVP]
> >> ________________________
> >> Get the SBS BPA here:
> >> http://support.microsoft.com/kb/940439/en-us
> >>
> >>
> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> >> > Hi Les,
> >> > You say you have the same issue with the SBS Reporting but if you
> >> > reboot
> >> > the
> >> > server does it start working ok again? I've this issue on average once
> >> > a
> >> > month but after a reboot the report runs ok again. That was until this
> >> > week
> >> > after the KB install and now it won't run the report even after a
> >> > reboot.
> >> >
> >> > I understand your point about WSUS, but my WSUS console runs fine,
> >> > reports
> >> > included. I know SBS does some funny integration of WSUS into the
> >> > Server
> >> > Manager but it's a shame the whole monitoring and reporting function
> >> > fails
> >> > when it comes across an error.
> >> >
> >> > I'll try uninstalling the KB fix to day to see if that helps.
> >> > Regards
> >> >
> >> > Chris
> >> >
> >> > "Les Connor [SBS MVP]" wrote:
> >> >
> >> >> I'm not sure the update has anything to do with the monitoring report
> >> >> issue.
> >> >> The monitoring report thing is happening all over the place, me
> >> >> included,
> >> >> and I don't have the updates installed at this time.
> >> >>
> >> >> There are, however, a couple of different error messages produced.
> >> >> While
> >> >> they're both WSUS related, one is a time-out and another seems to be
> >> >> something in the WSUS database 'not found'.
> >> >>
> >> >> The R2 monitoring report will fail entirely if there's any issue with
> >> >> the
> >> >> SBS Update Servcies section of the report. Shame.
> >> >>
> >> >> --
> >> >> Les Connor [SBS MVP]
> >> >> ________________________
> >> >> Get the SBS BPA here:
> >> >> http://support.microsoft.com/kb/940439/en-us
> >> >>
> >> >>
> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> >> >> > Hi Russ, thanks for the info.
> >> >> > Both my instances, companyweb is fine, just monitoring that's
> >> >> > munged.
> >> >> > Anomally?
> >> >> >
> >> >> > Rob.
> >> >> >
> >> >> > "Russ (www.SBITS.Biz)" wrote:
> >> >> >
> >> >> >> This Explains it.
> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> >> >> >>
> >> >> >>
> >> >> >> Russ
> >> >> >>
> >> >> >> --
> >> >> >> Russell Grover - SBITS.Biz
> >> >> >> Microsoft Gold Certified Partner
> >> >> >> Microsoft Small Business Specialist
> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> >> >> >>
> >> >> >>
> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> >> >> >> >I have had SBS Monitoring and Reorting running fine for months but
> >> >> >> >the
> >> >> >> >last
> >> >> >> > week it has not produced a single daily performance report. The
> >> >> >> > email
> >> >> >> > is
> >> >> >> > sent but just says 'Page cannot be dispayed'. Same error when I
> >> >> >> > try
> >> >> >> > running
> >> >> >> > it in Server Management.
> >> >> >> >
> >> >> >> > I've tried the suggested solutions such as restarting the server,
> >> >> >> > which
> >> >> >> > in
> >> >> >> > the past has resolved the issue, but still the same error. I'm
> >> >> >> > sure
> >> >> >> > it
> >> >> >> > has
> >> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> >> >> >> > databases.
> >> >> >> >
> >> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance didn't
> >> >> >> > support
> >> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005
> >> >> >> > instead?
> >> >> >> >
> >> >> >> > If not, does anyone have any similar issues with this update?
> >> >> >> >
> >> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when
> >> >> >> > email
> >> >> >> > is
> >> >> >> > due:
> >> >> >> > Server Status Report:
> >> >> >> > URL:
> >> >> >> > http://localhost/monitoring/perf.asp...e=1&allHours=1
> >> >> >> > Error Message: The specified item could not be found in the
> >> >> >> > database.
> >> >> >> > Stack Trace: at
> >> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> >> >> >> > id)
> >> >> >> > at
> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> >> >> >> > id)
> >> >> >> > at
> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> >> >> >> > at
> >> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> >> >> >> > start, DateTime end, String GroupName)
> >> >> >> > at
> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> >> >> >> > dataProvider, WSUS_GROUPS groupID)
> >> >> >> > at
> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> >> >> >> > at usage.frmPerf.renderReportWorker()
> >> >> >> > at usage.frmPerf.renderReport()
> >> >> >> >
> >> >> >> > Any help much appreciated.
> >> >> >> > Thanks
> >> >> >> >
> >> >> >> > Chris
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >>
>

We've seen it before 948110 has been installed, so that IMHO isn't the
trigger.

Rob C wrote:
> Interesting you mention Antivirus.
> They run AVG 7.5 Network edition. Another SBS server I admin has the same
> AVG but is working fine. All three SBS's are R2 Exchange SP2.
> I just noticed I have not run KB948110 on the server that WSUS is functioning.
> It must be this that is causing it.
> Safe to uninstall the KB from affected machines?
>
> Rob.
>
> "Les Connor [SBS MVP]" wrote:
>
>> What anti-virus product do you folks have installed, where you're seeing
>> this issue?
>>
>> --
>> Les Connor [SBS MVP]
>> ________________________
>> Get the SBS BPA here:
>> http://support.microsoft.com/kb/940439/en-us
>>
>>
>> "Rob C" <RobC@discussions.microsoft.com> wrote in message
>> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
>>> With the two servers I am experiancing the issue with, they both failed on
>>> the same day. 14th July fine, and the 15th onwards caput. I cannot tally
>>> this
>>> with any update at that time.
>>>
>>> Rob.
>>>
>>> "Les Connor [SBS MVP]" wrote:
>>>
>>>> WSUS continues to work fine, it's just the monitoring report that isn't
>>>> generating.
>>>>
>>>> There's a lot of this going on at the moment. In many cases, the issue is
>>>> random - some days the report is fine, others not. Logging onto the
>>>> server
>>>> and generating a report most often works, but sometimes not. A restart
>>>> isn't
>>>> a practical resolution, or even a resolution at all.
>>>>
>>>> I don't have the latest updates installed, and am still seeing random
>>>> failures of the report, averaging 30% of my installed SBS customers.
>>>>
>>>> --
>>>> Les Connor [SBS MVP]
>>>> ________________________
>>>> Get the SBS BPA here:
>>>> http://support.microsoft.com/kb/940439/en-us
>>>>
>>>>
>>>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>>>> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
>>>>> Hi Les,
>>>>> You say you have the same issue with the SBS Reporting but if you
>>>>> reboot
>>>>> the
>>>>> server does it start working ok again? I've this issue on average once
>>>>> a
>>>>> month but after a reboot the report runs ok again. That was until this
>>>>> week
>>>>> after the KB install and now it won't run the report even after a
>>>>> reboot.
>>>>>
>>>>> I understand your point about WSUS, but my WSUS console runs fine,
>>>>> reports
>>>>> included. I know SBS does some funny integration of WSUS into the
>>>>> Server
>>>>> Manager but it's a shame the whole monitoring and reporting function
>>>>> fails
>>>>> when it comes across an error.
>>>>>
>>>>> I'll try uninstalling the KB fix to day to see if that helps.
>>>>> Regards
>>>>>
>>>>> Chris
>>>>>
>>>>> "Les Connor [SBS MVP]" wrote:
>>>>>
>>>>>> I'm not sure the update has anything to do with the monitoring report
>>>>>> issue.
>>>>>> The monitoring report thing is happening all over the place, me
>>>>>> included,
>>>>>> and I don't have the updates installed at this time.
>>>>>>
>>>>>> There are, however, a couple of different error messages produced.
>>>>>> While
>>>>>> they're both WSUS related, one is a time-out and another seems to be
>>>>>> something in the WSUS database 'not found'.
>>>>>>
>>>>>> The R2 monitoring report will fail entirely if there's any issue with
>>>>>> the
>>>>>> SBS Update Servcies section of the report. Shame.
>>>>>>
>>>>>> --
>>>>>> Les Connor [SBS MVP]
>>>>>> ________________________
>>>>>> Get the SBS BPA here:
>>>>>> http://support.microsoft.com/kb/940439/en-us
>>>>>>
>>>>>>
>>>>>> "Rob C" <RobC@discussions.microsoft.com> wrote in message
>>>>>> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
>>>>>>> Hi Russ, thanks for the info.
>>>>>>> Both my instances, companyweb is fine, just monitoring that's
>>>>>>> munged.
>>>>>>> Anomally?
>>>>>>>
>>>>>>> Rob.
>>>>>>>
>>>>>>> "Russ (www.SBITS.Biz)" wrote:
>>>>>>>
>>>>>>>> This Explains it.
>>>>>>>> http://blogs.technet.com/sbs/archive...ng-948110.aspx
>>>>>>>>
>>>>>>>>
>>>>>>>> Russ
>>>>>>>>
>>>>>>>> --
>>>>>>>> Russell Grover - SBITS.Biz
>>>>>>>> Microsoft Gold Certified Partner
>>>>>>>> Microsoft Small Business Specialist
>>>>>>>> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
>>>>>>>> Get Help Now! http://www.crossloop.com/SBITSdotBiz
>>>>>>>>
>>>>>>>>
>>>>>>>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>>>>>>>> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
>>>>>>>>> I have had SBS Monitoring and Reorting running fine for months but
>>>>>>>>> the
>>>>>>>>> last
>>>>>>>>> week it has not produced a single daily performance report. The
>>>>>>>>> email
>>>>>>>>> is
>>>>>>>>> sent but just says 'Page cannot be dispayed'. Same error when I
>>>>>>>>> try
>>>>>>>>> running
>>>>>>>>> it in Server Management.
>>>>>>>>>
>>>>>>>>> I've tried the suggested solutions such as restarting the server,
>>>>>>>>> which
>>>>>>>>> in
>>>>>>>>> the past has resolved the issue, but still the same error. I'm
>>>>>>>>> sure
>>>>>>>>> it
>>>>>>>>> has
>>>>>>>>> happened since installing the KB948110 update to MSDE 2000 SQL
>>>>>>>>> databases.
>>>>>>>>>
>>>>>>>>> When I upgraded to R2, I recall the SBSMONITORING instance didn't
>>>>>>>>> support
>>>>>>>>> SQL 2005, has this changed now? Can I run it from SQL 2005
>>>>>>>>> instead?
>>>>>>>>>
>>>>>>>>> If not, does anyone have any similar issues with this update?
>>>>>>>>>
>>>>>>>>> Event Viewer shows an error (Event ID:1) just after 6am when
>>>>>>>>> email
>>>>>>>>> is
>>>>>>>>> due:
>>>>>>>>> Server Status Report:
>>>>>>>>> URL:
>>>>>>>>> http://localhost/monitoring/perf.asp...e=1&allHours=1
>>>>>>>>> Error Message: The specified item could not be found in the
>>>>>>>>> database.
>>>>>>>>> Stack Trace: at
>>>>>>>>> Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
>>>>>>>>> id)
>>>>>>>>> at
>>>>>>>>> Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
>>>>>>>>> id)
>>>>>>>>> at
>>>>>>>>> Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
>>>>>>>>> at
>>>>>>>>> Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
>>>>>>>>> start, DateTime end, String GroupName)
>>>>>>>>> at
>>>>>>>>> Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
>>>>>>>>> dataProvider, WSUS_GROUPS groupID)
>>>>>>>>> at
>>>>>>>>> Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
>>>>>>>>> at usage.frmPerf.renderReportWorker()
>>>>>>>>> at usage.frmPerf.renderReport()
>>>>>>>>>
>>>>>>>>> Any help much appreciated.
>>>>>>>>> Thanks
>>>>>>>>>
>>>>>>>>> Chris
>>>>>>>>>
>>>>>>>>
>>>>>>>>

Chris,

Did you uninstall the kb and has it fixed the problem?

Rob.

"Les Connor [SBS MVP]" wrote:

> I'm getting malfunctions without the July updates (which include the one
> you're referencing). A/V doesn't appear to be common ground either, but I
> needed to check.
>
>
> --
> Les Connor [SBS MVP]
> ________________________
> Get the SBS BPA here:
> http://support.microsoft.com/kb/940439/en-us
>
>
> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > Interesting you mention Antivirus.
> > They run AVG 7.5 Network edition. Another SBS server I admin has the same
> > AVG but is working fine. All three SBS's are R2 Exchange SP2.
> > I just noticed I have not run KB948110 on the server that WSUS is
> > functioning.
> > It must be this that is causing it.
> > Safe to uninstall the KB from affected machines?
> >
> > Rob.
> >
> > "Les Connor [SBS MVP]" wrote:
> >
> >> What anti-virus product do you folks have installed, where you're seeing
> >> this issue?
> >>
> >> --
> >> Les Connor [SBS MVP]
> >> ________________________
> >> Get the SBS BPA here:
> >> http://support.microsoft.com/kb/940439/en-us
> >>
> >>
> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> >> > With the two servers I am experiancing the issue with, they both failed
> >> > on
> >> > the same day. 14th July fine, and the 15th onwards caput. I cannot
> >> > tally
> >> > this
> >> > with any update at that time.
> >> >
> >> > Rob.
> >> >
> >> > "Les Connor [SBS MVP]" wrote:
> >> >
> >> >> WSUS continues to work fine, it's just the monitoring report that
> >> >> isn't
> >> >> generating.
> >> >>
> >> >> There's a lot of this going on at the moment. In many cases, the issue
> >> >> is
> >> >> random - some days the report is fine, others not. Logging onto the
> >> >> server
> >> >> and generating a report most often works, but sometimes not. A restart
> >> >> isn't
> >> >> a practical resolution, or even a resolution at all.
> >> >>
> >> >> I don't have the latest updates installed, and am still seeing random
> >> >> failures of the report, averaging 30% of my installed SBS customers.
> >> >>
> >> >> --
> >> >> Les Connor [SBS MVP]
> >> >> ________________________
> >> >> Get the SBS BPA here:
> >> >> http://support.microsoft.com/kb/940439/en-us
> >> >>
> >> >>
> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> >> >> > Hi Les,
> >> >> > You say you have the same issue with the SBS Reporting but if you
> >> >> > reboot
> >> >> > the
> >> >> > server does it start working ok again? I've this issue on average
> >> >> > once
> >> >> > a
> >> >> > month but after a reboot the report runs ok again. That was until
> >> >> > this
> >> >> > week
> >> >> > after the KB install and now it won't run the report even after a
> >> >> > reboot.
> >> >> >
> >> >> > I understand your point about WSUS, but my WSUS console runs fine,
> >> >> > reports
> >> >> > included. I know SBS does some funny integration of WSUS into the
> >> >> > Server
> >> >> > Manager but it's a shame the whole monitoring and reporting function
> >> >> > fails
> >> >> > when it comes across an error.
> >> >> >
> >> >> > I'll try uninstalling the KB fix to day to see if that helps.
> >> >> > Regards
> >> >> >
> >> >> > Chris
> >> >> >
> >> >> > "Les Connor [SBS MVP]" wrote:
> >> >> >
> >> >> >> I'm not sure the update has anything to do with the monitoring
> >> >> >> report
> >> >> >> issue.
> >> >> >> The monitoring report thing is happening all over the place, me
> >> >> >> included,
> >> >> >> and I don't have the updates installed at this time.
> >> >> >>
> >> >> >> There are, however, a couple of different error messages produced.
> >> >> >> While
> >> >> >> they're both WSUS related, one is a time-out and another seems to
> >> >> >> be
> >> >> >> something in the WSUS database 'not found'.
> >> >> >>
> >> >> >> The R2 monitoring report will fail entirely if there's any issue
> >> >> >> with
> >> >> >> the
> >> >> >> SBS Update Servcies section of the report. Shame.
> >> >> >>
> >> >> >> --
> >> >> >> Les Connor [SBS MVP]
> >> >> >> ________________________
> >> >> >> Get the SBS BPA here:
> >> >> >> http://support.microsoft.com/kb/940439/en-us
> >> >> >>
> >> >> >>
> >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> >> >> >> > Hi Russ, thanks for the info.
> >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> >> >> >> > munged.
> >> >> >> > Anomally?
> >> >> >> >
> >> >> >> > Rob.
> >> >> >> >
> >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> >> >> >> >
> >> >> >> >> This Explains it.
> >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> Russ
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Russell Grover - SBITS.Biz
> >> >> >> >> Microsoft Gold Certified Partner
> >> >> >> >> Microsoft Small Business Specialist
> >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> >> >> >> >> >I have had SBS Monitoring and Reorting running fine for months
> >> >> >> >> >but
> >> >> >> >> >the
> >> >> >> >> >last
> >> >> >> >> > week it has not produced a single daily performance report.
> >> >> >> >> > The
> >> >> >> >> > email
> >> >> >> >> > is
> >> >> >> >> > sent but just says 'Page cannot be dispayed'. Same error when
> >> >> >> >> > I
> >> >> >> >> > try
> >> >> >> >> > running
> >> >> >> >> > it in Server Management.
> >> >> >> >> >
> >> >> >> >> > I've tried the suggested solutions such as restarting the
> >> >> >> >> > server,
> >> >> >> >> > which
> >> >> >> >> > in
> >> >> >> >> > the past has resolved the issue, but still the same error.
> >> >> >> >> > I'm
> >> >> >> >> > sure
> >> >> >> >> > it
> >> >> >> >> > has
> >> >> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> >> >> >> >> > databases.
> >> >> >> >> >
> >> >> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance
> >> >> >> >> > didn't
> >> >> >> >> > support
> >> >> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005
> >> >> >> >> > instead?
> >> >> >> >> >
> >> >> >> >> > If not, does anyone have any similar issues with this update?
> >> >> >> >> >
> >> >> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when
> >> >> >> >> > email
> >> >> >> >> > is
> >> >> >> >> > due:
> >> >> >> >> > Server Status Report:
> >> >> >> >> > URL:
> >> >> >> >> > http://localhost/monitoring/perf.asp...e=1&allHours=1
> >> >> >> >> > Error Message: The specified item could not be found in the
> >> >> >> >> > database.
> >> >> >> >> > Stack Trace: at
> >> >> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> >> >> >> >> > id)
> >> >> >> >> > at
> >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> >> >> >> >> > id)
> >> >> >> >> > at
> >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> >> >> >> >> > at
> >> >> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> >> >> >> >> > start, DateTime end, String GroupName)
> >> >> >> >> > at
> >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> >> >> >> >> > dataProvider, WSUS_GROUPS groupID)
> >> >> >> >> > at
> >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> >> >> >> >> > at usage.frmPerf.renderReportWorker()
> >> >> >> >> > at usage.frmPerf.renderReport()
> >> >> >> >> >
> >> >> >> >> > Any help much appreciated.
> >> >> >> >> > Thanks
> >> >> >> >> >
> >> >> >> >> > Chris
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >>
>

Hi Rob C,

I did uninstall but it hasn't been rebooted (it didn't ask to be). It
didn't resolve the issue.

I'll try rebooting tonight and see if that helps. Will report back in the
morning.

Regards

Chris


"Rob C" wrote:

> Chris,
>
> Did you uninstall the kb and has it fixed the problem?
>
> Rob.
>
> "Les Connor [SBS MVP]" wrote:
>
> > I'm getting malfunctions without the July updates (which include the one
> > you're referencing). A/V doesn't appear to be common ground either, but I
> > needed to check.
> >
> >
> > --
> > Les Connor [SBS MVP]
> > ________________________
> > Get the SBS BPA here:
> > http://support.microsoft.com/kb/940439/en-us
> >
> >
> > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > Interesting you mention Antivirus.
> > > They run AVG 7.5 Network edition. Another SBS server I admin has the same
> > > AVG but is working fine. All three SBS's are R2 Exchange SP2.
> > > I just noticed I have not run KB948110 on the server that WSUS is
> > > functioning.
> > > It must be this that is causing it.
> > > Safe to uninstall the KB from affected machines?
> > >
> > > Rob.
> > >
> > > "Les Connor [SBS MVP]" wrote:
> > >
> > >> What anti-virus product do you folks have installed, where you're seeing
> > >> this issue?
> > >>
> > >> --
> > >> Les Connor [SBS MVP]
> > >> ________________________
> > >> Get the SBS BPA here:
> > >> http://support.microsoft.com/kb/940439/en-us
> > >>
> > >>
> > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > >> > With the two servers I am experiancing the issue with, they both failed
> > >> > on
> > >> > the same day. 14th July fine, and the 15th onwards caput. I cannot
> > >> > tally
> > >> > this
> > >> > with any update at that time.
> > >> >
> > >> > Rob.
> > >> >
> > >> > "Les Connor [SBS MVP]" wrote:
> > >> >
> > >> >> WSUS continues to work fine, it's just the monitoring report that
> > >> >> isn't
> > >> >> generating.
> > >> >>
> > >> >> There's a lot of this going on at the moment. In many cases, the issue
> > >> >> is
> > >> >> random - some days the report is fine, others not. Logging onto the
> > >> >> server
> > >> >> and generating a report most often works, but sometimes not. A restart
> > >> >> isn't
> > >> >> a practical resolution, or even a resolution at all.
> > >> >>
> > >> >> I don't have the latest updates installed, and am still seeing random
> > >> >> failures of the report, averaging 30% of my installed SBS customers.
> > >> >>
> > >> >> --
> > >> >> Les Connor [SBS MVP]
> > >> >> ________________________
> > >> >> Get the SBS BPA here:
> > >> >> http://support.microsoft.com/kb/940439/en-us
> > >> >>
> > >> >>
> > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > >> >> > Hi Les,
> > >> >> > You say you have the same issue with the SBS Reporting but if you
> > >> >> > reboot
> > >> >> > the
> > >> >> > server does it start working ok again? I've this issue on average
> > >> >> > once
> > >> >> > a
> > >> >> > month but after a reboot the report runs ok again. That was until
> > >> >> > this
> > >> >> > week
> > >> >> > after the KB install and now it won't run the report even after a
> > >> >> > reboot.
> > >> >> >
> > >> >> > I understand your point about WSUS, but my WSUS console runs fine,
> > >> >> > reports
> > >> >> > included. I know SBS does some funny integration of WSUS into the
> > >> >> > Server
> > >> >> > Manager but it's a shame the whole monitoring and reporting function
> > >> >> > fails
> > >> >> > when it comes across an error.
> > >> >> >
> > >> >> > I'll try uninstalling the KB fix to day to see if that helps.
> > >> >> > Regards
> > >> >> >
> > >> >> > Chris
> > >> >> >
> > >> >> > "Les Connor [SBS MVP]" wrote:
> > >> >> >
> > >> >> >> I'm not sure the update has anything to do with the monitoring
> > >> >> >> report
> > >> >> >> issue.
> > >> >> >> The monitoring report thing is happening all over the place, me
> > >> >> >> included,
> > >> >> >> and I don't have the updates installed at this time.
> > >> >> >>
> > >> >> >> There are, however, a couple of different error messages produced.
> > >> >> >> While
> > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > >> >> >> be
> > >> >> >> something in the WSUS database 'not found'.
> > >> >> >>
> > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > >> >> >> with
> > >> >> >> the
> > >> >> >> SBS Update Servcies section of the report. Shame.
> > >> >> >>
> > >> >> >> --
> > >> >> >> Les Connor [SBS MVP]
> > >> >> >> ________________________
> > >> >> >> Get the SBS BPA here:
> > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > >> >> >>
> > >> >> >>
> > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > >> >> >> > Hi Russ, thanks for the info.
> > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > >> >> >> > munged.
> > >> >> >> > Anomally?
> > >> >> >> >
> > >> >> >> > Rob.
> > >> >> >> >
> > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > >> >> >> >
> > >> >> >> >> This Explains it.
> > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> Russ
> > >> >> >> >>
> > >> >> >> >> --
> > >> >> >> >> Russell Grover - SBITS.Biz
> > >> >> >> >> Microsoft Gold Certified Partner
> > >> >> >> >> Microsoft Small Business Specialist
> > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > >> >> >> >> >I have had SBS Monitoring and Reorting running fine for months
> > >> >> >> >> >but
> > >> >> >> >> >the
> > >> >> >> >> >last
> > >> >> >> >> > week it has not produced a single daily performance report.
> > >> >> >> >> > The
> > >> >> >> >> > email
> > >> >> >> >> > is
> > >> >> >> >> > sent but just says 'Page cannot be dispayed'. Same error when
> > >> >> >> >> > I
> > >> >> >> >> > try
> > >> >> >> >> > running
> > >> >> >> >> > it in Server Management.
> > >> >> >> >> >
> > >> >> >> >> > I've tried the suggested solutions such as restarting the
> > >> >> >> >> > server,
> > >> >> >> >> > which
> > >> >> >> >> > in
> > >> >> >> >> > the past has resolved the issue, but still the same error.
> > >> >> >> >> > I'm
> > >> >> >> >> > sure
> > >> >> >> >> > it
> > >> >> >> >> > has
> > >> >> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> > >> >> >> >> > databases.
> > >> >> >> >> >
> > >> >> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance
> > >> >> >> >> > didn't
> > >> >> >> >> > support
> > >> >> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005
> > >> >> >> >> > instead?
> > >> >> >> >> >
> > >> >> >> >> > If not, does anyone have any similar issues with this update?
> > >> >> >> >> >
> > >> >> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when
> > >> >> >> >> > email
> > >> >> >> >> > is
> > >> >> >> >> > due:
> > >> >> >> >> > Server Status Report:
> > >> >> >> >> > URL:
> > >> >> >> >> > http://localhost/monitoring/perf.asp...e=1&allHours=1
> > >> >> >> >> > Error Message: The specified item could not be found in the
> > >> >> >> >> > database.
> > >> >> >> >> > Stack Trace: at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> > >> >> >> >> > id)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> > >> >> >> >> > id)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> > >> >> >> >> > start, DateTime end, String GroupName)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> > >> >> >> >> > dataProvider, WSUS_GROUPS groupID)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> > >> >> >> >> > at usage.frmPerf.renderReportWorker()
> > >> >> >> >> > at usage.frmPerf.renderReport()
> > >> >> >> >> >
> > >> >> >> >> > Any help much appreciated.
> > >> >> >> >> > Thanks
> > >> >> >> >> >
> > >> >> >> >> > Chris
> > >> >> >> >> >
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >>
> > >> >>
> > >>
> >

Hi,

Tried uninstalling the KB and rebooted but the report still doesn't run.

Back to square one...

Chris


"Rob C" wrote:

> Chris,
>
> Did you uninstall the kb and has it fixed the problem?
>
> Rob.
>
> "Les Connor [SBS MVP]" wrote:
>
> > I'm getting malfunctions without the July updates (which include the one
> > you're referencing). A/V doesn't appear to be common ground either, but I
> > needed to check.
> >
> >
> > --
> > Les Connor [SBS MVP]
> > ________________________
> > Get the SBS BPA here:
> > http://support.microsoft.com/kb/940439/en-us
> >
> >
> > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > Interesting you mention Antivirus.
> > > They run AVG 7.5 Network edition. Another SBS server I admin has the same
> > > AVG but is working fine. All three SBS's are R2 Exchange SP2.
> > > I just noticed I have not run KB948110 on the server that WSUS is
> > > functioning.
> > > It must be this that is causing it.
> > > Safe to uninstall the KB from affected machines?
> > >
> > > Rob.
> > >
> > > "Les Connor [SBS MVP]" wrote:
> > >
> > >> What anti-virus product do you folks have installed, where you're seeing
> > >> this issue?
> > >>
> > >> --
> > >> Les Connor [SBS MVP]
> > >> ________________________
> > >> Get the SBS BPA here:
> > >> http://support.microsoft.com/kb/940439/en-us
> > >>
> > >>
> > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > >> > With the two servers I am experiancing the issue with, they both failed
> > >> > on
> > >> > the same day. 14th July fine, and the 15th onwards caput. I cannot
> > >> > tally
> > >> > this
> > >> > with any update at that time.
> > >> >
> > >> > Rob.
> > >> >
> > >> > "Les Connor [SBS MVP]" wrote:
> > >> >
> > >> >> WSUS continues to work fine, it's just the monitoring report that
> > >> >> isn't
> > >> >> generating.
> > >> >>
> > >> >> There's a lot of this going on at the moment. In many cases, the issue
> > >> >> is
> > >> >> random - some days the report is fine, others not. Logging onto the
> > >> >> server
> > >> >> and generating a report most often works, but sometimes not. A restart
> > >> >> isn't
> > >> >> a practical resolution, or even a resolution at all.
> > >> >>
> > >> >> I don't have the latest updates installed, and am still seeing random
> > >> >> failures of the report, averaging 30% of my installed SBS customers.
> > >> >>
> > >> >> --
> > >> >> Les Connor [SBS MVP]
> > >> >> ________________________
> > >> >> Get the SBS BPA here:
> > >> >> http://support.microsoft.com/kb/940439/en-us
> > >> >>
> > >> >>
> > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > >> >> > Hi Les,
> > >> >> > You say you have the same issue with the SBS Reporting but if you
> > >> >> > reboot
> > >> >> > the
> > >> >> > server does it start working ok again? I've this issue on average
> > >> >> > once
> > >> >> > a
> > >> >> > month but after a reboot the report runs ok again. That was until
> > >> >> > this
> > >> >> > week
> > >> >> > after the KB install and now it won't run the report even after a
> > >> >> > reboot.
> > >> >> >
> > >> >> > I understand your point about WSUS, but my WSUS console runs fine,
> > >> >> > reports
> > >> >> > included. I know SBS does some funny integration of WSUS into the
> > >> >> > Server
> > >> >> > Manager but it's a shame the whole monitoring and reporting function
> > >> >> > fails
> > >> >> > when it comes across an error.
> > >> >> >
> > >> >> > I'll try uninstalling the KB fix to day to see if that helps.
> > >> >> > Regards
> > >> >> >
> > >> >> > Chris
> > >> >> >
> > >> >> > "Les Connor [SBS MVP]" wrote:
> > >> >> >
> > >> >> >> I'm not sure the update has anything to do with the monitoring
> > >> >> >> report
> > >> >> >> issue.
> > >> >> >> The monitoring report thing is happening all over the place, me
> > >> >> >> included,
> > >> >> >> and I don't have the updates installed at this time.
> > >> >> >>
> > >> >> >> There are, however, a couple of different error messages produced.
> > >> >> >> While
> > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > >> >> >> be
> > >> >> >> something in the WSUS database 'not found'.
> > >> >> >>
> > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > >> >> >> with
> > >> >> >> the
> > >> >> >> SBS Update Servcies section of the report. Shame.
> > >> >> >>
> > >> >> >> --
> > >> >> >> Les Connor [SBS MVP]
> > >> >> >> ________________________
> > >> >> >> Get the SBS BPA here:
> > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > >> >> >>
> > >> >> >>
> > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > >> >> >> > Hi Russ, thanks for the info.
> > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > >> >> >> > munged.
> > >> >> >> > Anomally?
> > >> >> >> >
> > >> >> >> > Rob.
> > >> >> >> >
> > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > >> >> >> >
> > >> >> >> >> This Explains it.
> > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> Russ
> > >> >> >> >>
> > >> >> >> >> --
> > >> >> >> >> Russell Grover - SBITS.Biz
> > >> >> >> >> Microsoft Gold Certified Partner
> > >> >> >> >> Microsoft Small Business Specialist
> > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > >> >> >> >> >I have had SBS Monitoring and Reorting running fine for months
> > >> >> >> >> >but
> > >> >> >> >> >the
> > >> >> >> >> >last
> > >> >> >> >> > week it has not produced a single daily performance report.
> > >> >> >> >> > The
> > >> >> >> >> > email
> > >> >> >> >> > is
> > >> >> >> >> > sent but just says 'Page cannot be dispayed'. Same error when
> > >> >> >> >> > I
> > >> >> >> >> > try
> > >> >> >> >> > running
> > >> >> >> >> > it in Server Management.
> > >> >> >> >> >
> > >> >> >> >> > I've tried the suggested solutions such as restarting the
> > >> >> >> >> > server,
> > >> >> >> >> > which
> > >> >> >> >> > in
> > >> >> >> >> > the past has resolved the issue, but still the same error.
> > >> >> >> >> > I'm
> > >> >> >> >> > sure
> > >> >> >> >> > it
> > >> >> >> >> > has
> > >> >> >> >> > happened since installing the KB948110 update to MSDE 2000 SQL
> > >> >> >> >> > databases.
> > >> >> >> >> >
> > >> >> >> >> > When I upgraded to R2, I recall the SBSMONITORING instance
> > >> >> >> >> > didn't
> > >> >> >> >> > support
> > >> >> >> >> > SQL 2005, has this changed now? Can I run it from SQL 2005
> > >> >> >> >> > instead?
> > >> >> >> >> >
> > >> >> >> >> > If not, does anyone have any similar issues with this update?
> > >> >> >> >> >
> > >> >> >> >> > Event Viewer shows an error (Event ID:1) just after 6am when
> > >> >> >> >> > email
> > >> >> >> >> > is
> > >> >> >> >> > due:
> > >> >> >> >> > Server Status Report:
> > >> >> >> >> > URL:
> > >> >> >> >> > http://localhost/monitoring/perf.asp...e=1&allHours=1
> > >> >> >> >> > Error Message: The specified item could not be found in the
> > >> >> >> >> > database.
> > >> >> >> >> > Stack Trace: at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String
> > >> >> >> >> > id)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String
> > >> >> >> >> > id)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
> > >> >> >> >> > start, DateTime end, String GroupName)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider
> > >> >> >> >> > dataProvider, WSUS_GROUPS groupID)
> > >> >> >> >> > at
> > >> >> >> >> > Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
> > >> >> >> >> > at usage.frmPerf.renderReportWorker()
> > >> >> >> >> > at usage.frmPerf.renderReport()
> > >> >> >> >> >
> > >> >> >> >> > Any help much appreciated.
> > >> >> >> >> > Thanks
> > >> >> >> >> >
> > >> >> >> >> > Chris
> > >> >> >> >> >
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >>
> > >> >>
> > >>
> >