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
One comment
I have same problem but the solution didn’t work out
Willy