Team Foundation Server Issue Work Items not synching to warehouse - TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team
Keywords 0x80000000000000 [ SystemTime] 2013-04-11T10:55:09.000000000Z TF53010: The following error has occurred in a Team Foundation component or extension: Date (UTC): 4/11/2013 10:55:09 AM Machine: DEVTFSAPP Application Domain: TfsJobAgent.exe Assembly: Microsoft.TeamFoundation.Framework.Server, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v4.0.30319 Service Host: Process Details: Process Name: TFSJobAgent Process Id: 640764 Thread Id: 640784 Account name: domain\acct Detailed Message: TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team Foundation server DefaultCollection. Exception Message: Conversion failed when converting the nvarchar value 'Business Request' to data type int. Cannot find the object "#workingSet" because it does not exist or you do not have permissions. (type SqlException) SQL Exception Class: 16 SQL Exception Number: 50000 SQL Exception Procedure: prc_Dimension_DimWorkItem_AddUpdate SQL Exception Line Number: 134 SQL Exception Server: DEVTFSSQL Exception State: 1 SQL Error(s): SQL Error[1]: System.Data.SqlClient.SqlError: Cannot find the object "#workingSet" because it does not exist or you do not have permissions. Class: 16 Number: 1088 Server: DEVTFSSQL Source: .Net SqlClient Data Provider State: 12 Procedure: prc_Dimension_DimWorkItem_AddUpdate Line Number: 137 Exception Data Dictionary: HelpLink.ProdName = Microsoft SQL Server HelpLink.ProdVer = 11.00.2100 HelpLink.EvtSrc = MSSQLServer HelpLink.EvtID = 50000 HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink HelpLink.LinkId = 20476 Exception Stack Trace: at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(Exception exception) 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.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.GetWorkItemRevisionBatchAndPopulate(String workItemRevisionWatermark, IdRevisionPair[] pairs, String workItemFieldWatermark, Int32 workItemRevisionBatchSize, WarehouseMetadata allTpcWarehouseMetadata, String& dimensionFieldQueryList, String& measureFieldQueryList, String& maxRevisionWatermark) at Microsoft.TeamFoundation.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.SynchronizeNewWorkItems(WarehouseMetadata allTpcWarehouseMetadata) at Microsoft.TeamFoundation.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.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)
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment