I'm trying to delete a team project collection in TFS 2010. Unfortunately after struggling with some old instances (some that don't even have databases anymore) I get an error even when attempting to delete a brand new instance.
I go through the detatch process and get an error during the reporting section:
[2014-03-28 15:12:50Z][Error] Invalid object name 'dbo.DimTeamProject'.
How can I go about deleting collections?
Below is some of the log:
[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.
User contributions licensed under CC BY-SA 3.0