Error message when you try to open a report from a link in the scheduled report e-mail notification in System Center Operations Manager 2007: "An internal error occurred on the report server"

View products that this article applies to.

SYMPTOMS

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.

Back to the top

CAUSE

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

Back to the top

RESOLUTION

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.

Back to the top