Error browsing Microsoft Team Foundation Server reports
This article helps you resolve the problem that occurs when you attempt to view a Team Foundation Server (TFS) report in SQL Server Reporting Services.
Original product version: Microsoft Team Foundation Server
Original KB number: 976701
Rapid publishing
Rapid Publishing Disclaimer
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 TFS attempts to view a TFS report in 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 SSRS web site, ensure the two TFS Data Sources point to the proper Data Source Type:
Connect to the SSRS 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.Open the details for the
TfsReportDS
Data Source and ensure its Data Source Type is set to Microsoft SQL Server.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.
Contact us for help
If you have questions or need help, create a support request, or ask Azure community support. You can also submit product feedback to Azure feedback community.
Disclaimer
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for