Troubleshooting
Problem
You might run into an issue with the Microsoft Distributed Transaction Coordinator (MS DTC) when you run IBM Business Process Manager 7.5 JDBC XA transactions against Microsoft SQL Server 2008 on a Windows Server 2008 cluster.
Symptom
The error in the SystemOut.log file might look similar to this text:
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
The problem is related to Microsoft SQL Server databases on Microsoft Windows Server 2008 because previous versions of the Windows Server Edition did only have one DTC Service in a cluster. With Windows Server 2008, each member can have its own DTC Service. This difference is why 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 to solve this issue. Good starting points for the Microsoft DTC configuration are the following documents:
Related Information
Product Synonym
BPM
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21506986