Search Sort Posts:  Oldest to newest Newest to oldest

04-12-2006, 6:12 PM DBreggin Joined on 04-12-2006 Posts 8 Problem with some reports 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: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'ViewData'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors ScrumForTeamSystem.1.0.060325.014.msi Report Name Status All Product Backlog Items Runs All Sprint Backlog Items Runs All Sprints Runs Bug Count Runs Bug History Chart Fails Bug Priority Chart Runs Current Sprint Status Runs Delta Report Fails Delta Report Small Fails Impedement Report Runs Product Backlog Composition Runs Product Burndown Chart Fails Product Burndown Chart Small Fails Retrospective Report Runs Sprint Burndown Chart Fails Sprint Burndown Chart Small Fails Sprint Overview Chart Fails Sprint View Fails    Report

04-12-2006, 6:15 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports .    Report

04-13-2006, 10:14 AM markld Joined on 04-13-2006 Posts 137 Re: Problem with some reports 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    Report

04-17-2006, 9:16 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports Here is the log file    Report

04-18-2006, 9:14 AM markld Joined on 04-13-2006 Posts 137 Re: Problem with some reports Hello Dan 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. regards Mark            Report

04-21-2006, 9:26 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports 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    Report

04-24-2006, 8:42 AM markld Joined on 04-13-2006 Posts 137 Re: Problem with some reports 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? regards Mark              Report

04-25-2006, 5:24 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports We are running the RTM version.   We upgraded from Beta3 and followed the EXACT instructions provided by Microsoft to do this. Any thoughts?    Report

04-25-2006, 5:43 PM markld Joined on 04-13-2006 Posts 137 Re: Problem with some reports Hi Dan 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? regards Mark            Report

04-25-2006, 7:04 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports 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... Thanks, Dan    Report

04-28-2006, 6:40 PM DBreggin Joined on 04-12-2006 Posts 8 Re: Problem with some reports 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    Report

Scrum for Team ... » Version 1.2 - T... » Scrum for Team ... » Problem with some reports

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Scrum for Team System |- Scrum for Team System - Announcements |- Scrum for Team System - Feature Requests |- Scrum Guidance Version 2.x - Team Foundation Server 2008 |- Scrum for Team System - v2.x Support |- Engineering Practices – v2.2 Reports Version 1.2 - Team Foundation Server 2005 |- Scrum for Team System - v1.x Support Task Board for Team System |- Task Board for Team System - Support |- Task Board for Team System Beta Discussions (Read Only)