Symptom
- ASE configuration parameter "max query parallel degree" is set to 1 on SAP Business Warehouse (BW) systems.
- BW jobs/queries fail occasionally on these systems with an "infected with signal 11" error with a stack trace:
Current process (0x67f900a3) infected with signal 11 (SIGSEGV)
Address 0x0x000000000095eab9 (PopEmit<SerialCost, SerialProps>::emitMatchProperties(bool)+0x29), siginfo (code, addre ss) = (1, 0x0x0000000000000008)
- Stack trace includes the following functions:
PopEmit<SerialCost, SerialProps>::emitMatchProperties
PopReptnIndScan<ParallelCost, ParallelProps>::popGenCgp
OptGlobal::_GblAddTopLevel
OptGlobal::GblOptimize
Optimize
s_compile_stmt
s_compile
sequencer
curs_execute
s_setupcursor
Note: A complete stack trace is available under Attachments.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
Keywords
SEGV, SerialCost, CR798012, 798012, CR#798012, parallel, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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