In Microsoft System Center Operations Manager 2007, when you try to open a report from a link in the scheduled report e-mail notification, you receive the following error message:
Reporting Services Error
---------------------------------------
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.
If the scheduled report that is received through e-mail has more than one chart, the original URL for the report exceeds the default value of 1,500 for the
StoredParametersThreshold parameter. Therefore, Microsoft SQL Server Reporting Services uses the value of the
StoredParametersID parameter to replace the whole parameter value list.
However, the shortened URL is not the correct URL. Additionally, because the link does not contain the necessary parameter, the link does not work. The link returns an internal error in Windows Internet Explorer.
The following URLs are examples of the original URL and of the shortened URL.
The original URL for the report contains all the parameters, as follows:
http://Servername/reportserver?%2fMicrosoft.SystemCenter.DataWarehouse>.Report.Library%2fMicrosoft.SystemCenter.DataWarehouse.Report.Alert&Start
Date_BaseValue=2008-01-09T13%3a44%3a00&ObjectList=%3cData%3e%3cObjects%3e%3cObject+Use%3d%22Containment%22%3e374%3c%2fObject%3e%3c%2fObjects%3e%
3c%2fData%3e&EndDate_BaseValue=2008-01-09T13%3a44%3a00&Severity=0&Severity=1&Severity=2&EndDate_OffsetType=None&StartDate_OffsetValue=0&StartDat
e_OffsetType=None&EndDate_OffsetValue=0&TimeZone=E001000000000000C4FFFFFF00000B0000000100020000000000000000000300000002000200000000000000%7cPaci
fic+Standard+Time&StartDate_BaseType=Sunday&Priority=0&Priority=1&Priority=2&Interactive=False&EndDate_BaseType=Today&TimeZoneName=(GMT-08%3a00)
+Pacific+Time+(US+%26+Canada)&ManagementGroupId=95a34c84-2de7-3224-1315-ce740d173598&SiteName%3aisnull=True&rs%3aParameterLanguage=en-US
The shortened URL in the e-mail notification is as follows:
http://Servername/reportserver?%2fMicrosoft.SystemCenter.DataWarehouse.Report.Library%2fMicrosoft.SystemCenter.DataWarehouse.Report.Performance
&rs%3aStoredParametersID=ssnyvd453xhqvm453vkz5u45&rs%3aParameterLanguage=en-US
To resolve this problem, separate the charts in the report. Use only one chart in a report. This step reduces the length of the URL. Then, the URL works correctly.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.