{"id":59168,"date":"2020-06-08T06:40:07","date_gmt":"2020-06-08T14:40:07","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/devops\/?p=59168"},"modified":"2020-06-08T06:41:37","modified_gmt":"2020-06-08T14:41:37","slug":"tf221122-an-error-occurred-running-job-work-item-tracking-warehouse-sync","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/tf221122-an-error-occurred-running-job-work-item-tracking-warehouse-sync\/","title":{"rendered":"TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection"},"content":{"rendered":"<p>When running Azure DevOps Server, or previous versions for TFS, you may come across this error&#8230;<\/p>\n<blockquote>\n<p>TF53010: The following error has occurred in a Team Foundation component or extension:<\/p>\n<p>Detailed Message: TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team Foundation server TPC01.<\/p>\n<p>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)<\/p>\n<p>SQL Exception Class: 16<br \/>\n  SQL Exception Number: 1000002<br \/>\n  SQL Exception Procedure: prc_Fact_FactWorkItem_AddUpdate<br \/>\n  SQL Exception Line Number: 193<br \/>\n  SQL Exception Server: XXXXXXX<br \/>\n  SQL Exception State: 1<\/p>\n<\/blockquote>\n<p>This issue has been resolved with two separate security fixes. Depending on your current version, you will need to upgrade to either <a href=\"https:\/\/docs.microsoft.com\/en-us\/visualstudio\/releasenotes\/tfs2018-update3\">2018 Update 3.2<\/a> or <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/devops\/server\/release-notes\/azuredevops2019u1?view=azure-devops-2019\">2019 Update 1<\/a><\/p>\n<h3>Azure DevOps Server 2019.1.1 Patch 1<\/h3>\n<p>If you are running Azure DevOps Server 2019 Update 1.1, you should install <a href=\"https:\/\/aka.ms\/azdev2019.1patch\">Azure DevOps Server 2019 Update 1.1 Patch 1<\/a>.<\/p>\n<h4>Verifying Installation<\/h4>\n<ul>\n<li>\n<p><strong>Option 1:<\/strong> Run <code>devops2019.1.1patch1.exe CheckInstall<\/code>, 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.<\/p>\n<\/li>\n<li>\n<p><strong>Option 2:<\/strong> Check the version of the following file: <code>[INSTALL_DIR]\\Azure DevOps Server 2019\\Application Tier\\Web Services\\bin\\Microsoft.VisualStudio.Services.Feed.Server.dll<\/code>. Azure DevOps Server 2019 is installed to <code>c:\\Program Files\\Azure DevOps Server 2019<\/code> by default. After installing Azure DevOps Server 2019.1.1 Patch 1, the version will be 17.153.29904.2.<\/p>\n<\/li>\n<\/ul>\n<h3>TFS 2018 Update 3.2 Patch 9<\/h3>\n<p>If you have TFS 2018 Update 2 or Update 3, you should first update to <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=2008534\">TFS 2018 Update 3.2<\/a>. Once on Update 3.2, install <a href=\"https:\/\/aka.ms\/tfs2018.3.2patch\">TFS 2018 Update 3.2 Patch 9<\/a>.<\/p>\n<h4>Verifying Installation<\/h4>\n<ul>\n<li>\n<p><strong>Option 1:<\/strong> Run <code>tfs2018.3.2patch9.exe CheckInstall<\/code>, 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.<\/p>\n<\/li>\n<li>\n<p><strong>Option 2:<\/strong> Check the version of the following file: <code>[TFS_INSTALL_DIR]\\Application Tier\\Web Services\\bin\\Microsoft.TeamFoundation.WorkItemTracking.Web.dll<\/code>. TFS 2018 is installed to <code>\\`c:\\Program Files\\Microsoft Team Foundation Server 2018<\/code> by default. After installing TFS 2018 Update 3.2 Patch 9, the version will be 16.131.29825.3.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>When running Azure DevOps Server, or previous versions for TFS, you may come across this error&#8230; 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 [&hellip;]<\/p>\n","protected":false},"author":921,"featured_media":54061,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[253,230],"tags":[],"class_list":["post-59168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-devops-server","category-directions"],"acf":[],"blog_post_summary":"<p>When running Azure DevOps Server, or previous versions for TFS, you may come across this error&#8230; 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 [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/59168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/921"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=59168"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/59168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/54061"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=59168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=59168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=59168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}