DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 976701 - Last Review: October 16, 2009 - Revision: 1.0

Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Action

A user of Microsoft Team Foundation Server (TFS) attempts to view a TFS report in Microsoft SQL Server Reporting Services (SSRS).

Result



Rather than rendering correctly, one of the following errors occurs:

ERROR 1
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'dsLastProcessedTime'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

NOTE: If remote errors are enabled, or the report is rendered on the console of the SSRS machine, this additional information is given: "Query (3, 10) Parser: The syntax for '=' is incorrect."

ERROR 2
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'IterationParam'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

NOTE: If remote errors are enabled, or the report is rendered on the console of the SSRS machine, this additional information is given: "Incorrect syntax near 'Measures'."

Cause



These errors can occur when the Data Source Type for TFS Data Sources in SSRS is set incorrectly. In the case of these two errors:

ERROR 1
The Data Source Type for the TFS Data Source named "TfsReportDS" in SSRS is erroneously set to "Microsoft SQL Server Analysis Services".

ERROR 2
The Data Source Type for the TFS Data Source named "TfsOlapReportDS" in SSRS is erroneously set to "Microsoft SQL Server".

Resolution



Using the Microsoft SQL Server Reporting Services web site, ensure the two TFS Data Sources point to the proper Data Source Type:
  1. Connect to the Microsoft SQL Server Reporting Services web site. This is usually HTTP://LOCALHOST/REPORTS on the TFS application tier machine, but may be different. Check with your TFS administrator for this location.
  2. Open the details for the "TfsReportDS" Data Source and ensure its Data Source Type is set to "Microsoft SQL Server".
  3. Return to the HOME page then open the details for the "TfsOlapReportDS" Data Source. Ensure that the Data Source Type is set to "Microsoft SQL Server Analysis Services".


NOTE: You will need to provide the password for the credentials being used by each Data Source before you can apply any changes made.

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

APPLIES TO
  • Microsoft Visual Studio 2005 Team Foundation Server
  • Microsoft Visual Studio 2005 Team Foundation Server Service Pack 1
  • Microsoft Visual Studio Team System 2008 Team Foundation Server
  • Microsoft Visual Studio Team System 2008 Team Foundation Server Service Pack 1
Keywords: 
kbrapidpub kbnomt KB976701
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support