bts_UpdateMsgbox_Send_MSMQ]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,   

Hi,

We have a simple pub/sub solution. One receiveport/location and 5 sendports. 
Incoming message is routed to all sendports.
Body tracking is enabled on the sendports.
When sending one message it works fine, but when sending 50, the error below 
occurs.

If body tracking is disabled there are no errors.


The following stored procedure call failed: " { call 
[dbo].[bts_UpdateMsgbox_Send_MSMQ]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Transaction 
(Process ID 84) was deadlocked on lock resources with another process and has 
been chosen as the deadlock victim. Rerun the transaction.;Duplicate key was 
ignored.". 

Any idea what to do about this?

Regards,
/Daniel

date: Tue, 17 Jun 2008 14:13:19 -0700   author:   DW am

RE: bts_UpdateMsgbox_Send_MSMQ]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,   

By the way. 
It´s a BizTalk 2006 r2 Enterprise

/Daniel

"DW" wrote:

> Hi,
> 
> We have a simple pub/sub solution. One receiveport/location and 5 sendports. 
> Incoming message is routed to all sendports.
> Body tracking is enabled on the sendports.
> When sending one message it works fine, but when sending 50, the error below 
> occurs.
> 
> If body tracking is disabled there are no errors.
> 
> 
> The following stored procedure call failed: " { call 
> [dbo].[bts_UpdateMsgbox_Send_MSMQ]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
> ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Transaction 
> (Process ID 84) was deadlocked on lock resources with another process and has 
> been chosen as the deadlock victim. Rerun the transaction.;Duplicate key was 
> ignored.". 
> 
> Any idea what to do about this?
> 
> Regards,
> /Daniel

date: Wed, 18 Jun 2008 00:11:02 -0700   author:   DW am

Re: bts_UpdateMsgbox_Send_MSMQ]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,   

Is this a single BizTalk server installation?  Are there multiple Host
Instances that run this host (the MSMQ Adapter Host)?
-Dan

date: Wed, 18 Jun 2008 07:20:27 -0700 (PDT)   author:   Dan Rosanova