Hello Folks,

is there a way to manually recreate the TFSWarehouse Database in SQL Server (not the Warehouse- Cube) ?

A the strange problem:

We have a custom Field in Work Item Types.
We have changed this Field to be reportable.

When the TFSWarehouse gets processed from TFSScheduler, only changed and new WorkItems are processed and get updated in the Database. For existing workitems the value for our custom field still remains null in the TFSWarehouse.

How can I force a complete update of all workitems with my custom field values to get into the TFSWarehouse Database ?

Hope you can help,

greets, Helmut

Hello,

fixed this proplem by using the -rebuild switch by the tool tfswarehouse.exe

%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Tools\setupwarehouse.exe -rebuild -s ServerName -d TfsWarehouse -c Warehouseschema.xml -a Domain\TFSService -ra Domain\TFSReports

This will rebuild the complete Warehouse.
After this step I had to go to the warehousecontroller, reinitialize and invoke the run commend.
That did the trick.

see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=688945&SiteID=1

Hope this helps someone else too.

Greets, Helmut

You can also bulk edit the older work items using Excel (or the TFS object model).

It is recommended that SetupWarehouse.exe should only be used for disaster recovery.

Hello Nick,

thank you for your answer.

We have now another problem with the TFSWarehouse update. The update process never ends and the status on http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx?op=GetWarehouseStatus stays RunningAdapters until we recycle the TFS AppPool.