SAP Knowledge Base Article - Preview

2821134 - Error 702 Memory request for 88712 bytes exceeds the size of single page of 16384 bytes

Symptom

  • Running a query with HUGE IN list like following:

        SELECT c1 FROM table WHERE c1 IN (....)

  • The number of IN list elements is more than 2.8 million.
  • Error 702 reported with following stack trace:

        Error: 702, Severity: 20, State: 1
        server  Memory request for 88712 bytes exceeds the size of single page of 16384 bytes.

 exc_raise
 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



Environment

SAP Adaptive Server Enterprise ASE16 SP02 PL07

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR819771, CR#819771, 819771 , 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) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.