suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)