Microsoft KB Archive Search

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.

  1. Home
  2. FIX: Some data is not purged from the EDIMessageContent table in BizTalk Server 2009

FIX: Some data is not purged from the EDIMessageContent table in BizTalk Server 2009

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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

↑ 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

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 reporting
For 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 Server
For 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

↑ Back to the top

Keywords: kb, kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew, kbbiztalk2009presp1fix, kbbtsadapters

↑ Back to the top

Article Info
Article ID : 2662534
Revision : 1
Created on : 1/7/2017
Published on : 1/20/2012
Exists online : False
Views : 254