IBM Support

SQL0998N when COM+ component makes the initial connection

Troubleshooting


Problem

SQL0998N, Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "3-8004D00E". SALSTATE=58005, returned when COM component requires a transaction. Reason code: * 16 - A failure occurred with the Microsoft Distributed Transaction Coordinator (MSDTC). Subcode: * 03 - MSDTC is unable to enlist the DB2 connection in the Distributed Transaction. The subcode represents the Microsoft error code: 0x8004D00E XACT_E_NOTRANSACTION

Symptom

SQL0998N Reason Code="16" Subcode="3-8004D00E"

Cause


Knows APAR or programing error

Environment

Windows, COM+ application

Diagnosing The Problem

Application is failing with SQL0998N Reason Code="16" Subcode="3-8004D00E" on the initial connection.

Db2diag.log reports the following entries when application fails with error SQL0998n:

2011-11-15-09.19.04.285000-360 I2427926H570 LEVEL: Severe
PID : 5788 TID : 3552 PROC : dllhost.exe
INSTANCE: DB2 NODE : 000
APPID : 10.22.64.225.50448.111115151905
EDUID : 3552
FUNCTION: DB2 UDB, XA DTP Support, MicrosoftEnlistWithRM, probe:421
DATA #1 : String, 130 bytes
HRESULT: 8004D00E
HRESULT Message: The transaction has already been implicitly or
explicitly committed or aborted

ITransaction:
DATA #2 : Hexdump, 16 bytes
0x00E6DA74 : E00D 0000 0000 0000 6500 6819 DB19 0000 ........e.h.....

2011-11-15-09.19.04.285000-360 I2428498H737 LEVEL: Info
PID : 5788 TID : 3552 PROC : dllhost.exe
INSTANCE: DB2 NODE : 000
APPID : 10.22.64.225.50448.111115151905
EDUID : 3552
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -998 sqlerrml: 13
sqlerrmc: 16 3-8004D00E
sqlerrp : SQLXACOM
sqlerrd : (1) 0x00000000 (2) 0x00000010 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 58005

Resolving The Problem

1) Apply the fix for a known APARs or work around the problem by using User ID in upper case.

Known APARs:

v9.5: http://www-01.ibm.com/support/docview.wss?uid=swg1IC65235
v9.7: http://www-01.ibm.com/support/docview.wss?uid=swg1IC65286



2) Check application:

If frmNBTCommPlanAdd.asp page has the following at the beginning of the
page:

<%@ Language=VBScript
@ Transaction=required
%>

then there is Transaction=required line is what is causing the problem. Remove this line to fix the error.

Related Information

v9.5 APAR IC65235

v9.7 APAR IC65286

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - Other","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21572529

Page Feedback