Did you lose your Processor data after updating to Base OS MP version 6.0.6989.0?
Download these updated RDL Files and upload them to your reporting server instance to get Processor % back in your Utilization reports.
Utilization Report Addendum: http://www.scomgod.com/wp-content/uploads/2012/12/SCOM_GOD_Processor_Information_Addendum.zip
Performance by System Report Addendum: http://www.scomgod.com/wp-content/uploads/2012/12/SCOM_GOD_Microsoft.Windows.Server.Reports.PerformanceBySystem2.zip
Thanks for your files.
I have tried these and get an error:
Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run.
Microsoft.Reporting.WinForms.ReportServerException: The report server cannot process the report or shared dataset. The shared data source ‘DataWarehouseMain’ for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)
at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
My Guess, the reports were build in 2005, we are using 2008 R2. Is this the case?
Hello and thanks for the comment. You need to go into the properties of the report in your report server web interface and set the properties of the data source. This is well documented in other SCOM reporting blog posts.
A++! Thank you. Perfect and solved a huge headache.
No problem. It saved my ass too! What a hassle. :)
can you please tell me what you did to fix this , I am very new to this and facing the same problem
what is the location i need to upload these files
Thanks in Advance
Hi you need to open your ReportServer Web UI and select the folder you wish to place them, I would choose the Windows Server Reports, where the originals are. Choose upload to upload the files there. You then need to adjust report to connect to the DW.
I should have done a step by step for this but all of the information needed to add RDL files is on the Web. You need to learn how to manage ReportServer and all of that info can be found with simple google searches. :)
Hi!
Where to put the files at the reporting area?? Quite unclear!!
Ok, found it on another page. But how to configure the data connection. is it oledb with the DWR account or what. Can’t get the results from the report
Nicklas – you need to select Details to and then browse the tree to see the DW option.
Or use:
Provider=SQLOLEDB;Server=YOUR-SERVER;Database=OperationsManagerDW;Integrated Security=SSPI
Anyone have problems with this not returning data for non-R2 servers? I can get data for 2008 R2, but non-R2 servers still show nothing.
Thanks
Jay
Jay,
My report will populate processor for Windows 2008R2.
Have you deployed it?
The issue you are possibly having is rectified with my update.
Thanks
SCOM GAWD
Hi SG,
Yes, 2008 R2 servers return CPU time data fine, its the non-R2 servers that are not returning anything.
Thanks
Jay
I don’t have any suggestions unfortunately. My report returns both for me successfully in SCOM 2012 SP1 and 2007 R2.
Well, that sucks
Great work on these reports. I see where you updated the Processor Information counter object in the report. I’m using the drill down for each computer object, in specific where the version 2 report hands off to the canned performance by system report for the specific computer object. I edited the performance by system report row group and chart properties for the processor to look at the filter for Processor Information counter object; however, I’m still getting blank reports. I drilled into the sproc as well, dbo.[Microsoft_SystemCenter_Report_Performace_By_System], where it refers to a counterlistobjectxml . I assume this is the library where the counter objects are referred to, but I cannot find it in the db. Wonder if you have run into any such parameters and know if they are dynamically created given input or if this is a resident file in the installation folder. Thanks in advance.
Thanks, I got help from an inside friend at MS … :)
I have only used this report for the Top Utilization data. I’ve never used them for drilling down. I’m not sure what to suggest to be honest.