Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
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 –  Aaron Bertrand Dec 21 '12 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 '12 at 2:40
    
If you have changed the database name recently. Reconfigure the datacollection set –  SQLism Apr 14 at 21:37

2 Answers 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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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