Microsoft KB Archive/275847

= Deadlock Issues Occur When You Update a Channel When a Server Is Under Stress =

Article ID: 275847

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Standard Edition

-



This article was previously published under Q275847



SYMPTOMS
When you edit a channel, you may experience deadlock issues with BizTalk Server while the server is under stress. The following errors may be logged to the event log:

An error occurred in BizTalk Server.

Details:

--

The database call failed and returned the following error string: &quot;Transaction (Process ID 118) 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 bts_oledb_outputconfigs_load(?, ?, ?, ?, ?, ?)}&quot;.

An error occurred in BizTalk Server.

Details:

--

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

Unspecified error

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_outbound_details( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}&quot;.

An error occurred in BizTalk Server.

Details:

--

The following stored procedure call failed: &quot;{ call dta_log_outbound_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_from_ScheduledQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}&quot;.

An error occurred in BizTalk Server.

Details:

--

The root transaction wanted to commit, but transaction aborted



RESOLUTION
Disable the Receive function that is associated with channel being edited. When the modifications are complete, re-enable this Receive function.



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

Keywords: kbbug kbpending KB275847

-

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

© Microsoft Corporation. All rights reserved.