i have TFS 2010 installed on a machine with Windows 2008 R2. WSS 3.0 runs on the domain controler which is a Windows Server 2003 SBS. I have installed your template to use with TFS 2010. I was finally able to create a project successfully, and even the portal page within sharepoint was created successfully. But when i open the portal page, all webparts show the following error message:
Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type is not registered as safe.
I found out that i have to add a line to the SafeControls-section of the web applications web.config file. But i couldn´t find out the exact values i have to insert here. The best choice was the following:
But this doesn´t resolve the issue and i asume that i have taken the wrong values. So here are my questions:
Am i on the right way, or is there a different cause for this error? How can i find out the correct values for the above line? What else do i have to do to register the webparts as safe?
Any help is much appreciated. If you need further informatione, please ask. I will try to give you as much as i can.
Best regards Christoph
TF249033: Team Project creation fails because the template "TFS2010 Agile Dashboard" is not available for the local identifier 1033
When I try to create a new Team Project with the "New Team Project Wizard" and select the Scrum Process Template, the wizard fails when it tries to create the Sharepoint Project Portal.
My Server configuration is: Windows Server 2008 SP2 x64 (german) SQL Server 2008 SP1 x64 (german) WSS 3.0 x64 with SP2 (german) WSS 3.0 english language pack x64 + SP2 TFS 2010 x64 (german)
According to the log file the problem seems to be a compatibility issue with other languages than english. My Server is installed with german localisations but the Process Template is in english. The log file says that the site template "TFS2010 Agile Dashboard" is not available for the local identifier 1033 (1033 is english, 1031 is german). The Error code is TF249033. I'll post the exception message below.
The wizard finally fails with TF30162 (Error at task "SharePointPortal" from group "Portal") and the TF249033 error message I mentioned above as inner exception.
I tried the following steps to solve this issue but the same exception still appears: - I installed the english WSS 3.0 language pack (it was not in stalled when this issue appeared for the first time), - I undeployed and deleted the Scrum SharePoint solution package using stsadm.exe. Then I reinstalled and deployed it with stsadm.exe as described in the readme file. - I also tried to install / deploy the Scrum SharePoint solution package with the lcid paramter set to 1033
Here is the exception message from the log file. Sorry there is a lot of german but I hope you can see the relevant information.
---Anfang Ausnahmeeintrag--- Zeit: 2010-08-12T12:19:24 Modul: WSS Ausnahmemeldung: TF249033: Die Websitevorlage ist für die Gebietsschema-ID (LCID) nicht verfügbar. Der Name der Websitevorlage ist "TFS2010 Agile Dashboard".
Die LCID ist "1033". (Typ TeamFoundationServerException)
Ausnahmestapelüberwachung: bei Microsoft.TeamFoundation.Client.SharePoint.SharePointTeamFoundationIntegrationService.HandleException(Exception e) bei Microsoft.TeamFoundation.Client.SharePoint.SharePointTeamFoundationIntegrationService.CreateSite(String webApplicationUrl, String absolutePath, String
configurationServerId, Guid projectCollectionId) bei Microsoft.TeamFoundation.Client.SharePoint.WssUtilities.CreateSite(ICredentials credentials, Uri adminUrl, WssSiteData siteCreationData, Guid
configurationServerId, Guid projectCollectionId) bei Microsoft.TeamFoundation.Client.SharePoint.WssUtilities.CreateSite(WssSiteData siteCreationData, TeamProject settings) bei Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.CreateSite(WssSiteData siteCreationData, WssCreationContextWrapper contextWrapper) bei Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.HandleSiteCreation(WssCreationContextWrapper contextWrapper, XmlNode taskNode)
Interne Ausnahmedetails:
Ausnahmemeldung: TF249033: Die Websitevorlage ist für die Gebietsschema-ID (LCID) nicht verfügbar. Der Name der Websitevorlage ist "TFS2010 Agile Dashboard".
Die LCID ist "1033". (Typ SoapException)SoapException-Details: <detail exceptionType="TeamFoundationServerException" />
Hi, I had the same problem, but my local lenguage not is german, is spanish and all products are installe in spanish(I not use WSS, I use Sharepoint 2010 Foundation). Chech if the solution is deployed in WSS, (stsadm -o enumsolutions or check in WSS Central Administrator, in Teporizer if the job for scrum is pendind to run), it's, show if the scrum solution is deployed or waiting for deploy. If is waiting for deploy you cannot create proyect using SCRUM teplate, I resolve this installing English Language Pack for Sharepoint Foundation 2010, reboot the server, and the solution was deployed in sharepoint and I can create project using SRUM template.
Hi, we are developing with more than ONE team. How can we handle several teams? Would it be possible then to execute the reports for all teams and seperated by team? Can't find "team" as an attribute in any work item?
Robert, TFS doesn't have the notion of team. My recommendation is to use the Area Path field to map things that belong to different teams. All the reports support Area Path and allow you to filter them by that field.
Hi, We are in the process of moving from Conchango V2 to this new template that looks very promising. Each project has multiple teams and the Area field is used heavily to track the area of the PBI or Bug: Rendering, Data base, Component X, UI, Localization... that is critical to identify the areas of problems or Improvements. What else would you suggest so that we can have a smooth migration in the future? Create a new Field? Use the "Assigned to" for PBIs and Bugs?
we want to migrate away from SfTS 2.0 so I evaluated three options:
1 - MSF Agile 5.0 2 - SfTS 3.0 3 - Microsoft Visual Studio Scrum 1.0
I was getting very excited with the third option because it has all we need without useless/complex features that can only confuse our teams. This template is very lightweight and focus on the essence of Scrum.
But then, when I looked at how it could handle multiple teams working on the same backlog, I got very disappointed. I am currently working on a single product that has a single product backlog (obviously) but multiple teams are working on that backlog at the same time. Given that structures, we would need the following additional reporting capabilities:
- Release burndown per team - Sprint burndown per team - Velocity per team - Build success over time per team (note that each team have the same build definition but in different branches) - Build Summary per team (same comment as above) - Test Case Readiness per team - Test Plan Progress per team
Note that we CAN'T use the area path to act as a team filter path the teams are cross functional and can work on any area of the application. Also, in case you ever want to support our scenario, note that our teams sprint do not start on the same day and may not have the same sprint duration. This scenario is properly supported by SfTS 3.0.
Because of all these limitions, I think that we will not be able to use Microsoft Visual Studio Scrum 1.0... unless you have a viable work around or a new version coming out soon ;)
So I installed the new Scrum Template and created a brand new Team Project using that template. All is good with respect to accessing the portal; however, on the how page of the portal where the Burndown graphs are shown I am getting a Reporting Services error. Specifically the error is shown below. I get the same exact error if I try to run the report from with the ReportServer Manager on the actual server machine. Digging around the Report Server Log files, I discovered the error but have no idea how to resolve. It almost seems like SQL tables were not updated or something. If anyone can help it would greatly be appreciated as this is what I believe is the last thing keeping me from moving forward with this new template. The errors are shown below.
ERROR SHOWN ON PORTAL: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for dataset 'dsBurndown'. (rsErrorExecutingCommand) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors"
ERROR SHOWN IN REPORT SERVER LOG FILE: Processing!ReportServer_0-5!1364!08/18/2010-11:44:16:: e ERROR: An exception has occurred in data source ‘dsBurndown’. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘dsBurndown’. - Microsoft.AnalysisServices.AdomClient.AdomErrorResponseException: Query(3,2) The member ‘[Microsoft_VSTS_Scheduling_Effort]’ was not found in the cube when the string, [Measures].[Microsoft_VSTS_Scheduling_Effort], was parsed.
The Sprint Burndown Report doesnt seem to be working particularly well for me. I am in the first 4 week sprint; I have 6 ToDo tasks totaling 84 hours remaining work, the report show more like 160. I have one task In Progress totalling 24 hours remaining work, the report shows more like 190. The ideal trend line starts at around 15 or 20 and drops to 0. The remaining work axis starts at 0 and goes to 200.... All these numbers are wrong.
Any ideas, this is really frustrating as the numbers on the report make no sense, but the report is of great importance.
Carl, I've certainly never seen this before. Are you sure there aren't other tasks in the project with hours that are skewing the chart? Also, check to be sure that you don't have more than one sprint work item assigned to the iteration.
The sprints/iterations are the default ones. There are dates alreay set on a lot of them. Other than this there are no tasks with a crazy amount of hours against them. In fact, there are not many at all. I am also now getting a major error that is stopping me from using the system. I will create a new post for this.
Aaron, since fixing my other issues by doing the migration, the "Today" indicator on the burndown report is always about 8 days ahead. Any ideas why this is or how I could fix it?
We're using the Agile 5.0 Process Template and have found the Excel work books to be incredibly valuable. I was excited to take a look at this power template...but it's really unfortunate that it doesn't include any excel work books.
I saw this comment: "We're in the process of designing some new Scrum sprint planning/execution tools and decided to bypass updating the workbooks unless people really felt that it was critical to have. We'll be taking feedback on priorities over the next couple of months."
I think it is critical for us to have excel work books if we are going to be able to adopt this process template.
Can we please get full features excel work books with this template?
My team has become quite enamored with the Excel work books in 2010 and in fact the planned capacity and vacation tabs on the work books has proved inordinately valuable as we’ve planned our sprints. [Didn’t know one of our KEY developers was getting married and taking a 2 week Honey-Moon for instance].
I can understand that your trying to keep this template as light as possible but please PLEASE include a basic excel work book. It at least gives those of us evaluating the template feature parity with the other templates and it always us a starting point to customize an already existing work book. [We’ve got a few efforts underway to build additional tabs into the work books in the new future.] Thanks for listening and can’t wait to see this turn into a high quality release.
Hi Aaron, we are also using TFS 2010 and currently using the Excel templates for all of our sprint and product backlog planning. Infact the only reason we were able to convince our PM to use TFS is because of excel support which comes out of the box. We want to use the latest templates for scrum but with out excel it would be impossible to adopt it. Please keep us posted when you have some minimal excel support.
Hi Aron, we are also using TFS 2010 but one thing which is missing which is proper planning tool, Excel Workbook was also helpful but there should be a proper web based Planning Tool. Thanks!
Thanks guys. This is on our backlog. I appreciate you taking the time to express your interest in the workbooks. It's really valueable as we prioritize our work going forward.
We have a development group that is starting up soon and they are following Scrum. They've looked at the Scrum for Team System Template v3 and the feedback we heard from them was that it sees to have many more of the features they'd expect in a Scrum process template. What dissapointed them the most about the Scrum for Team System Template was the fact that in the Agile Template there are the great excel workbooks. In evaluating the TFS Scrum 1.0 template they were really surprised that it doesn't have excel workbooks either. I'd love to hear some sort of commitment from MS that excel workbooks will in fact be coming to the TFS Scrum 1.0 template. If it won't be coming then atleast we can give our Dev groups the right guidance that at this point they need to use the Agile template.
We used a plug-in for Web Access called Urban Turtle that provide a very good Planning board and Task Board. This tool also provide a real time burndown that work with tfs basic. try it urbanturtle.com !
Can Visual Studio Scrum 1.0 & Scrum v1.0 Beta coexist?
I currently have the Scrum v1.0 Beta installed and imported into both of my TFS collections (Collection A & B). Also during the beta template installation, I deployed the SharePoint solution to the TFS Portal. I created a Team Project in Collection A with the Beta template and that Team Project is currently active.
Now it RTM'd and, I want to install/import the Visual Studio Scrum 1.0 template into both collections, deploy the SharePoint solution and create a new Team Project from this template in collection A.
Will there be any conflict in doing this? Can they coexist in all systems... TFS, SharePoint, SSRS/SSAS?
The plan is to at some point soon upgrade the Team Project in Collection A that was created with the Beta template using Donovan Brown's upgrade instructions; however, in the meantime I want to allow new Team Projects to get created with the RTM'd template.
I'm experimenting with this in my demo system. The import works as expected; however, when I add the .wsp solution to SharePoint stsadm, it states:
A solution with the same name "microsoft.teamfoundation.sharepoint.scrum.wsp" or id "675b95f2-bf14-4d60-9b80-2a696c9fe80c" already exists in the solution store. C:\Microsoft Visual Studio Scrum 1.0\Project Portal\Microsoft.TeamFoundation.SharePoint.Scrum.wsp: The Solution installation failed.
With that, I'm guessing I'll need to execute stsadm /deletesolution to remove the beta .wsp file but I'm not familiar enough with SharePoint administration to know for sure or if anything else beyond that needs to occur. Would you be able to provide some direction here on how to proceed?
When you have a SharePoint solution already installed you should upgrade the solution rather than retracting/deleting first. For the Scrum template the following command should help you: stsadm -o upgradesolution -name microsoft.teamfoundation.sharepoint.scrum.wsp -filename <pathToNewWsp> -immediate -allowgacdeployment
We installed the new Scrum 1.0 and everything works great except… If you view a report the Sprint Selection and the Area Selection are empty with no Errors. We are able to assign the Iteration on the Product Backlog. I verified my account is in the Project Administrators group. Does anyone know why this is?
Brian, the reports are populated with values that have been processed by the cube. In this case, it's likely that the cube isn't processing... and therefore the report parameters are empty.
Would like to see a template to migrate a project from MSF for Agile (VS 2010 RTM version) to the new Visual Studio Scrum 1.0 template. We are actively using the MSF for Agile project but would like to use the Scrum 1.0 template. We simply don't have the time to come up with a custom migration configuration and learn the TFS Integration Tool on CodePlex or re-key in our entire product backlog.
If this is the template Microsoft is suggesting for Scrum teams, then it would be nice if Microsoft came up with a template for migrating projects from the MSF for Agile Software Development v5.0 to the new Scrum 1.0 template. I know that I can use the TFS integration tool on Codeplex to perform the migration, but having a template that automatically mapped the fields would be invaluable.
I have already got sprints assigned to an iteration, backlog items associated to a sprint, tasks associated to the backlog items. The tasks have been assigned an Area, all areas were created prior to new tasks being created. I have now created a new area and tried to assign items to this area, but depending on how I edit the item I get the following errors;
Opening the Sprint Backlog query and editing the task from there; 0 work items were saved, but 1 work items could not be saved.The following Work Item could not be saved:Product Backlog Item 98: CARAT Permission SecurityTF237165: Team Foundation could not update the work item because of a validation error on the server. This may happen because the work item type has been modified or destroyed, or you do not have permission to update the work item.Please correct the unsaved work items and try again.
Opening the task from the Sprint Backlog query and editing it;
TF26212: Team Foundation Server could not save your changes. There may be problems with the work item type definition. Try again or contact your Team Foundation Server administrator.
I dont think it is permission issues as I have full admin rights.
Please help this is now stopping us from using it.
I have now solved my problem (only to have another... this is a reoccurring theme). My solution was to use the TFS integration tool on Codeplex (http://tfsintegration.codeplex.com/releases/view/35476) to migrate to another server that I had built for temporary use, then effectively rebuild the original TFS server before migrating back again. This seems to have fixed all my problems, but I am now really nervous about adding another area as it was after this that all the trouble started before.
As for my new problem... on the sprint burndown report everything looks good, but the red "Today" bar is not on today despite the date on the server being correct. I event checked the GETDATE() value on SQL Server and that is correct.
I am starting to lose a lot of faith in this template.
This is great beginning. Thanks you team. When do you expect final version? Is there migration guide available from Scrum for Team System Conchango process template v2.2?
You can migrate using the TFS Integration Platform (http://tfsintegration.codeplex.com/). You can use the platform to migrate your data from your old project to a new project started from Microsoft Visual Studio Scrum 1.0.
Event Description: TF30162: Task "GroupCreation1" from Group "Groups" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: TF218018: The XML in the process template is malformed. A problem exists with the following permission class: PROJECT. The permission class does not support the specified permission: VIEW_TEST_RESULTS. Contact the provider of the template and obtain a corrected XML file. Use the Process Template Manager to upload the new template file to Team Foundation Server and then try the operation again. Stack Trace: at Microsoft.VisualStudio.TeamFoundation.GssStructureCreator.ValidateGroupsAndPermissions(ProjectCreationContext context, XmlNodeList groupXmlNodeList) at Microsoft.VisualStudio.TeamFoundation.GssStructureCreator.Validate(ProjectCreationContext context, XmlNode taskXml) at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.TaskValidator.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml) at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.RunTask(Object taskObj)
I think an upgrade from 2005 to 2008 was the cause of these permission nodes not existing. We've got a 2010 install that I'm now trying, it fails too but with an error:
"Event Description: TF30162: Task "Queries" from Group "WorkItemTracking" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: TF237195: The following user name is not supported: [SERVER]\Team Foundation Administrators"
I Created a new project on my TFS server using the new v1.0 template and set up all my sprints, backlog items, allocated some backlog items etc. It all worked nicely, thank you. I then deleted my old project that used the old beta template - when my SSIS job runs to process the cube I now get the following errors;
[Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Invalid column name 'Microsoft_VSTS_Common_OwnedBy__PersonSK'.; 42S22. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimTestCaseOverlay', Name of 'Test Case' was being processed. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the 'Previous State' attribute of the 'Test Case' dimension from the 'Tfs_Analysis' database was being processed. [Analysis Services Execute DDL Task] Error: Internal error: The operation terminated unsuccessfully. [Analysis Services Execute DDL Task] Error: Server: The operation has been cancelled. [Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimTestCaseOverlay', Name of 'Test Case' was being processed. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the 'System_Id' attribute of the 'Test Case' dimension from the 'Tfs_Analysis' database was being processed. [Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimTestCaseOverlay', Name of 'Test Case' was being processed. [Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while the 'System_Title' attribute of the 'Test Case' dimension from the 'Tfs_Analysis' database was being processed.
When trying to process the cube in analysis services the Work Item dimension fails due to invalid column name System_AssignedTo__Name. Has anyone else run across this?
My fault. Once I created tasks and assigned them to resources I was able to process the cube and the invalid column error went away when I processed the cube. All of the reports work now.
Error when installing - Object reference not set to an instance of an object
I'm following this guide here: http://visualstudiomagazine.com/articles/2010/07/27/installing-scrum-process-template.aspx to install the MSVS Scrum 1.0 template. I've managed to add the template to the Process Template Manager without a problem. But when I try to install the Sharepoint component via command(run as administrator): stsadm -o addsolution -filename Microsoft.TeamFoundation.SharePoint.Scrum.wsp I receive the error:
Object reference not set to an instance of an object. Microsoft.TeamFoundation.SharePoint.Scrum.wsp: The Solution installation failed.
Any idea about what this might mean? The TFS version is 2010, same version for VS so pretty sure it's not a versioning issue.
This is really cool, but I can't get any of the predefined reports to run. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors
Is this something I can fix myself?
Sorry if this is the wrong forum ... love this product though!
I also get an error message executing Sprint Burndown Report.
German message: Fehler bei der Berichtsverarbeitung. (rsProcessingAborted) Fehler beim Ausführen der Abfrage für das dsSprintsCurrent-Dataset. (rsErrorExecutingCommand) The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
English: (Error with report execution (rsProcessingAborted)) Error in executing selection for dsSprintsCurrent-Dataset. (rsErrorExecutingCommand) The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
I think this error is related to one of my other posts. The reports only seem to work when the date parameters are provided in US format. If you change your machine locale to US, they will work. I hope this gets fixed for the first release.
We have exactly the same problem. Is there any workaround to use the reports with the current version. I tried to change the local settings to US format, but it doesn't help. Any idea or when can we expect a fix for this issue? Thanks in advance
Did you find out what Harry's problem was? I just installed the SCRUM template to test it, and got the same error, would appreciate you sharing what the problem/resolution was :)
Well.. To answer my own question. The reason for the error is that the warehouse update hasn't been executed before running the reports. Wait for a while and it will fix itself.
I can't create a team project with SCrum v1.0 process template. The project creation wizard had problems while uploading documents to the server. Furthermore, in the error log it says:
Module: WSS Exception Message: TF249033: The site template is not available for the locale identifier (LCID). The site template name is: TFS2010 Agile Dashboard. The LCID is: 1033. (Typ TeamFoundationServerException)
Ausnahmestapelüberwachung: bei Microsoft.TeamFoundation.Client.SharePoint.SharePointTeamFoundationIntegrationService.HandleException(Exception e) bei Microsoft.TeamFoundation.Client.SharePoint.SharePointTeamFoundationIntegrationService.CreateSite(String webApplicationUrl, String absolutePath, String title, String description, UInt32 localeId, String template, Boolean templateIsTitle, String ownerLogin, String ownerName, String ownerEmail, Guid configurationServerId, Guid projectCollectionId) bei Microsoft.TeamFoundation.Client.SharePoint.WssUtilities.CreateSite(ICredentials credentials, Uri adminUrl, WssSiteData siteCreationData, Guid configurationServerId, Guid projectCollectionId) bei Microsoft.TeamFoundation.Client.SharePoint.WssUtilities.CreateSite(WssSiteData siteCreationData, TeamProject settings) bei Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.CreateSite(WssSiteData siteCreationData, WssCreationContextWrapper contextWrapper) bei Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.HandleSiteCreation(WssCreationContextWrapper contextWrapper, XmlNode taskNode)
Interne Ausnahmedetails:
Ausnahmemeldung: TF249033: The site template is not available for the locale identifier (LCID). The site template name is: TFS2010 Agile Dashboard. The LCID is: 1033. (Typ SoapException)SoapException-Details: <detail exceptionType="TeamFoundationServerException" />
I also installed the WSS 3.0 language pack - still the same problem. What can I do here?
I am new to TFS and have just completed my first sprint plan and am now tracking the team's progress. After the Sprint began we discovered several additional tasks which caused our To Do estimates to increase. We still have capacity to complete these items within the Sprint. However the Ideal Trend line was calculated on the first day of the sprint and does not take into consideration this additional work. The result is that the Ideal trend line does not reflect the ideal burndown for the capacity of the team.
Does anyone know how to modify the data of the ideal trend line to better reflect the capacity of the team for the sprint?
I keep having persistent problems with getting the Scrum 1.0 reports to work. The only report that is sort of working is the Velocity (and even then I have to select all sprints in the filter manually, otherwise it shows only the first 3 sprints for some reason and we are on sprint #5 now).
The Sprint Burndown always returns "No Data Available" and Release Burndown is showing an empty grid with 10 points on the Effort (Y) axis and all sprints along the X axis, but no bars?! I tried forcing both Incremental and Full update processing of the cube using the WarehouseControlWebService page, but no change.
I had similar problems - these reports look at the past and the present and you need defined sprints in progress. Try assigning some backlog to an iteration (then the sprint will appear in the Sprint dropdown), then set the sprint start date to today's date or to the past. Finally, after doing this you'll probably have to process the data warehouse and analysis services cube via the instructions at http://msdn.microsoft.com/en-us/library/ff400237.aspx (use Incremental on ProcessAnalysisDatabase operation or you'll be waiting a while). Once these are all done you should be seeing them function as they will in the midst of an active set of sprints. Cheers.
Joel, You are correct about the data in the sprints being the driving force behind the reports. I have had the backlog items entered a while ago and even assigned some of them to a couple of sprints, but they still did not make their way into any reports until I have finally started tracking everything for the current sprint including creating and assigning tasks, changing their status etc. I sort of expected that outcome for the Sprint Burndown report, which is dependent on the active tasks, but I expected that the Release Burndown report would only need the items in the backlog with non-zero effort values. Also, I am not very fond of having to enter everything in near real-time mode in order for the reports not to look weird. For example, I was one day late entering the tasks into the TFS and now my Sprint Burndown chart looks like a pointed triangle instead of a right triangle. I would prefer if it were possible to specify (or at least change) the starting date of a work item, so that I don't have to deal with distorted charts if I didn't get a chance to update TFS on time.
Same goes for the prior sprints data. We have started using TFS around sprint #4 and now my Release Burndown chart has only a single bar for Sprint #5, even though I entered all past work items and pushed them through all the stages all the way to the Done state.
Donovan, Thanks for figuring this out and posting the solution - we'll have to take a similar route and it is greatly appreciated.
Hi Aaron,
By any chance, has anyone on your team come up with an XML configuration for the TFS Integration Platform to migrate work items from a team project based on the beta to the official release or is it best just to due an in place migration on the same project as Donovan has outlined above?
All, I used TFS Integration tool to migrate our old beta project to a new team project based on the release template. As I wanted to get it accomplished within a day and was just learning the XML for the tool, when I hit problems mapping OwnedBy to AssignedTo, I just had the OwnedBy field ignored, which was fine for our needs. If you need to duplicate quickly, here's how: 0. Create a new team project based on the official Scrum release if you haven't already done so. 1. Download TFSIntegrationTools.msi from Downloads tab at http://tfsintegration.codeplex.com/ and install. 2. Run the TFS Integration application (it may ask you to manually start the associated windows services). 3. Choose Create New - in the explorer window that pops up navigate to "Team Foundation Server" folder and choose WorkItemTracking.xml or VersionControlAndWorkItemTracking.xml depending on your needs (we just needed the former). 4. Choose your Beta team project/server on the left side and your Scrum 1.0 release project/server on the right side. 5. Go to the bottom tab and choose Xml so you can make the following changes: a. Under both Configuration/SessionGroup/MigrationSources/MigrationSource nodes change <CustomSettings /> to <CustomSettings> <CustomSetting SettingKey="EnableBypassRuleDataSubmission" SettingValue="false" /> <CustomSetting SettingKey="DisableAreaPathAutoCreation" SettingValue="false" /> <CustomSetting SettingKey="DisableIterationPathAutoCreation" SettingValue="false" /> </CustomSettings> NOTE: This will auto-create your paths and iterations for migrated work items for you b. Under Sessions/Session/CustomSettings/SettingXml change the existing <WITSessionCustomSetting> node to the following: <WITSessionCustomSetting> <Settings /> <WorkItemTypes> <WorkItemType LeftWorkItemTypeName="*" RightWorkItemTypeName="*" fieldMap="AllToAllFieldMap" />
Continuing above due to truncation: b. Under Sessions/Session/CustomSettings/SettingXml change the existing <WITSessionCustomSetting> node to the following: <WITSessionCustomSetting> <Settings /> <WorkItemTypes> <WorkItemType LeftWorkItemTypeName="*" RightWorkItemTypeName="*" fieldMap="AllToAllFieldMap" /> </WorkItemTypes> <FieldMaps> <FieldMap name="AllToAllFieldMap"> <MappedFields> <!-- <MappedField MapFromSide="Left" LeftName="Microsoft.VSTS.Common.OwnedBy" RightName="System.AssignedTo" /> --> <MappedField MapFromSide="Left" LeftName="*" RightName="*" /> <MappedField MapFromSide="Left" LeftName="Microsoft.VSTS.Common.OwnedBy" RightName="" /> </MappedFields> </FieldMap> </FieldMaps> </WITSessionCustomSetting>
NOTES: * If you want to work with the OwnedBy field and post solution uncomment the commented out node and comment out my one that maps to nothing. * If you add a team project AFTER the "TFS Integration" service is started you'll need to shut down the GUI app and restart the service or it won't find it.
I am getting below error while creating a new project with Scrum process template. any help really appreciated
Error TF30170: The plugin Microsoft.ProjectCreationWizard.Build failed during task BuildTask from group Build.
Explanation Plugin error text: “The path C:\Documents and Settings\devtfs2010\Local Settings\Temp\tmp3A.tmp is already mapped in workspace DEVTFS2010.”
User Action Contact your Team Foundation Server administrator.
The error you saw is due to having a workspace (DEVTFS2010) mapped to one of the parent directories of %TEMP% (e.g., C:\). Please check if this is true, and remap the workspace to a more specific location (e.g. C:\Workspaces) which does not overlap with %TEMP%.
The error is a defect in Dev10 RTM which will be fixed in Dev11. But having the workspace mapped to a general location such as C:\ is not a recommended practice anyway.
Yesterday we updated the download to include a fix for the Sprint Burndown report which was found to have a bug in it that caused in an error when viewing in non-US locales. The report has been updated.
If you're seeing the following error on the Sprint Burndown report grab a new copy of the template and give it another shot: "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
we installed now the template. If we open the Sprint Burndown, there is no sprint available. But we have created 5 Sprints with Sprint Items. Do we have to change the reports to select the sprints?
It sounds like your cube isn't being processed. The Sprint drop down reads data from the cube, so until your cube has been processed, there won't be any sprints available to choose from. If you're still not seeing any sprints, try manually processing your cube - http://msdn.microsoft.com/en-us/library/ff400237.aspx.
Alex, on 2nd thought... you won't see the sprints appear until you have data for them. Assign a few tasks to the sprints and then you'll see them show up.
In investigating this template I have to ask, is this template like the e-scrum template? If we rollout this template will we be supported for future upgrades/fixes or are we on our own like what happened with e-scrum?
Allen, this is DEFINITELY NOT like e-scrum. The e-scrum release was done outside the product group and was never integrated into the product's future. Microsoft Visual Studio Scrum 1.0 is different. Although it shipped out of band, you can consider this a part of the product going forward. You will get upgrades/fixes and support going forward.
Where did the files go after I installed them? I remember solving this for the beta, but I can't remember where they went. I can't add this template until I know where it went.
Couple of observations I made while upgrading a client from beta to V1. I noticed that <REASON value="Build Failure" /> is still missing on the bug. The process guidance is still referring to "Owned By" instead of "Assigned To" on the work items.
Thanks Donovan. Yes, we basically removed the "build failure" scenario from the bug work item. I know this is controversial, but you can read some of our thinking on my post: http://blogs.msdn.com/b/aaronbjork/archive/2010/07/19/announcing-microsoft-visual-studio-scrum-1-0.aspx
The guidance will be refreshed at the end of this month.
Thanks!
Update existing project from the Beta template to the RTW version
Hi Aaron, I'm sure you guys are probably developing this template in an agile manner, but do future backlog items for this template include trying to match the rich feature set in MSF Agile (although probably with reduced complexity), specifically: * Full guidance documentation * A template with the SDL integration as is available for MSF Agile * Supporting spreadsheet integration like MSF Agile for backlog and sprint planning ?
Also, would there be the ability to transform projects (e.g., work items, etc) from MSF Agile to Scrum template or is that simply impossible. We are migrating to TFS 2010 and want to adopt scrum in our projects and are deciding between the two templates. I know there is no set release date yet so we may be forced to use MSF Agile but wanted to know if we go down this road if we'll be looking at starting brand new Team Projects to switch from MSF Agile -> Scrum down the road.
Would it be possible to consider adding the Height and Width parameters to the Sprint Burndown report so we can have more leverage when using the report in a Dashboard?
I know this is largely a cosmetic change, but I find it a tad bit annoying that in the Process Template Manager that the process templates listed (which are installed) are as follows: MSF for Agile Software Development v5.0 MSF for CMMI Process Improvement v5.0 Team Foundation Server Scrum v1.0 Beta
What I'd really like to see this scrum template called would be: Scrum for Agile based Scrum Development Processes v1.0
When I have dozens of people creating team projects they are going to keep asking me where is the Scrum template?, they are NOT going to ask me for the Team Foundation Server template.
I think having the following list of templates would be really clear: MSF for Agile Software Development v5.0 MSF for CMMI Process Improvement v5.0 Scrum for Agile based Scrum Development Processes v1.0
It is very helpful when during a Sprint we can see what is currently being worked on at the PBI level. The state In Progress is very helpful to get visibility at the PBI level since the queries we use to view the Sprint Backlog also include the PBIs. Currently, we are forced to inspect every PBI breakdown to get a sense of what's happening.
Similarly, during Sprint the state Ready for Test is also helpful as it gives visibility to The Team to tackle these right away in order to close PBIs as soon as they are ready.
Are their any plans to add states such as In Progress and Ready for Test to the PBI? These would be applicable between Committed and Done.
Thanks Leo. There aren't plans at this point. My feeling has always been that it feels like overkill... you can do this with a directed links query to look for stories with tasks that have been started. How do others feel?
Why is it why I download the template from Visual Studio Gallery I have to manually install/upload the template myself? The Conchango guys ship an MSI for their template and it makes updating multiple TFS servers really easy, especially when we can use configuration manager to push out the template during a scheduled down time.
Will there be an automated, MSI package for the template when it RTMs?
Dave/Allen - correction. I realized I misspoke. We're bulding an MSI... but we're not planning on the install actually uploading the template. It's definitely on our backlog, but won't be in the first release.
When creating a product backlog item or a task programatically via C#, then the description field is never filled with the text I set. All other fields are working fine. In the agile template also the description is set.
The Description field is HTML. Make sure you set this field before you call Save for the first time. For some reason, updates to HTML fields are disabled. You get the same problem if you try to do these types of updates from Excel. You will not get an error it will just not work.
I write an open source tool for TFS called Scrum Sprint Monitor and I was looking into your process template in order to give early support for it. One thing I noticed is that the template for Tasks does not track the work that has been done on that particular task (Microsoft.VSTS.Scheduling.CompletedWork), only the remaining work. Is that something you are considering adding to the template?
We have considered it, but have purposely left it off (for now). Most Scrum teams I talk to are concnerned only with remaining work. Completed work is "interesting"... but remaining work is what drives a Scrum team through a sprint. Our goal with the template was to nail the basics that apply to all teams. I'd love feedback on this however. Are others interested in completed work?
IMHO, Completed Work is noise in Scrum. I am even glad to see that Estimated Work is not used in the template. What we have seen is that Developers would have a tendency to simply subtract Remaining Work from Estimated Work (i.e. MSF Agile) and apply that to Completed Work just for sake of filling the field. You get no real benefit of tracking just a false sense of where you are. Reality is that you can be at 99% completed for 50% of the time it really takes to complete a Task.
I understand your point lefting CompletedWork field off, but when I try to view the Sprint Tasks inside MS Project I get the following error message related to this field:
--------------------------- Microsoft Office Project --------------------------- TF82024: The following fields could not be mapped because the fields could not be found on the server: Microsoft.VSTS.Scheduling.CompletedWork;Microsoft.VSTS.Scheduling.OriginalEstimate --------------------------- OK ---------------------------
@Juliano, have you considered copying the definitions of these fields from the Task work item in the MSF Agile 5.0 process template? That will allow you to open the query in MS Project and see the Tasks. You can also decide whether or not you need to display these in the UI through the Work Item editor. You can use the Process Template Editor that is part of the TFS 2010 Power Tools, if you did not already know about it, to make these definition changes visually.
@Aaron, perhaps there's an improvement to the Task work item in the TFS Scrum process template where these fields are included but not displayed in the UI in order to support MS Project without errors. The problem is similar to what Donovan described earlier regarding the builds. Maybe there's a case here for compatibility.
Aaron, I brought up Microsoft.VSTS.Scheduling.CompletedWork by mistake. What I meant to ask is about an original estimate. It is very important for my tool to have an idea of what the original estimate was for a given task (and I believe it is beneficial for anyone who is looking at a task to know that as well).
It appears that the Sprint work item does not have a Capacity field. Is there a rationale behind not including it? Do we assume this field is not necessary anymore?
Leo - can you tell me more about what you'd like included? The sprint work item is designed to caputre sprint dates, the sprint goal, and the sprint retospective. When you say capacity, are you referring to hours for the team? Something else?
Both MSF Agile 5 and Conchango Scrum 3 allow the specification of Capacity (in hours) of the Team for a given Sprint as a predictor of what the Team can do for a Sprint. TFS Scrum does not utilize this value and I was wondering why it did not. I understand that once a Team has a Velocity it does not need to necessarily use Capacity since the Velocity is the predictor of how much the Team can commit to deliver within a Sprint. I just need to be able to explain to my customers the difference. Thanks.
Got it. We're likely going to add it in later iterations. We didn't add it up front because we didn't see it as core to Scrum. I'd put it in the "coming soon..." bucket.
Are there any plans of creating a story board report, which has a lists of user stories on the left, with the associated tasks to the right, as in some competitors templates?
The current version of the template does not work with Team build. Team build cannot create a bug because the reason 'Build Failure' is missing see error below. Granted it is a easy customization (which I have already made) however, it should be in all templates so Team build does not error out.
TF42097: A work item could not be created due to a field error. The following fields have incorrect values: Field: 'Reason' Value: 'Build Failure'
Glad to hear. It appears you instead of using the out of the box priority field you created a new one for Backlog priority which leads to the following.
TF42095: Failed to update 'Priority' field. Error message: TF26027: A field definition Priority in the work item type definition file does not exist. Add a definition for this field or remove the reference to the field and try again.
You may consider using the built in priority field common to the majority of templates and just changing the label to Backlog Priority on the screen. I simply updated my build template to not set the priority and allowing Backlog Priority to take the default value.
One more thing about bugs created during the build. Once you add the “'Build Failure” reason and remove the Priority assignment from the build template none of the bugs are owned by anyone. The build template is trying to set AssignedTo.
If I want to create a SharePoint site manually to connect to an existing Team Project that uses the TFS Scrum template, which SharePoint site template should I use? It seems that TFS Scrum uses the TFS2010 Agile Dashboard site template but I am not sure. Can you please indicate which SharePoint site template to use?
Use the "TFS2010 Agile Dashboard" site template. This will provision the basic infrastructure needed for the Scrum dashboard Feature.
After creating the site you can then manually activate the "Team Foundation Server Scrum dashboard" Feature via the browser, or activate the same feature using "stsadm -o activatefeature -url <mySiteUrl> -name TfsScrumDashboard"
Thank you. That worked great. In addition I had to "Add a Team Project Portal" (http://msdn.microsoft.com/en-us/library/dd386320(VS.100).aspx). That enabled the site to be associated to my Team Project.
BTW, in addition I had to copy the Document Library files from another Team Project based on TFS Scrum process template so I could correctly link the Process Guidance urls in Team Explorer.
Thanks Leo. You're correct that the document libraries specified in the process template are not provisioned if you manually create the site through SharePoint using a site definition/template.
Document libraries (and content) in the process templates are provisioned by the New Team Project wizard after the SharePoint site has been created.
There is another option if you want to create a project portal (or reporting site) for an existing team project - check out Sunder Raman's blog post on "Adding Reports
Right now we have 3 reports - Release Burndown, Velocity, Sprint Burndown. We're planning to add 4 additional reports before we RTM around Test/Build:
Build Success Over Time - http://msdn.microsoft.com/en-us/library/dd380643.aspx Build Summary - http://msdn.microsoft.com/en-us/library/dd380708.aspx Test Case Readiness - http://msdn.microsoft.com/en-us/library/dd380713.aspx Test Plan Progress - http://msdn.microsoft.com/en-us/library/dd380702.aspx
We're certainly open to feedback on additional reports for later releases. Is there a report that you think belongs in the template?
I noticed that the Sprint Backlog Team Query contains the hardcoded value TFS Scrum\Release 1\Sprint 1 to filter on. After renaming the iteration to TFS Scrum\v1.0 RTM\Sprint 1, this query is broken.
This means that for this team query, someone has to modify it. Also because it is hardcoded someone needs to modify the query each iteration so that the query returns the correct WITs.
Yes, this is by design. The sprint folder containes all the queries for the team's current sprint. As time passes and teams move from sprint to sprint, each query in the folder will need to be modified to point to the appropriate iteration. Many teams copy the entire folder and create a seprate folder for each sprint. It's really up to you to decide.
Part of our Dev team is in India, they don't have access to our TFS server in USA. Currently, we are sharing excel file between us where we maintain the sprint activities. Will this template be helpful to me?
I don't think that this template will give you anything new to help with a distributed team that doesn't have access to the TFS server. Can you tell me more specifically what you're looking for?
Why the filter on Iteration Path = @Project in the Product Backlog Team Query?
Is there a reason why in the Product Backlog Team Query there is a filter on Iteration Path = @Project? And shouldn't this be Iteration Path Under @Project instead?
Yes, this is by design. The Product Backlog in the template is defined as "items in the the root iteration path"... which is @Project. If it was "under" instead it would include items assigned to sprints.
Free
View Large
