June 8th, 2020

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

Dan Hellem
Program Manager

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.

Author

Dan Hellem
Program Manager

Dan is a Program Manager with Microsoft's Azure DevOps

1 comment

Discussion is closed. Login to edit/delete existing comments.

  • Daniel Steiner

    I’m not amused that critical comments just get removed.

    Dan,
    why do you recommend old patches from April when they’d already been replaced by newer ones from May. and even most recent from June?