FIX: Assertion failure when you open a linked report in SQL Server 2008 R2 if the order of the parameters in the source report are changed

Article translations Article translations
Article ID: 2563828 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You use Microsoft SQL Server 2008 Reporting Services (SSRS 2008) or Microsoft SQL Server 2008 R2 Reporting Services (SSRS 2008 R2) to publish a parameterized report.
  • The report has a hidden parameter that stores a value of the Boolean data type.
  • You create a linked report to the published report.
  • You use Report Builder to change the order of the parameters in the published report.
  • You move the hidden parameter in the published report to the end of the parameter list.
  • You open the linked report.
In this scenario, an assertion failure occurs, and a mini-dump file is generated in the Reporting Services log folder.

Notes
  • The fix for SSRS 2008 is not available yet.
  • After you install this fix, this issue does not occur for a new linked report. However, this issue still occurs for existing linked reports. Therefore, you must re-create the existing linked reports to resolve this issue for those reports.

RESOLUTION

Service pack information for SQL Server 2008 R2

To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041 How to obtain the latest service pack for SQL Server 2008 R2
After you apply the fix, a user cannot drop the server certificate if the certificate is used to help secure a database encryption key (DEK).  

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in SQL Server 2008 R2 Service Pack 1 (SP1).

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 2563828 - Last Review: July 12, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Reporting Services
Keywords: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2563828

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com