Tuesday, February 25, 2014

SCCM 2012 R2: Report ‘Run’ Button Doesn’t Work

I know this is more a SCOM blog. Yet I do more besides SCOM so I want to share some of those experiences here as well, hoping to aid you.

Issue
SCCM 2012 R2 is installed and seems to be working just fine. On one of the SCCM servers the Site System Role Reporting Services Point is added. Soon a whole bunch of reports are uploaded to the SSRS instance. But none of the Reports will run. The Run button doesn’t do anything.
image

It gets even stranger. One can edit reports and run those reports from the editor without any issue at all. So it seems to be an isolated console issue.

Cause
After some investigation the culprit was soon found, thanks to the event log. The application log of the server where the Console is run from logs EventID 1, stating:
System.IO.FileNotFoundException\r\nCould not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies
image

Okay, that’s clear enough. Apparently the SCCM 2012 R2 Console requires the Microsoft Report Viewer 2010 Redistributable Package but it isn’t installed.

Solution
I downloaded the latest version which incorporates SP1, to be found here. Run the installation file, closed the SCCM Console, reopened it and now the Run button worked like a charm!

Recap 1
Further investigation tells me the Microsoft Report Viewer 2010 Redistributable Package should be installed by the installer of SCCM, but is sometimes skipped. This happened to me on a brand new Windows Server 2012 R2 box with SCCM 2012 R2, so it seems this issue can still occur, even when running the Latest & Greatest.

Don’t know yet whether the PowerShell Deployment Toolkit solves this issue.

Recap 2
I just learned it isn’t required to download the Microsoft Report Viewer 2010 Redistributable Package. Instead it can be found on the same server/desktop experiencing this issue. The folder C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin contains the file ReportViewer.exe. Run it and the wizard will install it for you. Close and reopen the SCCM Console and you’ll be just fine.

4 comments:

jthys said...

Thanks for sharing this info! I had exact the same issue.

sida kodka said...

Thanks a ton, really helpful!

Taha Shahzad said...

Thanks, My problem is solved now :)

Bohuslav Kounovsky said...

Thanks a lot, problem solved !