Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: The BizTalkDTADb database becomes very large after a BizTalk orchestration runs for a while in BizTalk Server 2009 if an exception is caught


View products that this article applies to.

Symptoms

Consider the following scenario:
  • You install Microsoft BizTalk Server 2009 on a computer.
  • You run two BizTalk orchestrations that meet the following conditions.
    • One orchestration has a Receive shape, has all tracking options disabled, and calls the other orchestration to process messages.
    • The called orchestration has the Orchestration start and end check box selected.
    • One of these orchestrations has a catch exception block. 
  • An exception occurs in the called orchestration.

    Note This exception is caught and handled by the catch exception block. Therefore, the message processing operation finishes.
  • The BizTalk orchestration tries to processes other messages.
In this scenario, the BizTalkDTADb database becomes very large after the BizTalk orchestration runs for a while.

For example, you run two orchestrations that are named A and B and that meet the following requirements:
  • On the Tracking tab of the orchestration properties dialog box for A, all Track Events check boxes are cleared.
  • The Orchestration start and end check box for B is selected.
  • A processes messages by calling B.
  • Exceptions occur and are handled by a Catch Exception block.
In this scenario, the BizTalkDTADb database becomes very large after a while.

↑ Back to the top


Cause

This issue occurs because an orphaned instance is incorrectly created in the BizTalkDTADb database.

When an orphaned instance is incorrectly created in the BizTalkDTADb database, the service instance has no corresponding record in the BizTalkMsgBoxDb database. Additionally, the dtEndTime field of the dta_ServiceInstances table is never populated in the BizTalkDTADb database. Therefore, the DTA Purge and Archive job does not remove the orphaned instance. After the BizTalk orchestrations runs for a while, and the BizTalkDTADb database becomes very large.

↑ Back to the top


Resolution

Cumulative update information

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:
2429050 Cumulative update package 1 for BizTalk 2009

Note KB978796 resolves a similar issue. However, this issue can still occur even if you have installed the hotfix in KB978796.

For more information about the hotfix in KB978796, click the following article number to view the article in the Microsoft Knowledge Base:
978796 FIX: An orphaned BizTalk DTA service instance is created unexpectedly after a BizTalk orchestration handles an exception


↑ Back to the top


Status

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

↑ Back to the top


More Information

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


↑ Back to the top


Keywords: kb, kbqfe, kbfix, kbbiztalk2009presp1fix, kbexpertiseadvanced, kbsurveynew, kbbtsorchestration, kbhotfixserver

↑ Back to the top

Article Info
Article ID : 2263355
Revision : 1
Created on : 1/7/2017
Published on : 2/10/2011
Exists online : False
Views : 376