DB2 - Problem description
Problem IT18042 | Status: Closed |
SQL0998 RETURNED FROM ENLISTDISTRIBUTEDTRANSACTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When trying to enlist a transaction for XA (2 phase commit) in Microsoft Entity Framework, the following error is returned: SQL0998N Error occurred during transaction or heuristic processing. Reason Code = \"16\". Subcode = \"2-FFFFFFFF8004D026\"."} * subcode 02, MSDTC was unable to register the connection. For more information refer to the db2diag log file or the Windows Event Viewer for an entry titled MicrosoftXARMCreate. Function stack returned: at IBM.Data.DB2.DB2Connection.EnlistDistributedTransaction2(Object iTxn) at IBM.Data.DB2.DB2Connection.EnlistTransaction(Transaction txn) at System.Data.Entity.Infrastructure.Interception.InternalDispatche r`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbConnectionDispa tcher.EnlistTransaction(DbConnection connection, EnlistTransactionInterceptionContext interceptionContext) at System.Data.Entity.Core.EntityClient.EntityConnection.EnlistTran saction(Transaction transaction) ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * .NET provider * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade client to v11.1 Fixpack 2 * **************************************************************** | |
Local Fix: | |
If XA is not needed use Database.BeginTransaction (https://msdn.microsoft.com/en-us/library/system.data.entity.dat abase.begintransaction%28v=vs.113%29.aspx) | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in v11.1 Fixpack 2 | |
Workaround | |
See LOCAL FIX. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.11.2016 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |