How to recreate the Data warehosue and the Analysis service for TFS?

2 days ago I have a problem seeing my reports on the TFS and after the invistigation I solve part of the problem which is how to recreate the data warehouse and the analysis service for the TFS, my problem was that when you open any reports you find the following error

Query execution failed for dataset ‘dsIteration’. (rsErrorExecutingCommand) Get Online Help
Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.636.cub.xml’. Errors in the metadata manager. An error occurred when loading the Work Item dimension, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\vDimWorkItemOverlay.187.dim.xml’. File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\vDimWorkItemOverlay.147.dim\187.Hierarchy.Area1.sstore. Logical file

And when I go to the analysis service and try to see it, it gives me the following error

File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\vDimWorkItemOverlay.147.dim\187.Hierarchy.Area1.sstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Work Item dimension, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\vDimWorkItemOverlay.187.dim.xml’.
Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.636.cub.xml’.
(Microsoft.AnalysisServices)

I can’t even right-click and see the property of the Analysis data

So here the solution to this problem

• Stop the analysis service and delete the Tfs_Analysis.0.db folder

Stop the analysis service

Delete Tfs_Analsysis.0.db

• Go the report on the Team foundation administration console and edit the property, you can create new names if you want for the data warehouse or the analysis service if you want but you must use the appropriate service account that you used when you first configure and install the system

Edit the report tab

• Start rebuild the data warehouse and the analysis service, this command will rebuild them again from the TFS DB

Rebuild the data warehosue and analysis service

• Go to the Team Project collection and choose your collection and click report folder

Create Report folder

• Enter the name of the folder that will hold your reports

Give the reprot folder name

************Updated 27 August 2012 *************

If you want to see the reports immediately, you will need to process the Data-warehouse and the Analysis service from the web services, or just leave it when the schedule job is running, for the step-by-step on how to process this manualy just see the following post.

Process the TFS Data Warehouse and Analysis Service manually

Or see the step-by-step video

************End of the Update*******

About these ads