Wednesday, January 24, 2007

TFSWarehouse Cube Corruption

Ever got your TFSWarehouse Cube corrupted?

One of the reasons I got that corruption was due to machine failure that corrupted some of the cube's XML files, I spent quite some time trying to figure out the problem and how to solve it, but luckily I got to fix it easily in 4 steps.
  1. Open SQL Management and Stop the TFS Analysis Service on the TFS Data Tier.
  2. Go to "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data" on the TFS Data Tier, and delete the folder TFSWarehouse.0.db and the XML file TFSWarehouse.0.db.xml
  3. Run the following command on the TFS Data Tier to rebuild the cube, it can be found in "C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Tools"SetupWarehouse -o -s TFSServer -d TFSWarehouse -c warehouseschema.xml -a TFSServiceAccount -ra TFSReportsAccount -mturl http://TFSServer:8080
  4. Start the TFS Analysis Service on the TFS Data Tier and Process the cube to get back on track.

That's all you need to do. Hope that will help ...

4 comments:

EzzMan said...

I tried this method, the problem is...when I started the upgrade to TFS 2008, it removed my http://TFSServer:8080 web reference, so the command says it cannot connect to remote server.

Any Ideas?

Thanks!

EzzMan said...

I tried this method, but when I was running the upgrade to TFS 2008, it removed my web reference (http://TFSSERver:8080) from IIS...so the command returns an error saying the remote server could not be contacted.

Any Ideas?

Thanks!

Stefan said...

Hello i've made all the point but after the Rebuild of the cube there is no Database in the Folder "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data" can you tell me where is my error?

regards
Stefan

Andersen said...

Thanks for your sharing. It works for me.