Memory allocation failed error

[rindia]

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

[hugo_amo]

Hi Raj,

Could you check this KBA? It might help.

1862506 - HANA: Statisticsserver runs out of memory (OOM) after after SPS05

Regards,

Hugo

[rindia]

Thanks Amo.

I am waiting for the approval to change the settings.

Will update once I get the approval.

Regards

Raj

[hugo_amo]

Keep us updated,

Regards,

Hugo