Strange (and annoying) problems with reporting after upgrading to TFS 2008

Question

Since upgrading from TFS 2005 to TFS 2008, I have been plagued with reporting annoyances that I have not been able to solve.

 

In particular:

 

I) TFS Warehouse Issues

 

TFS warehouse was corrupted and throwing errors when accessing reports. I was able to correct it by deleting and rebuilding the warehouse…. Or so I thought. Now I must manually execute the “http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx” run command in order to recalculate, say, “Bug Rates” or all trends peg at “0” (Active, New, and Resolved).

 

Rerunning the command generates a boatload of event log errors related to code churn as follows:

 

Event Type:        Error
Event Source:     FS Warehouse
Event Category:  None
Event ID:           3000
Date:                 3/26/2008
Time:                10:02:59 PM

Description:

TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 3/27/2008 5:02:59 AM
Application Domain: /LM/W3SVC/3/Root/Warehouse-5-128510672662500661
Assembly: Microsoft.TeamFoundation.Warehouse, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

  Process Name: w3wp
  Process Id: 3048
  Thread Id: 2164l

Detailed Message: Microsoft.TeamFoundation.VersionControl.Adapter: An unexpected exception occurred while calculating code churn: Calculating differences. Previous: changeset 4113, item $/[root]/MAIN/Application/Source/Projects/[project]/app.config, encoding 65001. Current: changeset 4117, item $/[root]/MAIN/Application/Source/[project]/app.config, encoding 65001. , exception:

Exception Message: The file exists.

 (type IOException)

 

II) Alert Report Issues:

 

The changeset email "alert" seems to be formating differently, with summary information being squished to the far right of the report, making things like comments virtually unreadable (a couple of words per column now).

 

For example (Summary section Before and After TFS upgrade):

 

Before -    | Comment:          blah blah blah blah blah|

               |                          blah blah                     |

 

After -      | Comment:                               blah blah|

               |                                               blah blah|

               |                                               blah blah|

               |                                               blah       |

 

I have no idea what to do about any of this at the moment... any suggestions on how to correct these or proceed?

Answer 1

For issue #1, The default refresh interval is one hour.  If you happen to do a build immediately after the last refresh, you would be waiting about an hour for the data warehouse to be updated.You can, however, adjust this interval by using the warehouse controller web service:
http://msdn2.microsoft.com/en-us/library/ms244694(VS.80).aspx

Could this be the updating issue you are experiencing?

For issue #2, can you see if this post offers some help:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2834061&SiteID=1

Hope this helps,


Steve - www.platinumbay.com

Answer 2

Both were very helpful. Not sure why the interval did not make it in the upgrade, but it is working now. Also found that my tfs schedular service would fail on startup for some reason. I set the retry options for this and all is well.

 

Thanks for you help... this was really frustrating... now I am VERY happy with TFS 2008, which seems to have solved some bugs we were plauged with in TFS 2005. (Get Latest Version didn't always work reliably, etc.)

Answer 3

I am getting Error 1. plus some others. and following Issues are on our TFS server.

Event Type: Error
Event Source: TFS Warehouse
Event Category: None
Event ID: 3000
Date:  10/22/2009
Time:  4:33:19 PM
User:  N/A
Computer: TFS
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 10/22/2009 10:33:19 AM
Machine: TFS
Application Domain: /LM/W3SVC/1260976291/Root/Warehouse-5-129006345658877717
Assembly: Microsoft.TeamFoundation.Warehouse, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
  Process Name: w3wp
  Process Id: 4916
  Thread Id: 4512
  Account name: tfssetup

Detailed Message: Microsoft.TeamFoundation.VersionControl.Adapter: An unexpected exception occurred while calculating code churn: Calculating differences. Previous: changeset 9677, item $/A/SourceCode/a.aspx.cs, encoding 65001. Current: changeset 9705, item $/A/SourceCode/a.aspx.cs, encoding 65001. , exception:
Exception Message: The file exists.
 (type IOException)

1. Warehouse is not updating

2. Due to that this code churn error is reporting continueously in system, althoug we have installed service pack 1 of VS 2008 which include patches for this error
3. My task schuler is running and interval at web service is set to 3600.

4. I run synch process manually From webservice but nothing happened and error is still occuring.

5. This warning message is also there

Event Type: Warning
Event Source: TFS Services
Event Category: None
Event ID: 3050
Date:  10/22/2009
Time:  4:27:52 PM
User:  N/A
Computer: TFS
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 10/22/2009 10:27:52 AM
Machine: TFS
Application Domain: /LM/W3SVC/1260976291/Root/Services-2-129006310577940217
Assembly: Microsoft.TeamFoundation.Server, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
  Process Name: w3wp
  Process Id: 4916
  Thread Id: 2820
  Account name: MONDOISB\tfsservice

Detailed Message: TF200034: A subscriber to a Team Foundation event (subscription ID=553) raised the following exception:
Exception Message: Server was unable to process request. ---> Object reference not set to an instance of an object. (type SoapException)

Exception Stack Trace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.TeamFoundation.Server.NotificationClient.Notify(String eventXml, String tfsIdentityXml, SubscriptionInfo SubscriptionInfo)

---

Syed Naseer Ahmad, Software Engineer, Mondo Pakistan