Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Memory allocation failed error


I am running the SQL in SQL console (HANA revision 58). After 2 minutes, I am getting the error:

SAP DBTech JDBC: [2048]: column store error: search table error:  [9] Memory allocation failed.

The query is based on joining many HANA tables and views (non-materialized) with concatenation columns and some views has huge data volume.

I am looking for solution to execute the query with sufficient memory allocation. Is there any setting required to do so?




Hana revision is upgraded to 62 (on the week end) and it is strange that I am not getting this error any more. Also I not changed anything.



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question