PRB: Incomplete Records Remain When You Clear the Document Tracking Database (328553)
The information in this article applies to:
- Microsoft BizTalk Server 2000 SP1a
- Microsoft BizTalk Server 2002
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.
STATUSThis 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.
| Modification Type: | Major | Last Reviewed: | 5/23/2003 |
|---|
| Keywords: | kbfix kbprb KB328553 |
|---|
|