SAP Knowledge Base Article - Preview

2901188 - Unpredictable results of SQL requests in Hana DB

Symptom

  • 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


Read more...

Environment

SAP Hana Platform 1.0
SAP Hana Platform 2.0

Product

SAP NetWeaver 7.5

Keywords

SQL execution, background job, failure, sql optimization, PlanViz, table, join , KBA , HAN-DB-SCR , SAP HANA SQL Script , Problem

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.