Microsoft KB Archive/232343

= FIX: XA Transaction Monitors May Show Inconsistent Outcome =

Article ID: 232343

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft Windows NT Server 4.0, Terminal Server Edition
 * Microsoft Windows NT Server 4.0 Standard Edition
 * Microsoft Transaction Services 2.0

-



This article was previously published under Q232343



SYMPTOMS
Other database's XA monitor (such as Oracle XA monitor, DB2 XA monitor) may show indoubt transactions that were never resolved by Distributed Transaction Coordinator (DTC) XA Transaction Manager (XATM)



CAUSE
DTC's XATM recovery code issues xa_recover call to the Resource Manager (RM), which returns XAER_RMERR. DTC incorrectly treats recovery as successful and deletes the information about the RM. This can cause DTC to forget about transactions that are still indoubt in the Resource Manager. This problem only occurs with 1-pipe RMs. DTC has two models for supporting XA transactions:
 * 1-pipe model: where the prepare and commit are sent on the application pipe/connection to the RM
 * 2-pipe model: where DTC opens a separate connection to the RM and sends prepare/commit on this second pipe.

NOTE: Oracle and DB2 Resource Manager uses the 1-pipe model.



Windows NT Server or Workstation 4.0
To resolve this problem, obtain the latest service pack for Windows NT 4.0 or the individual software update. For information on obtaining the latest service pack, please go to:


 * http://www.microsoft.com/windows/servicepacks/ -or-


 * 152734 how to obtain the latest windows nt 4.0 service pack

For information on obtaining the individual software update, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services phone numbers and information on support costs, please go to the following address on the World Wide Web:

http://support.microsoft.com/directory/overview.asp

Windows NT Server 4.0, Terminal Server Edition
To resolve this problem, obtain the latest service pack for Windows NT Server 4.0, Terminal Server Edition. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

152734 How to Obtain the Latest Windows NT 4.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Windows NT 4.0 and Windows NT Server 4.0, Terminal Server Edition.

This problem was first corrected in Windows NT Server 4.0 Service Pack 6 and Windows NT Server 4.0, Terminal Server Edition Service Pack 6.



Who Should Install This Release
You should install hotfix 051099e if you are noticing the above mentioned behavior.

Installation:
This hotfix should only be installed on systems running Microsoft Windows NT version 4.0 (Service Pack 5). It should not be installed on other systems running Microsoft Windows NT version 3.51 or Microsoft Windows 2000.

Note that this hotfix is based on the version of Microsoft DTC included with the Windows NT 4.0 Service Pack 5 release. By installing this hotfix, you are upgrading Microsoft DTC to the Windows NT 4.0 Service Pack 5 release level in addition to correcting the problems described here.

How to Install on a Non-clustered System
 Create an empty temporary directory on your system.  Run the self-extracting executable file (i051099e.exe (i386) or a051099e.exe (alpha)) and type the name of the temporary directory when you are prompted to do so. The program unzips the following files into the temporary directory:   Dtcsetup.exe Qfe051099e.txt Stop the Microsoft DTC Service, if it is running. Stop all services that depend on Microsoft DTC (including Microsoft Transaction Server, Microsoft SQL Server, Microsoft Message Queue, and Microsoft COM Transaction Integrator (COMTI)).  Close the Windows NT Control Panel, if it is open. Run Dtcsetup.exe. Restart the system.</li> Restart all services that depend on Microsoft DTC.</li></ol>

How to Install on a Cluster with an Already Clustered Microsoft DTC
<ol> Create an empty temporary directory on both nodes of the cluster.</li>  Run the self-extracting executable file (i051099e.exe (i386) or a051099e.exe(alpha)) on both nodes of the cluster and type the name of the temporary directory when you are prompted to do so. The program unzips the following files into the temporary directory: <pre class="fixed_text">  Dtcsetup.exe Qfe051099e.txt </li> Use the MSCS Cluster Administrator to stop the Microsoft DTC cluster resource, if it is running. Stop all services that depend on Microsoft DTC (including Microsoft Transaction Server, Microsoft SQL Server, Microsoft Message Queue, and Microsoft COMTI).</li> Close the Windows NT Control Panel on all systems in the cluster.</li> Run Dtcsetup.exe on the node that controls the Microsoft DTC cluster resource. When you are prompted to install Microsoft DTC on the other nodes in the cluster, run Dtcsetup.exe on those nodes.</li> Restart all systems.</li> Restart all services that depend on Microsoft DTC.</li></ol>

How to Install on a Cluster with a Non-clustered Microsoft DTC
<ol> Create an empty temporary directory on both nodes of the cluster.</li>  Run the self-extracting executable file (i051099e.exe (i386) or a051099e.exe (alpha)) on both nodes of the cluster and type the name of the temporary directory when you are prompted to do so. The program unzips the following files into the temporary directory: <pre class="fixed_text">  Dtcsetup.exe Qfe051099e.txt </li> Stop the Microsoft DTC Service on all systems in the cluster. Stop all services that depend on Microsoft DTC (including Microsoft Transaction Server, Microsoft SQL Server, Microsoft Message Queue, and Microsoft COMTI).</li> Close the Windows NT Control Panel on all systems in the cluster.</li> When you install this release on a clustered system, the Setup program automatically installs a clustered version of Microsoft DTC. The clustered version of Microsoft DTC requires an MSCS Resource Group that contains both a Network Name Resource and a Shared Disk Resource. Before installing this release, ensure that at least one such MSCS Resource Group exists. Dtcsetup.exe will assign Microsoft DTC to the first MSCS Resource Group that it finds that contains both a Network Name Resource and Shared Disk Resource. After ensuring that the necessary Resource Group exists, run Dtcsetup.exe on the node controlling that Resource Group.</li> When you are prompted to install Microsoft DTC on the other nodes in the cluster, run Dtcsetup.exe on those nodes.</li> Reboot all systems.</li> <li>Restart all services that depend on Microsoft DTC.</li></ol>

Keywords: kbbug kbfix kbqfe kbmts200fix kbdatabase kbdtc kbhotfixserver KB232343

-

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

© Microsoft Corporation. All rights reserved.