ravs

Hello People,

The TFSServerScheduler service got stopped on my server (still investigating why). I started the service and after that manually processed the data warehouse to get the latest data. The problem is that the Work Item History table is not updated. The Current Work Item table did get updated. Any reason as to why this would happen and also any ways to update the Work Item History table Thank you in advance.



Re: Team Foundation Server - Reporting & Warehouse Work Item History table not updated after manually processing the warehouse

D. Omar Villarreal

Are there any errors in your event log after running the warehouse adapter manually If so, what are they





Re: Team Foundation Server - Reporting & Warehouse Work Item History table not updated after manually processing the warehouse

Mauli Shah - MSFT

Yes, as Omar says, the application tier event log with source="TfsWarehouse" is the first place to check whenever anything looks weird in the warehouse. Please let us know what you find in there.




Re: Team Foundation Server - Reporting & Warehouse Work Item History table not updated after manually processing the warehouse

Larry Bynum - msft

Omar, after checking the Event Viewer and if you still need help, please send us some more details about what is in the database. Here's a query you can run to determine if the warehouse contains data about all the WIs in the operational store. Please let us know either way - if everything works now or you still need help. Thanks!

select t.* from

(

select *

FROM TfsWorkItemTracking.dbo.WorkItemsLatest as wil

union all

select *

FROM TfsWorkItemTracking.dbo.WorkItemsWere as wiw

) as t

left join TfsWarehouse.dbo.[Work Item History] as wh

on

CAST(CAST(wh.[Logical Tracking Id] AS UniqueIdentifier) AS Binary(16)) = t.[Changed Order]

AND wh.[Revision Count] = 1

where

wh.[Work Item] is null

order by id, rev