TFS & Visual Studio ALM – by Neno Loje

(formerly Team System, VSTS)

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:

  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

Tags:

No Comments so far ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment

*