2901188 - Unpredictable results of SQL requests in Hana DB

• You have an existing background job which is executing a complex SQL query
• After some time of normal operation, the results of this query become inconsistent sometimes failing with the below dump in transaction ST22
  

  Runtime Errors DBSQL_SQL_ERROR
  Except. CX_SY_OPEN_SQL_DB
  Date and Time 10.03.2020 13:48:48
  Short Text SQL error "SQL code: 2048" occurred while accessing table <table_name>.
  What happened? Database error text: "SQL message: column store error: search table error: [9] Memory allocation failed"
  Error analysis An exception has occurred which is explained in more detail below. The exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in procedure "GENERATE_OUTPUT_HANA_VIEW5" "(METHOD)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated this exception, the current program was terminated. The reason for the exception is: Database error text: SQL message: column store error: search table error: [9] Memory allocation failed Return value of the database layer: "SQL dbsl rc: 99"

• Normal execution of the job memory consumption on Hana is consistent
• During the error executions of the job memory consumption on Hana increases greatly, potentially throwing an Out Of Memory exception

SAP Hana Platform 1.0
SAP Hana Platform 2.0

SQL execution, background job, failure, sql optimization, PlanViz, table, join , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB , SAP HANA Database , Problem