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

[rindia · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

I am a newbie. I am facing this issue in Rev 74. Please help!

In my case, I cannot add filters to restrict the data. Actually I saw some SAP video in which SAP is mentioning like they are processing billions of data in HANA. But, We have data in Millions and facing this error.

"Error executing the query
Error: SAP DBTech JDBC: [2048]: column store error: search table error: [9] Error executing physical plan: Memory allocation failed; in executor::Executor in cube: _SYS_BIC:Analytical View name/olap"

Appreciate your suggestions!

Thanks in advance!!

Regards,

Jeni

[rindia · Accepted solution]

Hi Jeni,

To me the same problem was resolved when we upgraded. You are in rev 74 and obviously greater than what we upgraded before.

Me too, want to know what the solution can be.

Let us see what others suggest.

Regards

Raj