I have a TFS 2012 infrastructure designed according to Microsoft’s proposed multi-machine architecture. I am currently running Team Foundation Server 2012 with Update 1. A few weeks ago, I noticed my reports in SharePoint not being updated. Upon examining the web service admin interface (http://<your url>:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx), I was able to confirm that the jobs were not running.

tfs-process-import

You’ll notice in the attachment, my request to the process service is: 2013-02-16T23:29:54, however, the last time the Incremental ran was 2013-02-16T20:35:28.  Furthermore, there is no <NextRun /> element.  I’ve checked the settings, and its set to run every 7200 seconds (the 2-hour default).

The problem is, both, the Full and Incremental sync jobs run fine once, however, they don’t automatically re-queue.  I’ve tried restarting the app server and stopping/starting the jobs.  When I stop and restart the jobs, the sync jobs are scheduled and run fine (no errors at all).  But, they don’t automatically reschedule themselves to run again.

NOTE: I can’t confirm this, but I think that they re-queued themselves fine until I executed a manual, full warehouse and analysis sync via the admin web service.  Once I processed the cube manually through the service, the services stopped rescheduling themselves.

I do know that I’m not the only one experiencing this “bug” as I originally reached out to the MSDN forums regarding this issue, but never received any input from the Microsoft team.

I was eventually able to get the jobs to automatically re-queue themselves and they’ve worked ever since.  As shared on the forum, I was able to accomplish this with the steps below.  Another forum member was also able to confirm that these steps worked for rescheduling the sync jobs in their environment.

Automatically Rescheduling the Analysis Database Sync

  1. Go to the TFS Console’s Reporting tab and click “Rebuild All” (click “Yes”, through the warnings of rebuilding the warehouse and analysis cubes).
  2. Then go to the web service interface (http://<your url>:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx)
  3. Click the link for the “SetAnalysisJobEnabledState” service.  For state, type in: Enabled     Then, click Invoke.  Even though the “GetSettings” service reported that the Analysis Job was enabled, I wasn’t convinced.
  4. Go back to the web service interface and click the link for “BringAnalysisProcessingOnline”.  Click Invoke.