Tfs warehouse not updating
We had a power failure in the data center this past week, and it looks like on reboot, the service failed to start.Our new data center isn’t running at production levels yet, so a power failure due to human error is not surprising.Reporting (SSRS and Excel) in TFS makes use of Sql Server Analysis Server, or OLAP cube. This is in most cases frequently enough to get the correct information. You can either change the interval of the warehouse refreshment or you can refresh the cube manually.Be aware that SSRS is caching the reports, which means that when the data might not be refreshed in the SSRS report as you expected.
At first I thought it was going to be easy, the service wasn’t running.
However, after restarting the service, the warehouse still wasn’t updating.
I decided to invoke the warehouse manually, and ran the scripts suggested on this familiar MSDN thread to try to see what was going on.
The warehouse includes both a relational and an OLAP database.
The relational database is organized in an approximate star schema, and the OLAP database is a data cube derived from the relational database.