If a message fails validation or routing in Microsoft BizTalk Server 2004, the BizTalk Adapter for SQL Server rolls back the transaction, and the failed message is still in the source SQL database. The SQL adapter will pick it up again, and then try to process it. The processing fails again, and the transaction rolls back again. This problem creates a continuous loop.
RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem t... |