2634192 - ST22 dumps reporting SQLCODE = -89986 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2634192 - ST22 dumps reporting SQLCODE = -89986

Symptom

ST22 dumps reporting SQLCODE=-89986


Read more...

Environment

You observe the following ST22 dumps reporting SQLCODE=-89986 "SQL message: already processing within CLI"

pic01-dump.jpg

In the dev_w work process logs (DIR_HOME) you also observe the following stack trace referencing  "CLI_execCMRIFlushArray"  for CLI driver libdb2.so
  

M  SEGV_MAPERR: Address not mapped to object
M  30 (Memory location which caused fault)
M  ------------------ C-STACK ----------------------
dw.sapPW1_DVEBMGS00[S](LinStackBacktrace+0x8c)[0x63dfa9]
dw.sapPW1_DVEBMGS00[S](LinStack+0x35)[0x641ff0]
dw.sapPW1_DVEBMGS00[S](CTrcStack2+0x4e)[0x63dd61]
dw.sapPW1_DVEBMGS00[S](SigIGenAction+0x289)[0x18e6b18]
<signal handler called> [0x7fed056eb370]
libdb2.so(CLI_execCMRIFlushArray(CLI_STATEMENTINFO*, CLI_ERRORHEADERINFO*)+0x3c9)[0x7fe74ef7a959]
libdb2.so(SQLSetStmtAttr2(CLI_STATEMENTINFO*, int, void*, int, CLI_ERRORHEADERINFO*)+0x19ac)[0x7fe74eb250cc]
libdb2.so(SQLSetStmtAttrW+0x469)[0x7fe74f02a219]
dbdb2slibx.so[S](endChaining+0xfb)[0x7fe744aa61fb]
dbdb2slibx.so[S](cliEndChaining+0xc4)[0x7fe744aa7ef4]
dbdb2slibx.so[S](db2EndExecutes+0x2f)[0x7fe744a905bf]
dbdb2slibx.so[S](dbslExeModify+0x522)[0x7fe744a85162]
dw.sapPW1_DVEBMGS00[S](dbsl_exe_modify+0x9a)[0x204fb4a]
dw.sapPW1_DVEBMGS00[S](DbDbslStatement::executeUpdate(bool, short)+0x33a)[0x1beb63a]
dw.sapPW1_DVEBMGS00[S](DbDmlCursor::execute()+0x244)[0x1bee284]
dw.sapPW1_DVEBMGS00[S](DbDmlCursorExternal::executeViaDbsl(DbCursorAllocatorScope&, DbDmlStmt const&)+0x33f)[0x1be17bf]
dw.sapPW1_DVEBMGS00[S](DbDmlCursorExternal::execute(DbCursorAllocatorScope&, DbDmlStmt const&)+0xb6)[0x1be1b26]
dw.sapPW1_DVEBMGS00[S](OSqlModifyEntry::execute(DbCursorAllocatorScope&, DbDmlStmt&)+0x98)[0x1c5cca8]
dw.sapPW1_DVEBMGS00[S](ab_jsqln()+0xbc0)[0x1c63530]
dw.sapPW1_DVEBMGS00[S](ab_extri()+0x197)[0x1ae3737]
dw.sapPW1_DVEBMGS00[S](ab_xevent(char16_t const*)+0x32)[0x1b20ab2]
dw.sapPW1_DVEBMGS00[S](ab_dstep+0x36)[0x1ae0c86]
dw.sapPW1_DVEBMGS00[S](dynpmcal(DINFDUMY*, STPDUMMY*)+0x2d1)[0x1d36a51]
dw.sapPW1_DVEBMGS00[S](dynppbo0(DINFDUMY*)+0xb6)[0x1d38956]
dw.sapPW1_DVEBMGS00[S](dynprctl(DINFDUMY*)+0x189)[0x1d39059]
dw.sapPW1_DVEBMGS00[S](dynpen00+0x3d7)[0x1d29f07]
dw.sapPW1_DVEBMGS00[S](ab_HttpRequestHandler(TH_PLUGIN_ROLE, TH_PLUGIN_ACTION, int, TH_PLUGIN_PROTOCOL, unsigned char)+0x7d5)[0x1f85
dw.sapPW1_DVEBMGS00[S](PluginHandler::handleRequest(REQUEST_BUF*, bool)+0x41a)[0x1d00faa]
dw.sapPW1_DVEBMGS00[S](ThHandleRequest(REQUEST_BUF*, unsigned char)+0x19c)[0x1cd13ac]
dw.sapPW1_DVEBMGS00[S](TskhLoop()+0xa5)[0x1acf355]
dw.sapPW1_DVEBMGS00[S](ThStart()+0x284)[0x4dbcfe]
dw.sapPW1_DVEBMGS00[S](DpMain+0x35b)[0x1c6a21b]
libc.so.6[S](__libc_start_main+0xf5)[0x7fed0533cb35]
M  -------------------------------------------------
M  caught SIGSEGV (11)
M  ThSigHandler (0, Signal)
M  in_ThErrHandle: 1
M  ThIErrHandle: set thRc ERROR-CORE-ABORTED_BY_SIGNAL for T2_U8470_M0
M  ThResetEmMagic: reset em magic for T2_U8470_M0_I0
M  ThSigHandler: Signal for T2_U8470_M0 (step TH_WORK_SYNC, thRc ERROR-CORE-ABORTED_BY_SIGNAL, action RETURN_FOR_DUMP)
M  DpCheckSoftCancel: reset SOFT_CANCEL for T2_U8470_M0
M  DpCheckSoftCancel: softcancel schedule 14 for T2_U8470_M0 will be deleted explicitly

Followed by SQLCODE -89986 errors:

C  *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
 [dbdb2cli.c   6116]
M  ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C  *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
 [dbdb2cli.c   6116]
M  ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C  *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
 [dbdb2cli.c   6116]
M  ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C  *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
 [dbdb2cli.c   6116]

Product

SAP NetWeaver 7.4

Keywords

Netweaver DB2 CLI JDBC ODBC DB2 Connect z/OS , KBA , BC-DB-DB2-DBA , DB2 for z/OS - Database administration , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.