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

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.
Properties

Article ID: 3050958 - Last Review: 12/31/2015 17:34:00 - Revision: 3.0

Microsoft BizTalk Server Branch 2010, Microsoft BizTalk Server Developer 2010, Microsoft BizTalk Server Enterprise 2010, Microsoft BizTalk Server Standard 2010, Microsoft BizTalk Server 2013 Branch, Microsoft BizTalk Server 2013 Developer, Microsoft BizTalk Server 2013 Enterprise, Microsoft BizTalk Server 2013 Standard

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3050958
Feedback