Empty SCOM Reports

Posted on 2011-05-11
Medium Priority
Last Modified: 2012-11-18

Got a bit of a strange issue in that any report that I run after the 13th April I get a blank report with no data. Anything prior to the 13th I get a working report back.

The issues is that there is no data being populated into the OperationsManagerDW database since the 13th April but I don't know why or even where that database collects it's data from to start looking.

Any help will be much appreciated
Question by:vanquisbank
  • 2
LVL 15

Expert Comment

ID: 35757511
Didn't you get any error on the OpsMgr DW failing in SCOM?
I would start checking your DW read and DW write accounts for permissions.

Accepted Solution

vanquisbank earned 0 total points
ID: 36033335
Issue resolved.

In the end the only way I could get this working was to hit it with a sledge hammer.

Uninstall scom reporting, uninstal SQL Reporting Services, delete OpsMgr database, re-install SQL Reporting Services, Install SCOM Reporting services.

Bit of a heavy handed way to do it but it worked

Author Closing Comment

ID: 38610190
This was the only answer to my problem that i found. Marking as resoltuion because it resolved my issue and may help others

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question