The BizTalk Server Document Tracking Feature

Center Document Tracking Feature

The BizTalk Document Tracking feature is used to track BizTalk Server document processing. Through the Document Tracking feature, you can track documents, track specific fields of the documents, and determine the state of BizTalk Server document processing.

All tracking data is stored in a SQL Server database. BizTalk Server stores information associated with the document. You can specify which information should be tracked and stored. Members of the BizTalk Server Report Users group can use Document Tracking.

The Tracking database collects metadata on documents when document tracking is enabled. This includes the following:

• Source organization
• Destination organization
• Document type
• Date and time the interchange was processed
• Document count
• Error information
• Control ID

You can specify all other fields that should be tracked. When you configure document tracking, you can specify document tracking:

• Locally; includes only specific documents or interchanges.
• Globally; includes all documents and interchanges.

When you configure document tracking globally, you can specify the BizTalk Server group to track the following:

• Incoming messages
• Outgoing messages
• Original MIME-encoded messages

A few advantages of using the BizTalk Document Tracking feature are summarized below:

• You can easily track an exchanged document.
• Documents and interchanges are tracked as they are being processed within your BizTalk Server system.
• Copies of all electronic business transactions are maintained.
• Tracking can be used as proof that a document was sent.
• You can use tracking information for troubleshooting purposes.

Understanding the Tracking Database

When BizTalk Server sends a document, or a document is submitted to the BizTalk Server, the information within the Tracking database is updated.

The Tracking database is made up of 23 tables that are sorted into the following categories:

• Core tables; contain the important information on core activities
• Secondary tables; contain any additional information in the database.
• Supporting tables; contain supporting information.

The core tables of the Tracking database are listed here:

• dta_indoc_details table; contains metadata on submitted documents, sent to the BizTalk Server by trading partners or applications. A row in the dta_indoc_details table represents one document or interchange.
• dta_outdoc_details table; contains metadata sent by BizTalk Server. A row in the dta_outdoc_details table represents a single BizTalk Server generated document.
• dta_interchange_details table; contains metadata about interchanges. This includes interchanges sent by the BizTalk Server or submitted to it. A row in the dta_interchange_details table represents a single interchange.

Receipt information, also called the acknowledgement status, is tracked in these tables:

• dta_outdoc_details table
• dta_indoc_details table

An acknowledgement status can have either of these values

• 0 – None; a receipt is not expected
• 1 – Pending; a receipt is expected
• 2 – Overdue; a receipt is late
• 3 – Accepted; a receipt turned up as expected, with no errors and on time
• 4 – Accepted with errors; a receipt turned up as expected and with errors
• 5 – Rejected; a receipt was rejected

How to add a user to the BizTalk Server Report Users group

1. Open Local Users and Groups.
2. Click Users.
3. Double-click BizTalk Server Report Users.
4. The BizTalk Server Report Users Properties dialog box opens.
5. Click the Members tab.
6. Click Add.
7. The Select Users, Contacts, computers, Or Groups dialog box opens.
8. Add the user and then click Check Names.
9. Click OK in the Select Users, Contacts, Computers, Or Groups dialog box.
10. Click OK in the BizTalk Server Report Users Properties dialog box.

How to configure document tracking for the BizTalk Server group

• Open the BizTalk Server Administration console.
• Expand Microsoft BizTalk Server 2000.
• Select the server group that you want to configure document tracking for.
• Click the Action menu and then select Properties.
• The BizTalk Server Group Properties dialog box opens.
• Click the Tracking tab.
• Select the Enable Document Tracking checkbox.
• Select the Log Incoming Interchange checkbox.
• Select the Log Outgoing Interchange checkbox.
• Select the Log The Original MIME-Encoded message checkbox.
• Click OK.

How to turn off document tracking

• Open the BizTalk Server Administration console.
• Expand Microsoft BizTalk Server 2000.
• Right-click the server group for which you want to disable the document tracking feature and then select Properties from the shortcut menu.
• Click the Tracking tab.
• Uncheck the Enable Document Tracking checkbox.
• Click Yes to verify that you want to disable document tracking.
• Click OK.