HOWTO: Microsoft Availability Reporting Management Pack for Microsoft Operations Manager 2005

There seems to be a bug in this MP. Many people including me are not getting any data in to the report. They can’t select any report type from the list. I debugged this problem and found a solution.  

If I look in the SQL table MRAS_REPORTRUNLOG I see the following data:

iReportRunLog uidReport                            uidReportSchedule
dtRun                                                  dtScheduled
iStatus
————- ———————————— ————————————
 —————————————————— ——————————————————
 ———–
1             00000000-0000-0000-0000-000000000000
FB1DCDA5-0DC4-48ED-BA8F-ECE3E34C26A4 2005-10-03 09:25:00.000
2005-10-03 09:25:00.000                                2


I see that te istatus = 2 . In the table  MRAS_Reportstatus this stands for
“tagNoData” ???
Strange to me is the uidreport with 00000000-0000-0000-0000-000000000000

I looked in other MRAS tables as “mras_server” there are serveral server
records in it. Here’s one:
uidServer                            nvcServerName
uidDomain                            iState      dtCreate
dtModify
———————————— ——————————————————————————————————————————–
 ———————————— ———– ——————————————————
 ——————————————————
1DC038C9-8F2D-46EA-BB6F-23F3574296D4 VNDMITSINBEL03
26E49633-2817-47AC-8930-101E6367BBF9 0           2005-10-03 07:20:14.890
2005-10-03 07:20:14.890
E


The table MRAS_reportSchedule has this record:


iReportSchedule uidReportSchedule                    nvcName
nvcCall                                                          iState
dtCreate                                               dtModify
————— ———————————— —————————————————————————————————————————————————————————————————————————————————————-
 —————————————————————- ———–
 —————————————————— ——————————————————
5               FB1DCDA5-0DC4-48ED-BA8F-ECE3E34C26A4 test
dbo.MRAS_pcGenerateMRASReport                                    0
2005-10-05 12:29:29.173                                2005-10-05
12:29:29.173


It seems that all data is collected good but the uidreport is standing wrong.
I did an update in the table MRAS_ReportRunLog. Changed
00000000-0000-0000-0000-000000000000 to FB1DCDA5-0DC4-48ED-BA8F-ECE3E34C26A4

This did the trick .After reschedule and rerun with the MMC and scheduled tasks the report.  I’ m getting reports with data now.

Michel