
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 that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next Microsoft BizTalk Server 2004 service pack that contains this hotfix.
|