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 for Me (Login required).

Search for additional results

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