Effective Thoughts

Occasionally, I encounter issues with the TFS data warehouse failing to refresh. Sometimes, it's as simple as the VS TFS Task Scheduler service isn't started but other times, it's more complicated. Here's a helpful troubleshooting document up on MSDN for troubleshooting the SQL Server TFSWarehouse relational table / Operational Data Store (ODS). If you're expereincing issues with Analysis Services (SSAS) and/or the cubes, reference this one .

You may have noticed it takes a while for Team Foundation Server (TFS) reports to reflect changes you've made to work items or builds. Let me guess...about an hour, right? Out of the box, TFS is set to refresh the data warehouse from its transactional store every 60 minutes. How do I change the frequency of the data warehouse refresh? Browse to the TFS Controller Web Service on your TFS application tier server within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the ChangeSetting option Enter RunIntervalSeconds for the settingId and the desired number of seconds for newValue (300 for 5 minutes...5*60) Select Invoke How do I force a data warehouse refresh? Two methods here: either via the above web service or using SQL Server Management Studio. Via the web service: Browse to the TFS Controller Web Service within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the Run option Click Invo...