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
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.