SQl server db dead locks when Biztalk writes to Private queues

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQl server db dead locks when Biztalk writes to Private queues

Viewing 1 reply thread
  • Author
    Posts
    • October 22, 2008 at 10:28 AM #21036
      community-content

        We are developing an application where Biztalk server 2006 R2 writes messages in to MSMQ private queues remotely.

        a WCF service picks up these messages from the queue and updates or inserts the sql server db returns back a response to a different private queue.

        I am using a custom client to write messages in to the initial queue which works good for me. But when Biztalk writes messagea the db throws an exception like this

        Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Uncommittable transaction is detected at the end of the batch

        Any pointers would be much helpful

        Thanks,

        Hari

         

         

         

         

         

      • October 24, 2008 at 6:16 AM #21042
        community-content

          Can you give more details?  Is your WCF service using the NetMSMQ binding?  Where are you seeing that error?  Does the message suspend in BizTalk, or does BizTalk think it was successful?

          • October 28, 2008 at 10:43 AM #21067
            community-content

              yes We are using NETMSMQ binding. The errors are logged in the sql table . So it looks like Biztalk thinks it is successful but ideally it is not

               

              Thanks

              • October 28, 2008 at 6:58 PM #21071
                community-content

                  What SQL table are the errors logged into?  Is it the same one where the data is supposed to be logged, or is it a different one?  In BizTalk, do you see any suspended or dehydrated messages or errors in the event log?

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.