SQL SP1 killed some reports
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.
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
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
