SAP Knowledge Base Article - Preview

2821134 - Error 702 raised when running a query with large number items IN list - SAP ASE


  • 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 is reported together with a stack trace:

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

  • The stack trace include the following functions:


  Note: A complete stack trace is available under Attachments.



SAP Adaptive Server Enterprise ASE 16.0


SAP Adaptive Server Enterprise 16.0


CR819771, CR#819771, 819771, 'max number of IN elements' , 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) , 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.