Rebuild Warehouse failed after renaming a field in the database

Question

Hello,

a few days ago I want to rebuild the warehouse using the "RebuildWarehouse"-Link in the Team Foundation Administration Console, but the rebuild failed with the following error message:

[Full Analysis Database Sync]: ---> AnalysisDatabaseProcessingType=Full, needCubeSchemaUpdate=True.
---> Microsoft.TeamFoundation.Server.WarehouseException: TF221122: Fehler beim Ausführen des Auftrags "Full Analysis Database Sync" für die Teamprojektsammlung oder Team Foundation Server "TEAM FOUNDATION".
---> Microsoft.TeamFoundation.Server.WarehouseException: Fehler beim Verarbeiten der Analysedatenbank "Tfs_Analysis".
---> Microsoft.TeamFoundation.Server.WarehouseException: Interner Fehler: Der Vorgang wurde erfolglos beendet. Server: Der Vorgang wurde abgebrochen.
Fehler im relationalen Modul. Die Datenquellensicht enthält keine Definition für die GDV_SubState-Spalte in der Tabelle oder Sicht 'dbo_vDimTestCaseOverlay'.
Fehler im OLAP-Speichermodul: Fehler beim Verarbeiten des dimension-Objekts mit der ID 'vDimTestCaseOverlay' und dem Namen 'Test Case'.
Fehler im OLAP-Speichermodul: Fehler beim Verarbeiten des GDV_SubState-Attributs der Test Case-Dimension aus der Tfs_Analysis-Datenbank.
Fehler im relationalen Modul. Der Datenbankvorgang wurde aufgrund eines früheren Fehlers abgebrochen.
[...]

The reason for this message seems to be the change, we did in former times:
Although it is absolutely not recommended, we changed the Tfs_Collection database table [dbo].[Fields]: More precisely we change the value in the coloumns [ReferenceName] and [ReportingReferenceName] from "GDV.Substate" to GDV.SubState".

Rechange these values doesn't solve the problem.

Obviously the views in the databases wasn't refreshed.
How can I refresh the views in the Tfs_Warehouse and in the Tfs_Analysis database?

Thanks for help!

Answer 1

Hi MMW-12, 

Thanks for your post.

First, we don’t recommend to edit the TFS databases directly, it may cause the unknown issue.

For this issue, I suggest you clean the Cache, then try to recreate Tfs_Warehouse and Tfs_Analysis database, then rebuild.

we can clean the Cache manually:

1. Clean the Cache folder on client computer. The folder path is: C:\Users\username(Team Explorer user name)\AppData\Local\Microsoft\Team Foundation\3.0\Cache(os: Windows Server 2008 R2)
2. Clean the Cache folder on Server machine. The folder path is: C:\Users\username(Web access user name)\AppData\Local\Microsoft\Team Foundation\3.0\Cache(os: Windows Server 2008 R2)
3. After cleaned, on Server machine, click Start and select Run… to open the dialog box, then input iisreset.exe and click OK, wait it run completely.

       

To recreate Tfs_Warehouse database, please refer to the answer in this post: http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/951001c7-1528-4b62-8dc5-7e5728f792dd.

To recreate Tfs_Analysis database, please refer to this post: http://social.msdn.microsoft.com/Forums/pl-PL/tfsadmin/thread/9d806e2b-5442-478c-839e-531ff205521a.   

And if you decide to go down the root of rebuilding the cube, then follow the instructions here: http://blog.accentient.com/2010/04/08/ManuallyProcessingTheTeamFoundationServer2010DataWarehouseAndAnalysisServicesDatabase.aspx.

If recreate Tfs_Warehouse and Tfs_Analysis database still can’t resolve this issue, I suggest you to contact a Professional Support Service at http://support.microsoft.com/common/international.aspx?RDPATH=gp;en-us;offerprophone to gain more support on this case.  

 

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hello John Qiao,

thank you for your useful answer. After executing the steps for cleaning the Cache and recreate the Tfs_Warehouse and the Tfs_Analysis database, no errors occur anymore. Thanks a lot.