Microsoft KB Archive/312658

= PRB: Large Documents Are Not Processed When You Have Document Tracking Turned On =

Article ID: 312658

Article Last Modified on 4/26/2002

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-



This article was previously published under Q312658



SYMPTOMS
When you submit a document that is larger than 20 MB to BizTalk Server for processing and you have turned on document tracking, an error that is similar to the following is generated in the Application log of the BizTalk Server:

Event Type: Error Event Source:  BizTalk Server Event Category: Document Processing Event ID:           324 Date:      4/5/2002 Time:      10:02:15 PM User:       N/A Computer:           BIZTALKSERVER Description: An error occurred in BizTalk Server. Details: -- [0x80040e14] The following stored procedure call failed: &quot; { call dta_log_outbound_details( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}&quot;. :'Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.' [0x1625] Changes could not be committed to the database.

[0x80040e14] The following stored procedure call failed: &quot; { call cs_create_SuspendedQ_from_WorkQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}&quot;. :'Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.' [0x011e] A new work item in the Suspended queue cannot be created.



CAUSE
This error can occur if the time to write document tracking information to the BizTalk Server Tracking database for a document exceeds the Distributed Transaction Controller (DTC) timeout value that is used for submitting documents to BizTalk Server 2002 for processing. By default, this value is set to one hour. If document tracking for a particular document cannot be completed in one hour, the transaction aborts, an error message is logged, and the document is moved to the BizTalk Server Suspended queue.



RESOLUTION
If you plan to receive interchanges in XML Unicode format that are larger than 20 MB, Microsoft recommends that you turn off global tracking settings. If you plan to receive ANSI flat-file interchanges that are larger than 7 MB to 10 MB, Microsoft recommends that you turn off tracking of the interchange body and document body, and that you turn off document logging in the channel configurations.

If you plan to receive document instances in XML Unicode format that are larger than 20 MB, Microsoft recommends that you turn off document logging settings in BizTalk Messaging Manager. Or, if you plan to receive ANSI flat files that are larger than 7 MB to 10 MB, Microsoft recommends that you turn off document logging settings in BizTalk Messaging Manager.



STATUS
This behavior is by design.

