SQL SP1 killed some reports  
Author Message
Badajoz95





PostPosted: Team Foundation Server - Reporting & Warehouse, SQL SP1 killed some reports Top

Hi,

I installed SQL SP1 onto my TFS. Unfortuntely a couple of reports broke:

Bug Rates, Bugs By Priority, Project Velocity, Reactivations, Remaining Work, Unplanned Work now report:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'dsWorkItemHistory'. (rsErrorExecutingCommand)
The '20060616' string cannot be converted to the date type.

Hmmm... anybody got any ideas - would be really appeciated.



Visual Studio Team System39  
 
 
Tom Patton





PostPosted: Team Foundation Server - Reporting & Warehouse, SQL SP1 killed some reports Top

It looks like you have old (pre-RTM) reports on your server. Is that possible There were changes in the way that time values are stored between beta3 and RTM.

If that sounds like a likely cause, you can redploy new reports by exporting the Process template (the latest process template definition from RTM), and adding all of the reports to a project using report designer) and re-deploying the reports. There are some more detailed steps for this process here:

http://msdn.microsoft.com/vstudio/teamsystem/b3rmigrate.aspx

Let us know if that helps!

-tom


 
 
Badajoz95





PostPosted: Team Foundation Server - Reporting & Warehouse, SQL SP1 killed some reports Top

Excellent . Thanks very much indeed Tom.

The link you sent me regarding downloading the process template (which I had updated) and then applying it to my existing project by uploading the report definitions worked a treat!

We have been using TFS since Beta 3 and I must have (a) negligently not updated the reports for our existing project since RTM and (b) not used the reports that err'd since I upgraded.

It was nothing to do with SP1 just the total opposite of serrendipity (answer that one! )

Again, thanks very much