SCSM Reports not rendering?

I came across a little issue the other day whilst implementing Service Manager for a customer.  The deployment of the Management Server and Data Warehouse server was successful……even the report deployment.  However, when trying to run reports the following error was generated:

The report server cannot process the report or shared dataset.  The shared data source ‘DWDataMart’ for the report server or SharePoint site is not valid.  Browse to the server or site and select the shared data source.  (rsInvalidDataSourceReference)

Here’s a screenshot…..

image

First things first, I thought I’d check the the Report Server……

image

All looked good here.  So, next I took a look at the data sources.  The reports use the ‘DWDataMart’ data source…..

image

All looked good here too.  So, the next to look as was the data source within the report itself.  I opened up a report in Report Builder to test the data source:

image

As you can see this didn’t work.  Notice how there is no location for the ‘DWDataMart’ data source reference.  So next, I decided to browse for the data source…..

image

By doing this, a new shortcut to the shared data source is created.  Notice the location of the ‘DWDataMart’ reference is now populated:

image

Testing the connection now works!

image

Saving the report in Report Builder then writes the change back to the Reporting Services server.  Now running the report from within the Service Manager console resulted in the following:

image

Victory!  The report now runs successfully.  The same actions need to be done for each report, which is a bit of a lengthy task, but will fix the issue.  At this time, I am unsure why this occurred, but suffice to say if you experience this issue, it will dig you out of a small hole.  I’ll update this should I figure out why this happens.

5 thoughts on “SCSM Reports not rendering?

  1. Dude, you are awesome. Thank you!!!

    1. Thanks for the grest comment. Any time Patrick!!

  2. You are a legend..

  3. Balasubramaniyam October 29, 2013 — 8:48 AM

    Awesome. It helped lot.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

search previous next tag category expand menu location phone mail time cart zoom edit close