3 days ago I installed "ScrumForTeamSystem.1.0.060325.014.msi".
Day 1. I added 1 Product Backlog Item, 1 Sprint, and 3 Sprint Backlog Items associated to the Product Backlog Item.
Day 2. I made some changes to states and work left to the Sprint Backlog Items.
Day 3. I tried to run each report and observed the following:
Here is the text of the error message:
Hello Dan
Could you try looking at the Reporting Services logfiles on your server? They should be on
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
They are arranged by date. Hopefully, there is one from Day 3 at the time you tried the reports. If it includes a stack trace it may provide clues as to what happened.
If not, then if you can send me screenshots of the 5 workitems showing the history tab, I’ll try to reproduce the problem here.
regards
Mark Lines-Davies
Thanks for the log file. The affected reports all seem to be having problems converting dates. The stack trace for the Bug History Chart is the most informative as it identifies a single field in a CTE: the Date field from the Work Item History Table.
Before I try looking at the data, could you just do the following, please?
Use Server Explorer from within Visual Studio to open up the TfsWarehouse database on your TFS server. Right-click the Work Item History and select Open Table Definition. Could you just check that the 12th field, Date, is a datetime?
The attached screenshot shows how it should look.
Mark
I don't have any way to see the attachment (I received no email from you).
That said, the 12th field is called Date and is of type int.
Hmmm..seems like we're on to something here.
I checked the data and it is all in the form of :20060421
Thanks, Dan
Hi Dan
Sorry about the attachment not being sent. However, I think we may be getting somewhere anyway...
In version Beta 3 of Team System, the Date was an int in the form yyyymmdd, which is what you are seeing.
Between Beta 3 and the RTM version, Microsoft changed it to a datetime. This of course left us with a fair bit of work to do to change our reports!
The result is that the current version of the Scrum plugin only works with the RTM and live versions of Team System.
In upgrading from Beta 3 to the live version, you have to start again with a fresh database. You can move your current data (i.e. without history) over via Excel as described in the Scrum Process Guidance.
Is this any help?
We are running the RTM version. We upgraded from Beta3 and followed the EXACT instructions provided by Microsoft to do this.
Any thoughts?
So when you upgraded, was it an "in place" upgrade, i.e. the upgrade was supposed to convert your data too?
If so, it does look like the upgrade didn't work properly, as the field in question is a standard Microsoft field. The field isn't added or changed by the Scrum plugin.
When we converted from Beta 3, we installed the RTM version on a separate server with a new SQL database and then migrated the data as a separate exercise. All I can suggest is that you do the same.
I'm pretty confident that if you run the RTM TFS Server installation on a new box, the Date field will be a datetime...
...could you try it?
It was an in place upgrade that was supposed to upgrade our data.
I have posted to the MSDN forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=367668&SiteID=1&mode=1
"Upgrade from B3R to RTM: Possible database upgrade issue."
I'll keep you posted on their response...
It turns out that our upgrade to RTM was not successful, and we actually had the RC database structure. After upgrading to RTM everything works as is should.
Thanks for your patience on this.
Dan
Helpful information from the RTM upgrade instructions:
To verify that you have Team Foundation Server RC installed
1. On the Team Foundation application-tier server, open the drive:\%PROGRAMFILES%\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\Services\Bin folder.
2. Right-click the Microsoft.TeamFoundation.dll file and then click Properties.
3. Click the Version tab and review the version number.
· If the version number is 8.0.50727.127, you have Team Foundation Server RC installed. Continue with the steps in this guide.
· If the version number is 8.0.50727.43, you have Team Foundation Server Beta 3 Refresh installed. Do not continue with the steps in this guide. You will have to follow the steps in Upgrading from Team Foundation Server Beta 3 Refresh to the Release to Manufacturing Version (RTM) of Team Foundation Server (also included with the upgrade software) to upgrade from Team Foundation Server Beta 3 Refresh to Team Foundation Server RTM.
· If the version number does not match either of the two numbers that were discussed earlier, you have another version of Team Foundation Server installed. Upgrade from this version to Team Foundation Server RTM is not supported. For more information, open the Microsoft Web site (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=68&SiteID=1).
Microsoft.TeamFoundation.dll versions:
8.0.50727.43 = Beta 3 Refresh 8.0.50727.127 = RC 8.0.50727.147 = RTM