Submit Fails for Large Interchanges (277973)



The information in this article applies to:

  • Microsoft BizTalk Server 2000

This article was previously published under Q277973

SYMPTOMS

When you submit a large interchange, you may receive one or more of the following error messages:
An error occurred in BizTalk Server.

Details:
------------------------------
The database call failed and returned the following error string: "String data, length mismatch". If possible, we will attempt to retry this call.

The following stored procedure call failed: "{ call dta_log_outbound_details( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".
-or-

An error occurred in BizTalk Server.

Details:
------------------------------
The server is shutting down because of a database failure.
-or-

An error occurred in BizTalk Server.

Details:
------------------------------
The following stored procedure call failed: "{ call dta_log_outbound_details( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".

Unspecified error

Changes could not be committed to the database.
-or-

An error occurred in BizTalk Server.

Details:
------------------------------
The database call failed and returned the following error string:
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.". If possible, we will attempt to retry this call.

The following stored procedure call failed: "{ call cs_create_SuspendedQ_from_WorkQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".
-or-

An error occurred in BizTalk Server.

Details:
------------------------------
The root transaction wanted to commit, but transaction aborted.
-or-

An error occurred in BizTalk Server.

Details:
------------------------------
The following stored procedure call failed: "{ call cs_create_SuspendedQ_from_WorkQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".

Unspecified error

A new work item in the Suspended queue cannot be created.

CAUSE

The size of the interchange is too large.

RESOLUTION

For more information on large interchanges and the supported size of interchanges, review the following section in the online documentation:

BizTalk Server 2000 Administration\Administering Servers and Applications\Server Administration\Troubleshooting BizTalk Server Administration\Interchange and Document Size Limit

Fro more information on tracking options, review the "Understanding Tracking Settings for a Server Group" and "Understanding Tracking Settings in BizTalk Messaging Manager" sections.

STATUS

Microsoft has confirmed that this is a problem in Microsoft BizTalk Server 2000.

MORE INFORMATION

If Document Tracking Activity is enabled, performance is reduced.

Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbpending kbprb KB277973