Microsoft Fixes BizTalk Adapter Problem

Microsoft has released a hotfix for a looping problem with Microsoft BizTalk Server 2004. If a message fails validation or routing in BizTalk Server 2004, the BizTalk Adapter for SQL Server rolls back the transaction and leaves the failed message in the source SQL database. The SQL adapter will pick it up again and try to process it, but when the processing fails again, the transaction rolls back again. This problem creates a continuous loop. To learn more about the problem and the supported hotfix, read the Microsoft article "FIX: The BizTalk Adapter for SQL Server may repeatedly try to process a bad message" at

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.