SAP Knowledge Base Article - Preview

2922983 - Error: 702 followed by stack trace is raised due to many UNIONs in a query - SAP ASE

Symptom

  • When crafting SQL where 10000 inserts to a simple table (1 char column) in the format "insert _table(x) values (y) .. insert _table(s) ... this works
  • Getting Error: 702 when querying SQL where 10000 inserts to a simple table using the form insert_table (x) select 'value 1' union all select 'value 2'...
  • Msg 702, Level 20, State 1:
    Server 'ASE', Line 1:
    Memory request for 40000 bytes exceeds the size of single page of 16384 bytes.
    ASE is terminating this process.
  • Some of the functions are:
    LopUnion::LopUnion
    LopUnionAll::LopUnionAll
    _lopConsUnionProd
    _lopConsUnion
    _lopConsSeq
    lopGenerate
    s_compile_stmt
    s_compile


Read more...

Environment

Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR820284, CR#820284, 820284 , 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.