Problem with data stored on Warehouse in custom work item field  
Author Message
demetriost





PostPosted: Team Foundation Server - Reporting & Warehouse, Problem with data stored on Warehouse in custom work item field Top

Hi ,

We have a problem with values stored on Warehouse in custom work item field:

There are substantial differences between data from the Work Item Tracking Database to the Warehouse Database (NULL instead of strings), i compare the last revision version of workitems in both databases.
There are no apparent relationship between no updated workitems except one :
From an X Work Item CreatedDate to now the data are correct.

We've deleted the Warehouse and reimplemented it:
same problem.

Can you Help me

Thanks
Demetrio




Visual Studio Team System17  
 
 
Federico Kolliker Frers - MSFT





PostPosted: Team Foundation Server - Reporting & Warehouse, Problem with data stored on Warehouse in custom work item field Top

Hi Demetrio,

Let me see if this is your scenario:

1. You created a new field in a Work Item Type but you didn't mark it as reportable.

2. You created a bunch of new work item revisions and added values to that field.

3. You know marked that field as reportable.

4. You continue to created new work item revisions with values in that field.

If that is what you did then you are correct, all the work item revisions that you created in 2 won't have a value for that field in the Warehouse. Work Item revisions created after 3 will have value for the field in the Warehouse. This is because once you marked a field as reportable the adapters won’t go back to see if previous revisions already had a value in that field and update those in the Warehouse. Only new revisions will get the field uploaded into the Warehouse.

What is also true is that if you rebuild the warehouse then all the revisions will be re-uploaded and because the schema change in the warehouse takes place now before any revision is uploaded then all the revisions that have a value in that field will have the value in the Warehouse.

When you say you deleted the Warehouse and re-implemented it, do you mean you ran setupwarehouse. Did you run setupwarehouse with the -rebuild option or with the -o options The -o option will only rebuild the cube but won't force all the data to be re-uploaded to the Warehouse. The -rebuild option will completely delete the Warehouse and the cube and all the data will be re-uploaded by the adapters. This could be very expensive if you have a large amount of data.

If you are not interested in seeing the old values for this field another thing you can do instead of rebuilding the warehouse is just updating all the workitems you are interested in by adding a simple comment. This will create a new revision for them and the new revision in the Warehouse will include the value for the field.

I hope this helps.

Thanks.

Federico


 
 
demetriost





PostPosted: Team Foundation Server - Reporting & Warehouse, Problem with data stored on Warehouse in custom work item field Top

Hi Federico,
the scenario that you paint is correct.
I have used the -rebuild option without succes.
I solved updating all the workytems.

In wich table on the work item tracking database can i find the data used from the warehouse update procedure to understand if a workitem must be updated

Thanks
Demetrio