Symptom
- Running a query with huge IN list like following:
SELECT c1 FROM table WHERE c1 IN (....)
- The number of IN list elements is very large (one known instance had more than 2.8 million).
- Error 702 is reported together with a stack trace:
Error: 702, Severity: 20, State: 1
Memory request for 88712 bytes exceeds the size of single page of 16384 bytes.
- The stack trace include the following functions:
memalloc
memalloc_zero
LeCloner::LeClSargMap
CgGenLava::CGConsOrScanOp
CgpScanValues::_cgpCodeGen
CgpPop::cgpCodeGen
CgpNlJoin::_cgpCodeGen
CgpPop::cgpCodeGen
CgpPop::prepareCodeGenCgp
CgpEmit::_cgpCodeGen
CgpPop::cgpCodeGen
GenLava
s_compile_stmt
s_compile
Note: A complete stack trace is available under Attachments.
Read more...
Environment
SAP Adaptive Server Enterprise ASE 16.0
Product
Keywords
CR819771, CR#819771, 819771, 'max number of IN elements' , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.