TFS and VS 2012 Update 1 now available

re: TFS and VS 2012 Update 1 now available

Matt Wrock — Wed, 20 Feb 2013 01:27:53 GMT

Hi Mario, it sounds to me like your report definitions are out dated since there is no [Microsoft_VSTS_Scheduling_Effort] column in the reporting schema. The best way to address this issue is to modify the report by replacing it with an up to date report. I suggest taking the following steps to accomplish this:

1. In Report Manager (by default this is http://<servername>/Reports), navigate to the folder for the project with the erroneous report and delete the entire project report folder. Note: this will delete any custom reports as well. However, since you mention that you are not sure if your reports have ever run, it is likely you never created custom reports.

2. Create a new project with the same project type of the project that you deleted the reports for.

3. Go back to the ReportManager and navigate to the report folder of the new project. Select "Folder Settings" and rename it to the project folder that you previously deleted.

4. You may now delete the project you just created. The reporting folder will remain.

Matt

re: TFS and VS 2012 Update 1 now available

Mario Measor — Tue, 19 Feb 2013 21:35:20 GMT

We just noticed our reports won't run anymore, and we think it might have something to do with update 1. To be honest, I am not sure if the reports ever ran, but can someone help with this? I have never worked with reporting services before.

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for dataset 'dsVelocity'. (rsErrorExecutingCommand)

Query (8, 3) The '[Microsoft_VSTS_Scheduling_Effort]' member was not found in the cube when the string, [Measures].[Microsoft_VSTS_Scheduling_Effort], was parsed. Query (3, 2) The '[Microsoft_VSTS_Scheduling_Effort]' member was not found in the cube when the string, [Measures].[Microsoft_VSTS_Scheduling_Effort], was parsed.

re: TFS and VS 2012 Update 1 now available

Elan Hasson (PTIC) — Tue, 12 Feb 2013 15:37:48 GMT

How do you upgrade the process template of an existing team project from Scrum 2.0 to 2.1?

re: TFS and VS 2012 Update 1 now available

Buck Hodges — Fri, 11 Jan 2013 13:51:05 GMT

Mario, yes, you can still use VS 2012 RTM with a server that has Update 1 installed (and VS 2012 Update 1 will work just fine with TFS 2012 RTM or TF Service).

re: TFS and VS 2012 Update 1 now available

Mario Measor — Fri, 11 Jan 2013 13:42:11 GMT

Can you still use Visual Studio 2012 without Update 1 applied, or should we force everyone to update to VS Update 1?

re: TFS and VS 2012 Update 1 now available

Buck Hodges — Wed, 19 Dec 2012 14:29:51 GMT

Joshka, there is but it's only in the MSDN subscriber download. I'll ask folks to add that to the VS download page.

re: TFS and VS 2012 Update 1 now available

Joshka — Wed, 19 Dec 2012 02:07:29 GMT

Is there a checksum for the files anywhere?

This prevents download / copying errors from ruining the ISO.

re: TFS and VS 2012 Update 1 now available

Buck Hodges — Sun, 02 Dec 2012 15:42:52 GMT

Understood and thanks for the feedback. We'll add this to the list of improvements to make.

re: TFS and VS 2012 Update 1 now available

Mark Slaven — Sun, 02 Dec 2012 06:53:54 GMT

Buck, it does help but it still blows. I mean you can't restrict WMI to a single port or small range, right? I just don't get why the wizard forces me to have WMI open for this and won't let me manually put in the information. Now I gotta migrate the reports. Regardless, thanks for the original post and your helpful response to my question.

re: TFS and VS 2012 Update 1 now available

AndreaMS — Fri, 30 Nov 2012 18:41:26 GMT

Hi Mark - Unlike in the clean install scenario, we actually do no support upgrading reporting from the admin console. Many of our upgrades change the database schema such that old reports will no longer work. However, there is a workaround for this, which basically just entails renaming the database. See the following blog post for a walkthrough: blogs.msdn.com/.../when-trying-to-enable-reporting-after-upgrading-my-server-i-get-a-schema-warning.aspx

Hope this helps!