Failed to Process Analysis Database ‘Tfs_Analysis’


 

The following steps are applicable if the following is true:

  • New install of TFS 2010
  • SQL Server 2008 R2 configured to use individual domain accounts to run the services

After this particular install I noticed that in the Application Event Log I was getting the following error message every two (2) hours:

Detailed Message: TF221122: An error occurred running job Incremental Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.

Verify the Reporting Configuration using the Team Foundation Server Administration Console.

Team Foundation Server Administration Console

Check the state of the warehouse using Grant Holliday’s Administrative Report Pack for Team Foundation Server 2010.  This will allow you to easily monitor the status of the cube.  In this particular case it was failing processing both the Full and Incremental jobs (ignore the 2 successful runs at the end for now).

Cube Status | Current status (whether the cube is processing now and, if not, when it is scheduled to process next)

A little bit more information could be seen in the Inner Exception Details:

Exception Message: Internal error: The operation terminated unsuccessfully.
Server: The operation has been cancelled.
OLE DB error: OLE DB or ODBC error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Tfs_AnalysisDataSource’, Name of ‘Tfs_AnalysisDataSource’.

 

The issue here is that the account running the SQL Server Database Engine did not have permissions to connect and process the cube.  This is easy to fix by connecting to Analysis Services and adding the domain account that runs the database engine to the TfsWarehouseAdministrator Role in the Tfs_Analysis database.

SQL Server Management Studio / SQL Server Configuration Manager

 

Once you have granted those permissions you can manually process the data warehouse and cube for Team Foundation Server by connecting to the web services on the application tier.  Note: Do not manually process cube using SQL Server Management Studio that method is not supported.

I manually processed the Analysis Services Cube first by running a Full, then followed by an Incremental using the web services

WarehouseControlWebService | ProcessAnalysisDatabase

 

Verified the status of both runs by checking the Cube Status Report.

Cube Data Processing Status

You can see the Full (12:16) and Incremental (12:58) jobs were processed successfully.

About wesmacdonald

Wes MacDonald is a Visual Studio ALM MVP, PSD, MCT and a Principal Consultant for LIKE 10 INC., a SharePoint Server, Visual Studio and Team Foundation Server Consulting Firm providing premium support and guidance services.

3 Responses to “Failed to Process Analysis Database ‘Tfs_Analysis’”

  1. Andres Puerta Bernal Reply January 11, 2013 at 10:19 am

    Necesito procesar el cubo ya que tengo varios archivos corruptos, pero desde el servicio Web no me arroja la siguiente pagina con el XML despues de asignarle el valor a Invocar.

    • If the web services are not functioning or inaccessible I would recommend you address that issue first, I am guessing you are not passing the correct values. The TFS Administration Console is the only supported way to rebuild the cube, you cannot process the cube using SQL Server Management Studio (SSMS).

      Here is the link for using the Web Services to process the TFS 2010 Data Warehouse and Cube manually:

      http://msdn.microsoft.com/en-us/library/ff400237(v=VS.100).aspx

      Wes

  2. Oh my goodness! You have no idea how glad I am that your post was still available. We have just built a new TFS 2013 environment and we were getting the same error. Searching all over we could not find anything that would address our issue. More bizarre everything else worked except for that 2hr job, just like you mentioned. The fix was the same, Add the domain\user acct that the MSSQL service was running as to the cube administration so it could reprocess. The next scheduled process worked without issue!

    Thank you!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: