IBM Support

WTRN0078E error when using SQL Server 2008 on Windows 2008 Cluster with DTC

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:

[{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Databases","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

BPM

Document Information

Modified date:
15 June 2018

UID

swg21506986

Page Feedback