Category Archives: 4389

SOLVED: TF221122: Error While Processing TFS OLAP Cube

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:

  1. In TFS Admin Console, look up the account under “Account for accessing data sources” under the “Analysis Services” tab (Reporting » Edit).
  2. In SQL Server, add that account to the Tfs_Warehouse database, to the TFSEXECROLE role.

Good luck!

–Neno

How to change update frequency of the TFS warehouse/cube

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 default frequency, you can use this command line tool:

Syntax/Usage:

To shorten the interval down to 1 hour (= 3600 seconds):

TfsWarehouseController.exe /server:http://localhost:8080/tfs
/name:IncrementalProcessIntervalSeconds /value:3600

Please be aware of this warning, taken out streigt from MSDN:

Important

If you reduce the interval to less than the default of two hours (7200 seconds), processing of the data warehouse will consume server resources more frequently. Depending on the volume of data that your deployment has to process, you may want to reduce the interval to one hour (3600 seconds) or increase it to more than two hours.

There’s also a /list parameter that shows all current settings (without making any changes):

White text on black background makes me happy...

Download the tool from here: TfsWarehouseController.exe (.ZIP, 12,00 KB)

Prerequisite: This tool requires Team Explorer 2010 to be installed.

Required Permissions: Administer Warehouse (TFS server-level permission)

Refresh TFS Warehouse, Cube and Reports on demand

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 than the default of two hours (7200 seconds), processing of the data warehouse will consume server resources more frequently. Depending on the volume of data that your deployment has to process, you may want to reduce the interval to one hour (3600 seconds) or increase it to more than two hours. [Source: MSDN]

Alternatively you can use this small command line utility:

Syntax/Usage:

tfsrefreshwarehouse.exe /server:http://servername:8080/tfs [/full] [/status]

Manually process the TFS Warehouse and Cube

Using just the /status paramter returns useful information about cube processing:

Using /status shows the last and next scheduled sync times

(Note: The user needs to have the ‘Administer Warehouse‘ permission in TFS)

Download the tool from here:

Update:

  • You can specify "/status" to only query the time of the last warehouse/cube update.

–Neno

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

Enalbe SharePoint Dashboards and Reports with TFS 2010You 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 that doesn’t currently have one.
  • tfpt addprojectreports – Create (or overwrite) the reports for an existing Team Project.

Execute it on the command line (you will nedd to "run as admin"):

tfpt addprojectportal /server:MYTFS\DefaultCollection /teamproject
:TeamProject /processtemplate:"MSF for Agile Software Development v5.0"
All provided settings are valid.
Log file has been created at "C:\Users\Neno\AppData\Local\Temp\TeamProject
.log". Check the log for detailed results.

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

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 the local policy of the DC allows for login of non-admin users.

(Domain Controller Security Policy > Local Policies | User Rights Assignment | "Allow log on locally" policy and add domain users.

(Thanks to Carl Daniel who wrote about the solution in the MSDN Forums.)

TFS Reports: An Error occurred during reporting processing

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.


image

It basically says: the cube has not been processed.

Solution:

Reports for measuring TFS performance

Monitoring TFS performance with reportsGrant 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, we have created a number of reports that we use ourselves and make available to our own users."

Link: Read the full story and download the Report Pack.

 

 

Measure TFS Performance

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

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 command line or UI will just result in “Binary files differ” rather than a diff viewer showing the changes.
  • By default, multiple checkouts of binary files are not allowed.

Step-by-Step instructions:

 Image-0000

Image-0001

Image-0002 

(Thanks to Brian Harry for this tip.)