FIX: Error messages in various reports in Visual Studio 2008 Team Foundation Server Service Pack 1 with SQL Server 2008 Reporting Services

You have installed Visual Studio 2008 Team Foundation Server (TFS) Service Pack 1 (SP1) in your computer. The data-tier server in your computer is running SQL Server 2008. You run reports for team projects that use different process templates. Depending on which report you run, you receive a list of error messages that resembles the following:

Error lists for the MSF for Agile Software Development – v4.2 process template:

Scenario Details

Or, you may receive the following list of error messages:

Error lists for the "MSF for CMMI Process Improvement – v4.2 process template:

Open Issues and Blocked Work Items Trend

Requirement Details

Requirements Test History and Overview

Triage

Error lists for either process template:

Bugs by Priority

Bugs Found Without Corresponding Tests

Exit Criteria

Issues List

Load Test Summary

Quality Indicators

Related Work Items

Unplanned Work

Work Items

Work Item with Tasks

This is a subreport of Scenario Details for MSF for Agile, and Requirement Details MSF for CMMI.


Notes

• The errors do not occur when you use SQL Server 2005 on the data-tier server.
• The characters a, b indicate the line number and the column number of the query string.

This problem occurs because of changes in the Reporting Services and the Analysis Services from SQL Server 2005 to SQL Server 2008.

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

To download this hotfix from the MSDN Code Gallery, visit the following Microsoft Web site:

Note The MSDN Code Gallery displays the languages for which the hotfix is available. If you do not see your language listed, it is because the Code Gallery resource page is not available for that language.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:


Note The "Bugs found without corresponding tests" report may still show an error even after you apply this hotfix if the Team Project has no "BUG" work item types in it. The report will stop showing an error after at least one BUG work item is created in the Team Project. Or, you can apply this SQL Server 2008 Analysis Services hotfix that is described in Microsoft Knowledge Base article 969235 to resolve this issue.

Prerequisites

You must have Visual Studio 2008 Team Foundation Server Service Pack 1 (SP1) installed to apply this hotfix.

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

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