Microsoft KB Archive/328553

= PRB: Incomplete Records Remain When You Clear the Document Tracking Database =

Article ID: 328553

Article Last Modified on 5/23/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Service Pack 1a
 * Microsoft BizTalk Server 2002 Standard Edition

-



This article was previously published under Q328553



SYMPTOMS
The dta_purge_old_records stored procedure in BizTalk Server may delete the inbound document for an interchange and still leave the outbound document in the database. This causes the nInDocKey field in the dta_outdoc_details table to point to records that do not exist in the dta_indoc_details table.

BizTalk Server does not display outbound documents in the document tracking user interface (UI) if there is no matching inbound document.

NOTE: If an inbound document does not yet have a matching outbound document, the inbound document does appear in the document tracking UI.



CAUSE
The dta_purge_old_records stored procedure deletes records from the database based on the age of the record or the number of records to leave behind. The dta_purge_old_records stored procedure cannot verify that all matching outbound documents are also deleted.

You see this behavior most clearly when there is a noticeable delay between inbound and outbound documents, such as when a messaging port has a service window.



RESOLUTION
If you use the stored procedure to archive records (instead of only to delete records), eventually, when the outbound documents are archived, all records will again match up in the archive database.



STATUS
This behavior is by design.



MORE INFORMATION
The document tracking database is designed to be a standalone database. From the document tracking database, there is no way to verify that all outbound documents have been sent for an inbound document.

An inbound document may have multiple outbound documents if the channel uses a distribution list to multiple messaging ports. If a messaging port has a service window associated with it, there may be a long delay between the inbound documents and the outbound documents.

Keywords: kbfix kbprb KB328553

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.