Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: Orphaned rows in Tracking_Parts1 and Tracking_Fragments1 tables when you use DTA Purge and Archive job

FIX: Orphaned rows in Tracking_Parts1 and Tracking_Fragments1 tables when you use DTA Purge and Archive job

View products that this article applies to.

Symptoms

After you run the DTA Purge and Archive SQL Server Agent job in Microsoft BizTalk Server, orphaned rows appear in Tracking_Parts1 and Tracking_Fragments1 tables.

↑ Back to the top

Cause

This issue occurs because the SQL join in corresponding job failed to identify all the rows to be removed.

↑ Back to the top

Resolution

Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

For more information about the service packs and cumulative update list for BizTalk Server, see KB 2555976: Service pack and cumulative update list for BizTalk Server .

For more information about BizTalk Server hotfixes, see KB 2003907: Information about BizTalk hotfixes and cumulative update support .

↑ Back to the top

Keywords: kb, kbqfe, kbfix, kbsurveynew, kbexpertiseadvanced

↑ Back to the top

Article Info
Article ID : 3050958
Revision : 1
Created on : 1/7/2017
Published on : 12/31/2015
Exists online : False
Views : 436