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

Artikel-id: 3050958 - Laatst bijgewerkt: 31 dec. 2015 - Revisie: 1

Feedback