TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection

This post has been republished via RSS; it originally appeared at: Microsoft Developer Blogs.

When running Azure DevOps Server, or previous versions for TFS, you may come across this error... TF53010: The following error has occurred in a Team Foundation component or extension: Detailed Message: TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team Foundation server TPC01. Exception Message: Cannot create compensating record. Missing historic data. Predecessor of work item(s) 1944917|7|7d5ffdd2-ea37-4335-9111-c3601c20096c not found. (type SqlException) SQL Exception Class: 16 SQL Exception Number: 1000002 SQL Exception Procedure: prc_Fact_FactWorkItem_AddUpdate SQL Exception Line Number: 193 SQL Exception Server: XXXXXXX SQL Exception State: 1 This issue has been resolved with two separate security fixes. Depending on your current version, you will need to upgrade to either 2018 Update 3.2 or 2019 Update 1 Azure DevOps Server 2019.1.1 Patch 1 If you are running Azure DevOps Server 2019 Update 1.1, you should install Azure DevOps Server 2019 Update 1.1 Patch 1. Verifying Installation Option 1: Run devops2019.1.1patch1.exe CheckInstall, devops2019.1.1patch1.exe is the file that is downloaded from the link above. The output of the command will either say that the patch has been installed, or that is not installed. Option 2: Check the version of the following file: [INSTALL_DIR]\Azure DevOps Server 2019\Application Tier\Web Services\bin\Microsoft.VisualStudio.Services.Feed.Server.dll. Azure DevOps Server 2019 is installed to c:\Program Files\Azure DevOps Server 2019 by default. After installing Azure DevOps Server 2019.1.1 Patch 1, the version will be 17.153.29904.2. TFS 2018 Update 3.2 Patch 9 If you have TFS 2018 Update 2 or Update 3, you should first update to TFS 2018 Update 3.2. Once on Update 3.2, install TFS 2018 Update 3.2 Patch 9. Verifying Installation Option 1: Run tfs2018.3.2patch9.exe CheckInstall, tfs2018.3.2patch9.exe is the file that is downloaded from the link above. The output of the command will either say that the patch has been installed, or that is not installed. Option 2: Check the version of the following file: [TFS_INSTALL_DIR]\Application Tier\Web Services\bin\Microsoft.TeamFoundation.WorkItemTracking.Web.dll. TFS 2018 is installed to \`c:\Program Files\Microsoft Team Foundation Server 2018 by default. After installing TFS 2018 Update 3.2 Patch 9, the version will be 16.131.29825.3.