SAP Knowledge Base Article - Preview

3268844 - Error 702 when executing a SELECT with many elements in an IN clause. - SAP ASE

Symptom

  • A query with large number of IN list items failed with Error 702. The number of items exceed 524288
  • The stack includes:
    Error: 702, Severity: 20, State: 1 Memory request for 29944 bytes exceeds the size of single page of 16384 bytes
    memalloc
    memalloc_zero
    LeCloner::LeClSargMap
    CgGenLava::CGConsOrScanOp
    CgpScanValues::_cgpCodeGen
    CgpPop::cgpCodeGen
    CgpInsert::_cgpCodeGen
    CgpPop::cgpCodeGen
    CgpStoreInd::_cgpCodeGen
    CgpPop::cgpCodeGen
    CgpSequence::_cgpCodeGen
    CgpPop::cgpCodeGen
    CgpPop::prepareCodeGenCgp
    CgpEmit::_cgpCodeGen
    CgpPop::cgpCodeGen
    GenLava
    s_compile_stmt

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

Sybase, ASEServer, SAPASE, dataserver, CR827256, CR#827256, 827256 , KBA , 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.