How to add more iterations?  
Author Message
Marcin Książek





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

We need to add more iterations to our project.

Team Project Settings -> Areas and Iterations dialog supports it but in New Workitem forms there are still old iterations. Where is the problem

Marcin



Visual Studio Team System35  
 
 
Joe Sango





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

From memory, you might need to refresh your datawarehouse to update your project settings. If you want to do that manually, call the TFSDataWarehouse web service:
http://machinename:8080/Warehouse/v1.0/WarehouseController.asmx

Invoke the Run method and you should be refreshed!



 
 
Naren Datha - MSFT





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

This could be a caching problem and I have seen such issue before. Try closing all work item forms & making a db call such as running a query to refresh the cache - this should clear cache and you should see new iterations. If not, try closing & opening VS.

 
 
Marcin Ksi??ek





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

Thank you for tip on how to refresh the Warehouse. Anyway it didn't help. New iterations and Areas are still visible under "Areas and iterations" dialog and not in drops on workitem dialogs.

Looking at database tables I've found that new areas and iterations exists in TfsWarehouse.Area and TfsWarehouse.Iteration tables and of course in TfsIntegration.tfs_nodes.

How to find out what is the problem

Marcin


 
 
Marcin Ksi??ek





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

That where the first things I've done. Closing all opened workitem dialogs, requerying data in VS, reopening VS, creating new workitem.

None of it helped.

Marcin


 
 
Thomas Petersen





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

I have the EXACT same problem. I have also tried clearing caches, executing a Run etc. etc.

It's pretty painful for the PM's on the projects this affects.

Regards

Thomas Petersen


 
 
Marcin Ksi??ek





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

I have some more information.

ComboTree is filled from TfsWorkItemTracking.dbo.TreeNode table and newly added Iterations are not there.

How to force update of that table

Marcin


 
 
Naren Datha - MSFT





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

Have you guys tried deleting and adding the treenodes back Also, do you see any errors/warnings in event log in application/data tier

 
 
Marcin Ksi??ek





PostPosted: Team Foundation Server - Process Templates, How to add more iterations? Top

Copy from another thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=701767&SiteID=1

To workaround the problem you should drop UQ_TreeNodes__ParentID_Name_DeletedCachestamp constraint, see which areas and/or iterations violate it, remove or re add it and recreate unique constraint.

Marcin