TFS 2010 Reporting Services - Reporitng Jobs are stuck or not fully enabled.

Question

We recently switched to a new TFS server and the Reporting Jobs are either stuck or failing. We tried to Rebuild the Warehouse and got this error: "The warehouse and Analysis Services databases cannot be rebuilt because there are reporting jobs still running. Wait until the jobs are idle and try again." This prompted us to stop the Reporting Jobs on the TFS Admin Console, clear the tbl_JobQueue, and then kick off a full Rebuild the Warehouse. This seemed to work because the Rebuild was noted in the TFS logs and there were no visible errors.

We see jobs in the tbl_JobQueue, but they seem to be idle. How do we enable them?

See output from WarehouseControlWebService below.

 We ran:

http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Controller/03">
 <RequestTimeUtc>2012-02-17T19:32:42.428388Z</RequestTimeUtc>
 <WarehouseProcessingOnlineStatus>Started</WarehouseProcessingOnlineStatus>
  <AnalysisProcessingOnlineStatus>Started</AnalysisProcessingOnlineStatus>
  <JobProcessingStatus>Idle</JobProcessingStatus>
  <JobsRunning>0</JobsRunning>
  <JobsQueued>8</JobsQueued>
 <Instance Name="TEAM FOUNDATION" JobProcessingStatus="Idle" JobsRunning="0" JobsQueued="3">
- <Jobs>
- <Job Name="Common Structures Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:37:45.197Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Full
Analysis Database Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:39:28.033Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Incremental Analysis Database Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T18:55:32.957Z" JobState="QueuedScheduled" />
  </Job>
  </Jobs>
  </Instance>
- <Collections>
- <Collection Name="DefaultCollection"JobProcessingStatus="Idle" JobsRunning="0" JobsQueued="5">
- <Jobs>
- <Job Name="Build Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:58:27.647Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Common
Structures Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:58:27.647Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Test Management Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:58:27.647Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Version Control Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:58:27.647Z" JobState="QueuedScheduled" />
  </Job>
- <Job Name="Work Item Tracking Warehouse Sync" JobProcessingStatus="Idle">
  <CurrentRun QueueTimeUtc="2012-02-17T17:58:27.647Z" JobState="QueuedScheduled" />
  </Job>
  </Jobs>
  </Collection>
  </Collections>
  </WarehouseProcessingStatus>

---

Brandon Davis

Answer 1

Hi Brandon,

Thanks for your post!

A value of Idle indicates that the synchronization job is currently not running. You should process the data warehouse or the cube only when the processing status for the jobs is Idle. If a different value is returned, repeat this step until Idle is returned for the job that you want to process.

For more information, you can refer to

http://msdn.microsoft.com/en-us/library/ff400237.aspx#DetermineStatus

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 2

This is resolved, we had a chaching problem on the TFsJobAgent.

---

Brandon Davis

Answer 3

You mean recycling TFS Backgrnd Job agent service / IIS helped?

---

Arun Sangal Software Configuration Management Denver USA