5

I'm running SQL Server 2008 R2 and have installed the MDW on one server and have a Data Collector collecting and uploading the server activity, query results, and Disk activity data to the MDW. When I select any of the reports from the MDW with Data Collection > Reports > Management Data Warehouse I receive the error:

Exception has been thrown by the target of an invocation - > Object reference not set to an instance of an object.

This occurs for all 3 reports and after I've waiting some time and data has been uploaded from the data collector. I do not have SSRS running, but read that isn't necessary.

Any suggestions?

marc_s
  • 9,052
  • 6
  • 46
  • 52
Rita
  • 51
  • 1
  • 2

3 Answers3

2

Just ran into and resolved this issue today. Select the View Logs context menu option in the Data Collection Sets--the data upload could have failed, which causes the reports to generate this issue.

Matt
  • 21
  • 2
0

Ok. this is probably going to be removed. I do not think it has anything to do with the setup of the MDW but with SSMS itself. I downloaded the latest beta release of SSMS (2015) and was able to view the reports with that.

Kedazs
  • 1
  • 1
0

I ran into problems on this version where I had to go to each data collector explicitly and select 'Collect and Upload Now'.

Richard Schweiger
  • 69
  • 4