Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

2 views
Skip to first unread message

DW

unread,
Jun 17, 2008, 5:13:19 PM6/17/08
to
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

DW

unread,
Jun 18, 2008, 3:11:02 AM6/18/08
to
By the way.
It´s a BizTalk 2006 r2 Enterprise

/Daniel

Dan Rosanova

unread,
Jun 18, 2008, 10:20:27 AM6/18/08
to
Is this a single BizTalk server installation? Are there multiple Host
Instances that run this host (the MSMQ Adapter Host)?
-Dan
0 new messages