DB2 - Problem description
Problem IT18114 | Status: Closed |
SQL0998 RETURNED FROM ENLISTDISTRIBUTEDTRANSACTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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: * * Visual Studio .NET application using distributed * * transactions * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v10.5 Fix Pack 9 to client being used by .NET * * application * **************************************************************** | |
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) | |
Solution | |
First fixed in v10.5 Fix Pack 9 | |
Workaround | |
See LOCAL FIX. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.11.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |