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.