Manually Processing the Team Foundation Server 2010 Data Warehouse and Analysis Services Database

There are many reasons and times that you will want to manually process the TFS 2010 Data Warehouse and Analysis Services databases. The primary reason is that you are impatient and want to see your reports and metrics right away. An example of this is right after you create a new team project, you may see one or more Reporting Services errors on the project portal (see below). These will go away after a period of time (which can be specified) but if you want to clean them up immediately (because you have OCD or something) then you can follow the steps in this post.

Notice the message says “The Team System cube either does not exist or has not been processed.” This is your cue to (a) wait for the cube to process itself, or (b) force a process by following these steps:

1. Open the WarehouseControlWebService on the TFS Application Tier by navigating to (for example) http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

2. Click the ProcessWarehouse method.
3. Leave the collectionName and jobName parameters empty and click Invoke.
4. A new browser window will open showing XML with “true” as the value. You can close this window.
5. Return to the main WarehouseControlWebService page. You can simple click the back button.
6. Click the GetProcessingStatus method.
7. A new browser window will open showing XML. Keep refreshing this window until the tag at the top of the file shows “Idle” (see item in green below) and then you can close this window.

8. Return to the main WarehouseControlWebService page.
9. Click the ProcessAnalysisDatabase method.
10. Specify Full as the processingType parameter and click Invoke.

 

11. A new browser window will open showing XML with “true” as the value. You can close this window.
12. Return to the main WarehouseControlWebService page.
13. Click the GetProcessingStatus method.
14. Specify TEAM FOUNDATION as the serviceHostName parameter and click Invoke.

15. A new browser window will open showing XML. Keep refreshing this window until the Full Analysis Database Sync job shows a JobProcessingStatus of “Idle” (see item in green below) and then you can close this window.

That should do it. If you run into any errors, look for details in a ResultMessage tag on the status page.

If you return to the newly created team project portal, those error messages have disappeared and been replaced by dashboard reports showing no data – which is an improvement from an error message.