SCOM Subscription Issue – Notification Contains Indexed Placeholder Instead of Value in the AlertName

Yes, that’s a very long title, but it really describes the issue that was brought to the table last week. The original question was: All of the notification emails for these alerts only contained {2} for the Subject and Alert Name. That was something I haven’t heard before and I decided to do a quick […]
Continue reading…

 

SSRS: How to fix rsInvalidDataSourceReference

I was analyzing my blog stats today and noticed that really a lot of people land at my old blog post about fighting with rsInvalidDataSourceReference in System Center Operations Manager environments. As far as I understand, that is not exactly what most of the SSRS guys are looking for.
I decided to fix this, so please find below my explanation of the nature of rsInvalidDataSourceReference. First things first, what is the Data Source, what is Reference and why is it Invalid?..
Continue reading…

 

SSRS 2008 in backward compatibility mode: conditional visibility doesn’t work

Couple of months ago I blogged about conditional formatting. Now it turned out that conditional visibility doesn’t work as well. Here is the case: You design report which has a list with nested table; You use expressions to manage columns visibility; Outcome: Everything is okay in SSRS 2005 Everything is okay in SSRS 2008 running in “native” […]
Continue reading…

 

Microsoft generic reports do not work when you try to reuse your old SCOM Data Warehouse

Case You have a SCOM Data Warehouse. It was previously used by some management group(s). You deploy a new management group. You decide to use existing data warehouse when you deploy “Reporting” components. So you uncheck “Data Warehouse” option and instruct installer to use existing database:  Setup succeeds, but when you try to run any […]
Continue reading…

 

Conditional formatting doesn’t work if report is processed by SSRS 2008 (SP1 or SP2) in backward compatibility mode.

Pretty long  title, isn’t it? But the story is short. I was authoring an OpsMgr report containing custom control designed for SSRS 2005 (EnterpriseManagementChartControl – shipped by Microsoft with OpsMgr and is used by MS Generic report library) and some conditionally formatted table cells (background color, text color and font weight). Guess what I’ve got […]
Continue reading…

 

InteractiveHeight, SSRS 2005 rdl schema and an instance of SSRS 2008

Got an awesome bug yesterday. QA guys reported that when they had tried to deploy my reports MP to OpsMgr installation powered by SSRS 2008 SP1, they got the following error: Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for […]
Continue reading…

 

Custom OpsMgr reports: how to get rid of rsInvalidDataSourceReference error

Note: This post is about rsInvalidDataSourceReference error observed in System Center Operation Manager environments. Please consider this blog post for the more details about the nature of rsInvalidDataSourceReference. That description is applicable for any SSRS deployment. You may get a rsInvalidDataSourceReference error when you try to deploy your custom report into OpsMgr SSRS instance. Everything […]
Continue reading…