Symptoms

In Microsoft BizTalk Server 2009, some data in the EDIMessageContent table of the BizTalk Tracking (BizTalkDTADb) database is not purged when the DTA Purge and Archive SQL Server Agent job runs.

When this issue occurs, the EDIMessageContent table grows very large over time. This may reduce the performance of BizTalk Server.

Note This issue may occur when you have the Activate EDI reporting property and the Store transaction set/payload for reporting property selected in the Electronic Data Interchange (EDI) properties of a party.

Cause

This issue occurs because the IsReliableMessagingEntry column is set to 1 incorrectly for some rows in the EDIMessageContent table. Because this value does not change over time, the data in these rows is not purged by the DTA Purge and Archive SQL Server Agent job.

Resolution

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 5 for BizTalk Server 2009.

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

2649852 Cumulative update package 5 for BizTalk Server 2009

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 configuration of EDI and AS2 status reporting, visit the following MSDN website:

General information about configuration of EDI and AS2 status reportingFor more information about Business Activity Monitoring (BAM) activities that are created to track EDI and AS2 messages, visit the following MSDN website:

General information about BAM activities that are created to track EDI and AS2 messages For more information about service packs and cumulative update packages for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base: 

2555976 Service Pack and Cumulative Update list for BizTalk ServerFor more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

2003907 Information on BizTalk Server hotfixes

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×