An error message contains invalid DatasetName data when you generate a report in SQL Server 2008 Reporting Services

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

SYMPTOMS

When you use Microsoft SQL Server 2008 Reporting Services, you may receive an error message that contains invalid DataSetName data. For example, you receive an error message that resembles the following error message:
Query execution failed for dataset DataSetName.
In this error message, instead of displaying the DataSetName element for the dataset in which the error occurred, the message displays a different DataSetName element.

This problem occurs when the following conditions are true:
  • Your report includes multiple data sources or datasets.
  • One of the dataset queries fails.
Note If all queries succeed, the report is produced correctly, and the error message is not displayed.

CAUSE

SQL Server 2008 Reporting Services runs all datasets in parallel. However, if any query fails, Reporting Services stops processing other datasets, and it cancels any pending dataset queries. During this exit phase, there is a window in which the resulting error message may include the wrong DatasetName element.

WORKAROUND

To work around this issue, you must manually run each query in Report Designer or in Report Builder Query Editor. By doing this, you can find the invalid query. After you fix the query, the report will be displayed correctly.

STATUS

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

REFERENCES

For more information about SQL Server 2008 Reporting Services, visit the following Microsoft Web site:
http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx

Properties

Article ID: 955508 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Express
Keywords: 
sql2008relnotereportingservices sql2008relnote kbquery kbreport kbexpertiseadvanced kberrmsg kbtshoot kbbug KB955508

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