Troubleshooting
Problem
When running IBM Business Process Manager JDBC XA transactions against Microsoft SQL Server 2008 on a Windows Server 2008 cluster, an issue occurs with the Microsoft Distributed Transaction Coordinator (MS DTC).
Symptom
You might see an error similar to the following text in the SystemOut.log file:
WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows:
javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to enlist. Error: "Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)."
Cause
This problem is related to Microsoft SQL Server databases on Microsoft Windows Server 2008 because previous versions of the Windows Server Edition had only one DTC Service in a cluster. With Windows Server 2008, each member can have its own DTC Service. This difference is either the application requesting a transaction has to specify which DTC to use or you have to create a mapping, which is the case for all Java Database Connectivity (JDBC)-based transactions.
Resolving The Problem
Follow the instructions for the Microsoft operating system and the database product. Refer to the following documents for the Microsoft DTC configuration:
Understanding MS DTC Resources in Windows Server 2008 Failover Clusters - http://technet.microsoft.com/en-us/library/cc730992(WS.10).aspx
Map Clustered MS DTC Resources - http://technet.microsoft.com/en-us/library/cc742483(WS.10).aspx
Product Synonym
BPM
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21613696