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
An error occurred during client
rendering.
An error has occurred during report processing.
Query
execution failed for dataset 'dataset name'.
Query (a,b) The set must have
a single hierarchy to be used with the complement operator.
Or, you may receive the following list of error messages:
An error occurred during client rendering.
An error has occurred
during report processing.
Query execution failed for dataset 'dataset
name'.
The function expects a tuple expression for the argument. A tuple
set expression was used.
Error lists for the "MSF for CMMI Process Improvement – v4.2 process template:
Open Issues and Blocked Work Items Trend
An error
occurred during client rendering.
An error has occurred during report
processing.
Query execution failed for dataset 'dataset name'.
The
function expects a tuple expression for the argument. A tuple set expression
was used.
Requirement Details
An error occurred during
client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataset name'.
The function
expects a tuple expression for the argument. A tuple set expression was used.
Requirements Test History and Overview
An error occurred
during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataset name'.
The function
expects a tuple expression for the argument. A tuple set expression was used.
Triage
An error occurred during client rendering.
An
error has occurred during report processing.
Query execution failed for
dataset 'dataset name'.
The function expects a tuple expression for the
argument. A tuple set expression was used.
Error lists for either process template:
Bugs by Priority
An error occurred during client
rendering.
An error has occurred during report processing.
Query
execution failed for dataset 'dataset name'.
The function expects a tuple
expression for the argument. A tuple set expression was used.
Bugs
Found Without Corresponding Tests
An error occurred during client
rendering.
An error has occurred during report processing.
Query
execution failed for dataset 'dataset name'.
Query (a,b) The Extract
function was called with hierarchy 'Function name' that does not exist in the
set.
Exit Criteria
An error occurred during client
rendering.
An error has occurred during report processing.
Query
execution failed for dataset 'dataset name'.
The expression contains a
function that cannot operate on a set with more than 4,294,967,296 tuples.
Issues List
An error occurred during client rendering.
An error has occurred during report processing.
Query execution
failed for dataset 'dataset name'.
The expression contains a function that
cannot operate on a set with more than 4,294,967,296 tuples.
Load
Test Summary
An error has occurred during report processing.
(rsProcessingAborted)
Query execution failed for dataset 'dataset name'.
(rsErrorExecutingCommand)
Incorrect syntax near ')'.
Quality
Indicators
An error has occurred during report processing.
(rsProcessingAborted)
Query execution failed for dataset 'dataset name'.
(rsErrorExecutingCommand)
The function expects a tuple expression for the
argument. A tuple set expression was used.
Related Work Items
An error occurred during client rendering.
An error has occurred
during report processing.
Query execution failed for dataset 'dataset
name'.
The function expects a tuple expression for the argument. A tuple
set expression was used.
Unplanned Work
An error occurred
during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataset name'.
Query (a,b) Two
sets specified in the EXCEPT function have different dimensionality.
Work Items
An error occurred during client rendering.
An error has occurred during report processing.
Query execution
failed for dataset 'dataset name'.
The expression contains a function that
cannot operate on a set with more than 4,294,967,296 tuples.
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.
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.
FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Service: "The Extract function was called with hierarchy '' that does not exist in the set"
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.
Back to the top
