top of page
  • Making business consulting look easy
  • Making business consulting look easy
  • Making business consulting look easy
Search

BizTalkServerApplication deadlock

  • Alphonzo Munnings
  • Jun 20, 2021
  • 1 min read

bts_UpdateMsgbox_BizTalkServerApplication deadlocks due to PersistenceItemException


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


Seems like this was resolved by shortening the delay that waits to see if there are any more messages to be received. Reducing the amount of messages being processed also seemed to help, but that left out data that was important to the business process.




 
 
 

Comentarios


bottom of page