SAP Knowledge Base Article - Preview

2953748 - Simple query with REGEXP fails with "Statement requires too much memory during query execution" -- SAP IQ

Symptom

A query using 'REGEXP' function encounters below error,

 Error =>
     There was an error reading the results of the SQL statement.
     The displayed results may be incorrect or incomplete.
     Statement requires too much memory during query execution
     SQLCODE=-1899, ODBC 3 State="54000"


Read more...

Environment

  • SAP IQ16.1 SP03.x
  • SAP IQ16.1 SP04.x

Product

SAP IQ 16.1

Keywords

REGEXP , "SQLCODE=-1899", "-1899", "Statement requires too much memory" , REGEXP_SUBSTR , , KBA , BC-SYB-IQ , Sybase IQ , HAN-DYT , SAP HANA Dynamic Tiering , Problem

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.