![删除 TFS 项目集合 - SqlException](https://linux22.com/image/629850/%E5%88%A0%E9%99%A4%20TFS%20%E9%A1%B9%E7%9B%AE%E9%9B%86%E5%90%88%20-%20SqlException.png)
我正在尝试删除 TFS 2010 中的团队项目集合。不幸的是,在处理了一些旧实例(其中一些甚至不再有数据库)之后,即使在尝试删除全新实例时也出现错误。
我完成了分离过程并在报告部分收到错误:
[2014-03-28 15:12:50Z][错误] 对象名称“dbo.DimTeamProject”无效。
我该如何删除收藏集?
以下是部分日志:
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Step Data Text:
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Retrieving target request context.
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Target request context has framework connection string: Data Source=FS-01\TFSSQL2008;Initial Catalog=Tfs_DeleteMe;Integrated Security=True.
[Info @15:14:39.993] [2014-03-28 15:12:50Z] Servicing step Copy identities to collection database passed. (ServicingOperation: Snapshot; Step group: Snapshot.TfsIdentities)
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Retrieving target request context.
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Target request context has framework connection string: Data Source=FS-01\TFSSQL2008;Initial Catalog=Tfs_DeleteMe;Integrated Security=True.
[Info @15:14:39.993] [2014-03-28 15:12:50Z] Executing servicing step Prepare Build for a detach operation. (ServicingOperation: Delete; Step group: Delete.TfsBuild)
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Step Performer: Build
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Step Type: OnDetach
[Info @15:14:39.993] [2014-03-28 15:12:50Z][Informational] Step Data Text:
[Info @15:14:39.993] [2014-03-28 15:12:50Z] Servicing step Prepare Build for a detach operation passed. (ServicingOperation: Delete; Step group: Delete.TfsBuild)
[Info @15:14:39.994] [2014-03-28 15:12:50Z] Executing servicing step Mark Collection as Deleted in Warehouse. (ServicingOperation: Delete; Step group: Delete.TfsWarehouse)
[Info @15:14:39.994] [2014-03-28 15:12:50Z][Informational] Step Performer: WarehouseCollection
[Info @15:14:39.994] [2014-03-28 15:12:50Z][Informational] Step Type: MarkCollectionDeleted
[Info @15:14:39.994] [2014-03-28 15:12:50Z][Informational] Step Data Text:
[Error @15:14:39.994] [2014-03-28 15:12:50Z][Error] Invalid object name 'dbo.DimTeamProject'.
[Info @15:14:39.994] [2014-03-28 15:12:50Z][Informational] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DimTeamProject'.
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteNonQuery(Boolean bindReturnValue)
at Microsoft.TeamFoundation.Warehouse.WarehouseBatchedDataAccessComponent.ExecuteNonQuery()
at Microsoft.TeamFoundation.Warehouse.CommonStructureWarehouseAdapter.MarkCollectionDeleted(TeamFoundationRequestContext requestContext, Guid collectionId)
at Microsoft.TeamFoundation.Server.Servicing.TFCollection.WarehouseStepPerformer.MarkCollectionDeleted(String stepData, ServicingContext servicingContext, Boolean validateOnly)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext)
at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly)
[Info @15:14:39.994] [2014-03-28 15:12:50Z] Servicing step Mark Collection as Deleted in Warehouse failed. (ServicingOperation: Delete; Step group: Delete.TfsWarehouse)
[Info @15:14:39.994] [2014-03-28 15:12:50Z][Informational] Clearing dictionary, removing all items.
[Error @15:14:39.994] The servicing operation failed.