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.
Cause
This issue occurs because the SQL join in corresponding job failed to identify all the rows to be removed.
Resolution
Cumulative update information
This issue was first fixed in the following cumulative update of BizTalk Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.