BUG: DTC May Return Msg 8503 or Msg 8522

• Microsoft SQL Server version 6.5

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

• 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          : SSrvDTC SSrvStProc kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 16, 1999