FIX: Orphaned DTA service instances are generated by the backup transport in BizTalk Server 2006 R2

Consider the following scenario:

• You are using a computer that is running Microsoft BizTalk Server 2006 R2.
• You configure backup transport options for a send port.
• The primary transport does not process an incoming message. Then, the backup transport�process the message correctly.

In this scenario, an orphaned BizTalk DTA service instance is created in the BizTalk Tracking (BizTalkDTADb) database unexpectedly. This orphaned BizTalk DTA service instance is never removed by the DTA Purge and Archive job. Therefore, after the BizTalk orchestration runs for some time, the BizTalkDTADb database becomes very large.

Note An orphaned DTA service instance has a record in the dta_ServiceInstances table of the BizTalkDTADb database. The dtEndTime field in this record contains a NULL value. However, the service instance has no corresponding record in the MessageBox database. Therefore, the dtEndTime field is never populated, and the DTA Purge and Archive job never removes the orphaned BizTalk DTA service instance.

The hotfix that resolves this problem is included in cumulative update package 2 for BizTalk Server 2006 R2 Service Pack 1.

�For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

2211420� Cumulative update package 2 for BizTalk Server 2006 R2 Service Pack 1

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

How to Configure Backup Transport Options for a Send Port

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

For more information about the list of Microsoft BizTalk Server hot fixes that are included in BizTalk Server 2006 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base: