TFS & Visual Studio ALM – by Neno Loje

(formerly Team System, VSTS)

Entries Tagged as 'TFS Reporting'

SOLVED: TF221122: Error While Processing TFS OLAP Cube

March 6th, 2014 · No Comments · TFS Reporting, Troubleshooting TFS

The Problem After upgrading to TFS 2013, the TFS OLAP Cube fails processing with one of the following messages: Invalid column name ‘System_AssignedTo__Name’.; 42S22; Invalid column name ‘System_AssignedTo__SID’.; 42S22 Query execution failed for dataset ‘ds[Whatever]’ The Solution Found in Jeff Hunsaker’s blog post: In TFS Admin Console, look up the account under “Account for accessing […]

[Read more →]

Tags:

How to change update frequency of the TFS warehouse/cube

June 13th, 2011 · No Comments · TFS Reporting, Tools and Utilities

By default TFS 2010 updates its warehouse every 2 hours. You can change the frequency by running the WarehouseControlService SOAP webservice, as explained in this article. Furthermore the webservice exploses some more settings as well. To force the warehouse to update immediately, you can use the TfsRefreshWarehouse tool. To make it easier to change the […]

[Read more →]

Tags:

Scrum Release Burndown chart: No data available

March 18th, 2011 · No Comments · Project Management with TFS, TFS Reporting

Problem The Release Burndown (from the VS Scrum 1.0 template) stays empty and shows "No data available". How to fix Make sure to specify Start / End Date on the corresponding Sprint work item. Wait until the warehouse is refreshed (or invoke it manually). (Thanks thanks to Ruiz Yi for his post on MSDN Forums)

[Read more →]

Tags:

Refresh TFS Warehouse, Cube and Reports on demand

March 18th, 2011 · 4 Comments · TFS Reporting, Tools and Utilities

By default, TFS will process it’s Data Warehouse and Analysis Services Cube (and thus update the data for the reports) every 2 hours. You can change the default frequency or manually invoke cube processing, if needed. Be careful with changing it to lower values than every hour: Important If you reduce the interval to less […]

[Read more →]

Tags:

How to add a project portal and reports to a Team Project?

August 16th, 2010 · 1 Comment · TFS Administration, TFS Project Portal and Team Communication, TFS Reporting

You created the team project without a project portal and/or without reports? Or maybe you upgraded your TFS to 2010 and did not migrate the reports/portals as well and want to create new, fresh ones? The TFS 2010 Power Tools are your friend: tfpt addprojectportal – Create a project portal for an existing Team Project […]

[Read more →]

Tags:

SOLVED: Reporting Services error: Cannot impersonate user for data source ‘TfsReportDS’ (rsErrorImpersonatingUser)

August 16th, 2010 · No Comments · TFS Installation and Configuration, TFS Reporting, Troubleshooting TFS

Getting this error (and your TFS is installed on a Domain Controller)? Problem: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source ‘TfsReportDS’. (rsErrorImpersonatingUser) Logon failed. (rsLogonFailed) Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569) Solution: Make sure that […]

[Read more →]

Tags:

Reporting Services: Cannot set value for "To" field

August 10th, 2010 · No Comments · TFS Reporting, Troubleshooting TFS

You use SQL Server Reporting Services (SSRS) and wonder why you can’t set the "To" field. By default, SSRS will use your user name as the receipient and not allow manual changes. How to enable the "To" field? Locate RSReportServer.config on your SSRS server. Make one change: <SendEmailToUserAlias>False</SendEmailToUserAlias>

[Read more →]

Tags:

TFS Reports: An Error occurred during reporting processing

August 6th, 2010 · No Comments · TFS Reporting, Troubleshooting TFS

You receive the following error message when opening a TFS report: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘dsIteration’. (rsErrorExecutingCommand) The Team System cube eitehr does not exist or has not been processed. It basically says: the cube has not been processed. Solution: Either: Wait and try again later […]

[Read more →]

Tags:

Reports for measuring TFS performance

February 9th, 2009 · No Comments · Downloads, Team Foundation Server, TFS Administration, TFS Installation and Configuration, TFS Reporting

Grant Holliday, who runs the busiest TFS at Microsoft, posted 6 handy reports you can easily import into your TFS to monitor system performance. "We have a responsibility to ensure that the server is performing as expected and to identify any efficiencies that can be made in the server or the tools.  To do this, […]

[Read more →]

Tags:

Q: How can I exclude a file from code churn?

October 12th, 2008 · No Comments · Team Foundation Version Control, TFS Reporting, TFS Tips and Tricks, VSTS

A: You can change it’s encoding in version control to Binary. Background: The code churn value used by TFS report, like the Quality Indicators report, might not make any sense to you if files this value includes some specific files, like auto-generated files, that were not created/edited by humans. Disadvantages: Comparing binary files in the […]

[Read more →]

Tags: