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

[Former Member]

HI Everyone,

                    I am facing same error in sap hana studio. how to solve this issues?. please give a solution.

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

[Former Member]

Hello Rajesh,

1. Please don't resurrect old threads. Open a new one with your problem.

2. Please provide at least the minimum information such as:

2.1 Your HDB revision

2.2 Your sizing information (namely how much memory you have)

2.3 What you are doing which is obviously causing the OOM

The above said, have a look in your trace files and you will see what is potentially causing the OOM.

KR,

Amerjit

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.