Symptom
On SAP BW systems on SAP ASE database, DTPs processing more than 30 data packages fail with signal 11, SYSTEM_CORE_DUMPS
These jobs are handling queries with large result sets
SYSTEM_CORE_DUMPS are received on an SAP BW system while processing queries with large result sets - the corresponding C-stacks indicate failure in ODBC driver functions. The offending query returns 3+million row result set - this query works fine in isql. dw.sapBWP_DVEBMGS00[S](LinStackBacktrace+0xa9)[0x555b14fb7aea,0x794aea] dw.sapBWP_DVEBMGS00[S](LinStack+0x4d)[0x555b14fbaae0,0x797ae0] dw.sapBWP_DVEBMGS00[S](CTrcStack2+0x4b)[0x555b14fb688c,0x79388c] dw.sapBWP_DVEBMGS00[S](rabax(char16_t const*, char16_t const*, int, char16_t const*, void const*)+ dw.sapBWP_DVEBMGS00[S](ab_CoreInfo+0xc6)[0x555b1519ebdc,0x97bbdc] dw.sapBWP_DVEBMGS00[S](ThrCoreInfo(int)+0x9)[0x555b14f3f197,0x71c197] dw.sapBWP_DVEBMGS00[S](ThIErrHandle(int, unsigned char, TH_VERBOSE_LEVEL, char16_t const*)+0x13d8) dw.sapBWP_DVEBMGS00[S](ThErrHandle2(int, unsigned char, char16_t const*, char16_t const*)+0x97)[0x dw.sapBWP_DVEBMGS00[S](SigIGenAction+0x3b4)[0x555b171e8554,0x29c5554] libpthread.so.0[T][0x7f5d9a1b5c00,0x11c00] libsybdrvodb8.so[N](SQLFreeHandleOptional(short, void*)+0x132)[0x7f5a17682742,0x1fa742] dbsybslib.so[S](free_stmt.constprop.114+0x1c0)[0x7f5a17aa3f40,0x125f40] dbsybslib.so[S](StmtCacheAdd+0x91a)[0x7f5a17aaa56a,0x12c56a] dbsybslib.so[S](PrepOperation+0x2544)[0x7f5a17b0ded4,0x18fed4] dbsybslib.so[S](DoSingleRead+0x53)[0x7f5a17b135e3,0x1955e3] dbsybslib.so[S](SybRead+0x1127)[0x7f5a17b2aaf7,0x1acaf7] dbsybslib.so[S](DbSlRead96+0x76)[0x7f5a17a4e986,0xd0986] dw.sapBWP_DVEBMGS00[S](dbsl_read+0x99)[0x555b16d70669,0x254d669] dw.sapBWP_DVEBMGS00[S](DbDbslCursorSingle::doNext(unsigned long*, bool)+0x1fd)[0x555b16da687d,0x25 dw.sapBWP_DVEBMGS00[S](DbCursor::next(unsigned long*, bool&)+0x7dd)[0x555b16d7cc0d,0x2559c0d] dw.sapBWP_DVEBMGS00[S](ab_jsqln()+0x10d)[0x555b16eca3ad,0x26a73ad] dw.sapBWP_DVEBMGS00[S](ab_extri()+0x1fa)[0x555b16b3b4ea,0x23184ea] dw.sapBWP_DVEBMGS00[S](ab_xevent(char16_t const*)+0x36)[0x555b16b94746,0x2371746]
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse (BW)
- SAP Netweaver (NW) all versions
Product
SAP NetWeaver 7.5
Keywords
DTP, SYSTEM_CORE_DUMP, CR#824201, CR824201, 824201 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview