Tfs warehouse not updating

I decided to look at the Scheduled in Program Files Microsoft Visual Studio 2008 Team Foundation Server TFSServer Schedule, and it was showing a wierd value for last run time (lastrun=”1:1:1:0:0:0″).

Excel reports, Reporting Services reports, and Share Point dashboards are only supported for on-premises TFS.

The following exception occurred while the managed IDb Command interface was being used: Invalid column name 'Plan Owner__SID'. Strange thing is that I have recreated the databases and it continues to have this problem.

The Database TFS_warehouse collect data from TFS_Configuration and TFS_Project Collection. How to recreate the Data warehosue and the Analysis service for TFS?

Oz - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.The default collection is named Default Collection, but you can change that in the collection that is in use on your TFS environment. The warehouse update is ready when all jobs have the “Idle” job status.Whenever I talk about TFS, one of the things I always mention is the fact that because all the data about the software project is now being tracked in a SQL Server database, Microsoft were able to stick a Data Warehouse over the top of all that raw data to give you a really good view on reporting.So begins another adventure into getting it to work again.At first I thought it was going to be easy, the service wasn’t running.