Biztalk 2006 to SQL 2005 Deadlock Error

• oliver.hernando

  Newbie

  Points: 1

  More actions

  June 11, 2008 at 8:37 pm

  #381062

  Calling all Expert of Biztalk and SQL Server 2005:

  I'm a newbie Biztalk developer.I'm using SQL Adapter to call a stored procedure. I encountered a deadlock. The error description is like this:

  Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

  I think the stored procedure that is called currently in execution while another message request is coming that causes the deadlock.

  Any idea how to resolve this issue in the stored procedure?

  I greatly appreciate your idea.

  Regards,

  Oliver

• Jo Pattyn

  SSC-Dedicated

  Points: 32473

  More actions

  June 18, 2008 at 2:56 pm

  #830785

  Hello,

  If sql server is started with some trace flags (see the article), it logs detailed information in the sql server log.

  Microsoft article about resolving deadlocks in sql server:

  http://msdn.microsoft.com/en-us/library/ms178104.aspx