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: "Transaction (Process ID 118) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". If possible, we will attempt to retry this call.
The following stored procedure call failed: "{call bts_oledb_outputconfigs_load(?, ?, ?, ?, ?, ?)}".
An error occurred in BizTalk Server.
Details:
------------------------------
The following stored procedure call failed: "{call bts_oledb_outputconfigs_load(?, ?, ?, ?, ?, ?)}".
Unspecified error
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 dta_log_outbound_details( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".
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.
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_ScheduledQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}".
An error occurred in BizTalk Server.
Details:
------------------------------
The root transaction wanted to commit, but transaction aborted