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?

3
  • 2
    Have you installed Service Pack 2 on your server, but more importantly on your workstation (or wherever you're running the reports within Management Studio)? e.g. this one was fixed in a CU for SP1 (but you should install SP2 anyway): support.microsoft.com/kb/2639301 Dec 21, 2012 at 2:02
  • Can you get any more error information, like a call stack? Is there anything in the Windows Event Log?
    – Jon Seigel
    Dec 21, 2012 at 2:40
  • If you have changed the database name recently. Reconfigure the datacollection set
    – SQLism
    Apr 14, 2014 at 21:37

3 Answers 3

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.

0

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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.