Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 912999 - Last Review: October 27, 2006 - Revision: 1.1
Error message that you receive when you try to use MOM 2005 Reporting to run any one of the reports that are included with the Microsoft Web Sites and Services Management Pack: “Reporting Services Errorâ€
When you try to use Microsoft Operations Manager (MOM) 2005 Reporting to run any one of the reports that are included with the Microsoft Web Sites and Services Management Pack, you receive the following error message:
Reporting Services Error
--------------------------------------------------------------------------------
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'Request_Sequence_Groups'. (rsErrorExecutingCommand) Get Online Help
SELECT permission denied on object 'SC_EventFact_Table', database 'SystemCenterReporting', owner 'dbo'. SELECT permission denied on object 'SC_EventParameterFact_Table', database 'SystemCenterReporting', owner 'dbo'. SELECT permission denied on object 'SC_EventDetailDimension_Table', database 'SystemCenterReporting', owner 'dbo'.
This problem occurs if the reports that are included with Web Sites and Services Management Pack incorrectly reference Microsoft SQL Server database tables in the SystemCenterReporting data warehouse. These reports should instead reference the corresponding SQL views.
A hotfix is unavailable for version 5.0.3025.0000 of the reports that are included with Web Sites and Services Management Pack. However, you can resolve this problem by changing the SQL queries in the report XML file that is included with the Web Sites and Services Management Pack. Then, import the modified report XML file. To do these things, follow these steps:
- Locate the MomWssMPReports.xml file that was extracted when you ran the Microsoft Virtual Server MOM 2005 MP.msi file.
- Make a backup copy of the MomWssMPReports.xml file.
- Right-click MomWssMPReports.xml, click Open With, click Notepad, and then click OK.
- Click Edit, and then click Replace.
- In the Find what box, type _Table.
- In the Replace with box, type _View, and then click Replace All.
- Save the MomWssMPReports.xml file.
- Import the updated MomWssMPReports.xml file to the SQL Reporting Services Web site by using the MOM Administrator console. To do this, follow these steps:
- Right-click Management Packs, click Import/Export Management Pack, and then click Next.
- Click to select the Import Management Packs and/or Reports check box.
-
Type the path of the updated MomWssMPReports.xml file, click to select the Import reports only check box, and then click Next.
- In the list of reports, click the updated MomWssMPReports.xml file, and then click Next.
- After the reports are imported, verify that the users who have only SC Dw Reader group permissions can successfully run the reports.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kbtshoot kbfix kbbug kbprb KB912999 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate