Microsoft KB Archive/279553

Knowledge Base Articles

= BUG: Reliable Messaging with Message Queuing Under Stress Causes Deadlock =

ID: Q279553

Q279553

-

The information in this article applies to:


 * Microsoft BizTalk Server 2000

-

SYMPTOMS
When you are using Reliable Messaging with Message Queuing, you may receive the following error messages:

An error occurred in BizTalk Server.

Details:

--

The database call failed and returned the following error string: &quot;Transaction (Process ID 59) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.&quot;. If possible, we will attempt to retry this call.

The following stored procedure call failed: &quot;{ call cs_exist_DupRem( ?, ?, ?)}&quot;.

An error occurred in BizTalk Server.

Details:

--

The following stored procedure call failed: &quot;{ call cs_exist_DupRem( ?, ?, ?)}&quot;.

Unspecified error

Execution against the Shared Queue database has failed.

Suspended Queue ID: &quot;{3D008B25-40A2-4370-8F63-9A12CE3459AB}&quot;

Execution against the Shared Queue database has failed.

The database call failed and returned the following error string:

&quot;Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.&quot;. If possible, we will attempt to retry this call.

The following stored procedure call failed: &quot;{ call dta_log_inbound_details}&quot;.

An error occurred in BizTalk Server.

Details:

--

BizTalk Server failed to initialize a connection to database:

&quot;InterchangeBTM&quot; on server: &quot;MACHINENAME&quot;.

New transaction cannot enlist in the specified transaction coordinator.

0x8004d00a

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

An error occurred in BizTalk Server.

Details:

--

The following stored procedure call failed: &quot;{ call dta_log_inbound_details}&quot;.

Unspecified error

Changes could not be committed to the database.

An error occurred in BizTalk Server.

Details:

--

The database call failed and returned the following error string:

&quot;Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.&quot;. If possible, we will attempt to retry this call.

The following stored procedure call failed: &quot;{ call cs_create_SuspendedQ}&quot;.

An error occurred in BizTalk Server.

Details:

--

The following stored procedure call failed: &quot;{ call cs_create_SuspendedQ}&quot;.

Unspecified error

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

An error occurred in BizTalk Server.

Details:

--

The following stored procedure call failed: &quot;{call bts_oledb_aliases_getorgname(?, ?, ?)}&quot;.

Unspecified error

Unspecified error

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

An error occurred in BizTalk Server.

Details:

--

The database call failed and returned the following error string:

&quot;Transaction (Process ID 71) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.&quot;. If possible, we will attempt to retry this call.

The following stored procedure call failed: &quot;{ call cs_create_DupRem( ?, ?, ?)}&quot;.

CAUSE
When you are using Reliable Messaging with Message Queuing under heavy loads, the cs_DupRem table in the Shared Queue database becomes deadlocked, and this results in the errors listed in the &quot;Symptoms&quot;

RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2000. For additional information, please see the following article in the Microsoft Knowledge Base:

"Q299664 INFO: How to Obtain the Latest BizTalk Server 2000 Service Pack"

STATUS
This problem was first corrected in Microsoft BizTalk Server 2000 Service Pack 2.

Additional query words:

Keywords : kbDSupport

Issue type : kbbug

Technology : kbAudDeveloper kbBizTalkSearch kbBizTalkServ2000

Last Reviewed: February 28, 2002

-

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

© 2002 Microsoft Corporation. All rights reserved.