Microsoft KB Archive/191210

= BUG: DTC May Return Msg 8503 or Msg 8522 =

Article ID: 191210

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q191210



SYMPTOMS
Distributed Transaction Coordinator (DTC) may stop the execution of a local stored procedure, with either of the following messages:

Msg 8503:

Attempt to start distributed transaction while transaction active

-or-

Msg 8522:

Distributed transaction aborted by DTC

This problem can occur if both of the following conditions are true:


 * The local stored procedure starts a distribution transaction, calls a remote stored procedure, and then performs a ROLLBACK TRANSACTION statement.

In this case, Msg 8503 occurs if the local stored procedure contains a loop that executes the above process multiple times.

Msg 8522 occurs if the local stored procedure contains one occurrence of the above process, but the stored procedure is executed multiple times within a loop.

-and-
 * The remote stored procedure performs a BEGIN TRANSACTION statement and then performs a ROLLBACK TRANSACTION statement.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
This problem does not occur with the newer version of DTC that comes with Microsoft Transaction Server (MTS) 2.0.

Additional query words: MSDTC tran

Keywords: kbbug kbpending KB191210

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.