TF51541: The Node ID is not recognized.
You may notice the following error in the Work Item warehouse Sync and subsequently your full analysis sync and Incremental sync would also be failing.
Environment : TFS2015 instances where Update 2 RC is installed
Additional finding:
You will also notice this error post upgrade from RC to RTM 2015 update 2, in this case you would have tried rebuild of warehouse prior to 2015.2 RTM but not tried after installing update 2 RTM.
Error in warehouse processing:
Result Message: [Work Item Tracking Warehouse Sync]: ---> Microsoft.TeamFoundation.Warehouse.WarehouseException: TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team Foundation server TfsDefaultCollection. ---> Microsoft.TeamFoundation.WorkItemTracking.Server.Metadata.WorkItemTrackingTreeNodeNotFoundException: TF51541: The Node ID is not recognized: 0 at Microsoft.TeamFoundation.WorkItemTracking.Server.Metadata.WorkItemTrackingTreeService.<>c__DisplayClass18_0.<LegacyGetTreeNodes>b__0() at Microsoft.TeamFoundation.Framework.Server.VssRequestContextExtensions.TraceBlock[T](IVssRequestContext requestContext, Int32 enterTracepoint, Int32 leaveTracepoint, Int32 exceptionTracepoint, String area, String layer, String methodName, Func`1 action) at Microsoft.TeamFoundation.WorkItemTracking.Server.Metadata.WorkItemTrackingTreeService.LegacyGetTreeNodes(IVssRequestContext requestContext, IEnumerable`1 ids, Boolean includeDeleted) at Microsoft.TeamFoundation.WorkItemTracking.Server.History.TeamFoundationWorkItemHistoryService.ConvertWorkItemFieldValuesToFieldEntryDictionaries(IVssRequestContext requestContext, IEnumerable`1 workItemFieldValues, IEnumerable`1 fieldReferences) at Microsoft.TeamFoundation.WorkItemTracking.Server.History.TeamFoundationWorkItemHistoryService.<>c__DisplayClass3_0.<GetFieldValuesHistory>b__0(IEnumerable`1 fieldValues) at Microsoft.TeamFoundation.WorkItemTracking.Server.CommonWITUtils.<_BatchResponse>d__15`2.MoveNext() at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext() at Microsoft.TeamFoundation.WorkItemTracking.Server.Metadata.WorkItemTrackingTreeService.<>c__DisplayClass18_0.<LegacyGetTreeNodes>b__0() at Microsoft.TeamFoundation.Framework.Server.VssRequestContextExtensions.TraceBlock[T](IVssRequestContext requestContext, Int32 enterTracepoint, Int32 leaveTracepoint, Int32 exceptionTracepoint, String area, String layer, String methodName, Func`1 action) at Microsoft.TeamFoundation.WorkItemTracking.Server.Metadata.WorkItemTrackingTreeService.LegacyGetTreeNodes(IVssRequestContext requestContext, IEnumerable`1 ids, Boolean includeDeleted) at Microsoft.TeamFoundation.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.ProcessWorkItemRevisions(Int32 remainingIterations, Int32 workItemWatermark, Nullable`1 lastSyncedIdRevision, Int64 workItemFieldTimestamp, IEnumerable`1 idRevPairsToProcess, HashSet`1& measureFields, HashSet`1& dimOrDrillDownFields, HashSet`1& payloadFields, WarehouseMetadata allTpcWarehouseMetadata, Int32& watermarkProcessedTo) at Microsoft.TeamFoundation.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.SynchronizeNewWorkItems(WarehouseMetadata allTpcWarehouseMetadata) at Microsoft.TeamFoundation.WorkItemTracking.Adapter.WorkItemTrackingWarehouseAdapter.MakeDataChanges() at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.MakeDataChanges(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, String& resultMessage) at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.RunInternal(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage) at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage) --- End of inner exception stack trace
This issue is marked as a known issue. However, we need to validate whether you are hitting the same scenario/known issue. In order to do that please use the following select queries, and if you get any result data, please contact the Microsoft support using the support options provided at www.support.microsoft.com
Please run the below scripts on the failing TPC.
SELECT W.[Id], W.[AreaId], W.[AreaPath], W.[Iterationpath], W.[IterationId]
FROM dbo.tbl_WorkItemCoreLatest W with (NOLOCK)
LEFT JOIN dbo.tbl_ClassificationNode T with (NOLOCK)
ON T.Id = W.IterationId
AND T.PartitionId = W.PartitionId
WHERE T.Id IS NULL
and W.PartitionId > 0
SELECT W.[Id], W.[AreaId], W.[AreaPath], W.[Iterationpath], W.[IterationId]
FROM dbo.tbl_WorkItemCoreWere W with (NOLOCK)
LEFT JOIN dbo.tbl_ClassificationNode T with (NOLOCK)
ON T.Id = W.IterationId
AND T.PartitionId = W.PartitionId
WHERE T.Id IS NULL
and W.PartitionId > 0
SELECT W.[Id], W.[AreaId], W.[AreaPath]
FROM dbo.tbl_WorkItemCoreLatest W with (NOLOCK)
LEFT JOIN dbo.tbl_ClassificationNode T with (NOLOCK)
ON T.Id = W.AreaId
AND T.PartitionId = W.PartitionId
WHERE T.Id IS NULL
and W.PartitionId > 0
SELECT W.[Id], W.[AreaId], W.[AreaPath]
FROM dbo.tbl_WorkItemCoreWere W with (NOLOCK)
LEFT JOIN dbo.tbl_ClassificationNode T with (NOLOCK)
ON T.Id = W.AreaId
AND T.PartitionId = W.PartitionId
WHERE T.Id IS NULL
and W.PartitionId > 0
SELECT * FROM tbl_ClassificationNode where Id = 0
SELECT * FROM vw_WorkItemCoreAll where AreaId = 0
Content: Vimal Thiagaraj