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

Applies to: BizTalk Server Branch 2010BizTalk Server Developer 2010BizTalk Server Enterprise 2010

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 .