Skip to Content

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

Memory allocation failed error

Hi,

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?

Regards

Raj

Tags:
replied

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.

Regards

Raj

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