- 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
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:  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:  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-SCR , SAP HANA SQL Script , Problem
About this pageThis 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.