יום שלישי 29 מרץ 2011 11:03
If a changeset-workitem association is removed, then logically "RemovedDateTime" must be updated for that record in "FactWorkItemChangeset" table right? Well, it doesn't for us. And there is no way to figure out which ones were removed. In case of workitem links (FactWorkItemLinkHistory table), the RemovedDate gets updated when a workitem link is removed. Only for this table (FactWorkItemChangeset) it is not propagating. Is this a bug? How do i fix it? Can i look into some jobs and fix it myself - how?
יום רביעי 30 מרץ 2011 09:45מנחה דיון
Thanks for posting the issue here!
Do you mean you remove the linked changeset for a work item and not see there is no update in "RemovedDateTime" record in the "FactWorkItemChangeset" table?
Yes, you are right. Could you try to rebuild the warehouse and see if "RemovedDateTime" updated?
Hope it helps!
Cathy Kong [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
יום חמישי 07 אפריל 2011 10:58
I tried this but doesn't work. The problem i think is because workitem-workitem links are stored in FactWorkItemLinkHistory, but WorkItem-Changeset links are stored in FactWorkItemChangeset. There seems to be a bug in the replication scripts that is not updating "RemovedDateTime" in FactWorkItemChangeset table. How can we fix this? Can we look into some scripts and update it? Which script? Can i submit a bug or something?
יום שישי 16 ספטמבר 2011 10:30
Did you get any help? I have the similar problem. There is a report, whish should show Unresolved CRs with Associated Changesets. Everything worked fine, untill we removed workitem-changeset links. Workitems with the removed links to changesets are still shown, but they SHOULD NOT :-( We querry that same FactWorkItemChangeset table with wrong RemovedDateTime values. May be we should querry another table?
Do you have any updates with your issue, which can be helpfull for us?
Thank you in advance,
יום חמישי 21 יוני 2012 16:09
I am seeing the same behavior. Links removed from workitems are not updating the RemovedDateTime column correctly. The warehouse is up to date, but has not been rebuilt. I don't think that rebuilding the warehouse every time a link is removed from a changeset is an acceptable fix for this problem either.