Symptoms
When you use Microsoft Visual Studio Team Foundation Server (TFS) 2010 Service Pack 1 (SP1), the Test Management Warehouse Sync job times out intermittently. Additionally, the data warehouse is not generated as expected.
In this situation, the following exception is triggered:
Note
TF221122: An error occurred running job Test Management Warehouse Sync for team project collection or Team Foundation server DefaultCollection. ---> System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Dispose() at Microsoft.TeamFoundation.Warehouse.WarehouseDataAccessComponent.Dispose() at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObjects(Boolean deleteResults) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessDeletes() at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.MakeDataChanges() at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.MakeDataChanges(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, String& resultMessage) at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.RunInternal(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage) at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage)
Cause
This issue occurs because of a design error in the Test Management Warehouse Sync job. This error can manifest when the job processes a large amount of deleted test data.
Resolution
Hotfix information
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.
To resolve this problem, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft website:
http://support.microsoft.com/contactus/?ws=support Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
Prerequisites
To apply this hotfix, you must have Visual Studio TFS 2010 SP1 installed.
Restart requirement
If the affected files are being used when you apply this hotfix, you may have to restart the computer. We recommend that you exit all instances of Visual Studio before you apply this hotfix.
File information
The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For all supported versions of Visual Studio TFS 2010 SP1
| File name | File version | File size | Date | Time | Platform |
|---|---|---|---|---|---|
| Microsoft.teamfoundation.admin.dll | 10.0.40219.363 | 24,725,816 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.build.server.plugins.dll | 10.0.40219.363 | 46,424 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.framework.server.dll | 10.0.40219.363 | 1,100,624 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.server.deploy.tfcollection.dll | 10.0.40219.363 | 562,536 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.server.dll | 10.0.40219.363 | 222,008 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.testmanagement.adapter.dll | 10.0.40219.363 | 93,024 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.versioncontrol.server.dll | 10.0.40219.363 | 615,776 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.versioncontrol.server.plugins.dll | 10.0.40219.363 | 26,992 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.versioncontrol.server.proxy.dll | 10.0.40219.363 | 90,472 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.warehouse.dll | 10.0.40219.363 | 3,524,416 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.workitemtracking.server.dataaccesslayer.dll | 10.0.40219.363 | 590,208 | 16-Nov-11 | 13:19 | x86 |
| Microsoft.teamfoundation.workitemtracking.server.dataservices.dll | 10.0.40219.363 | 143,744 | 16-Nov-11 | 13:19 | x86 |
More Information
For more information about the components of the data warehouse for Team Foundation, visit the following MSDN website:
General information about the components of the data warehouse for Team Foundation For more information about how to manually process the data warehouse and the Microsoft SQL Server Analysis Services cube for TFS, visit the following MSDN website:
How to manually process the data warehouse and the SQL Server Analysis Services cube for TFS
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.