BUG: DTC May Return Msg 8503 or Msg 8522 (191210)
The information in this article applies to:
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
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB191210 |
|---|
|