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 ONE Support launchpad (Login required).

Search for additional results

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