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.