Help and Support
 

powered byLive Search

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.
Article ID:949454
Last Review:March 13, 2008
Revision:1.0

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

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

APPLIES TO
•Microsoft System Center Operations Manager 2007

Back to the top

Keywords: 
kberrmsg kbtshoot kbexpertiseinter kbprb KB949454

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.