Question Re: Memory allocation failed error in Technology Q&A

Memory allocation failed error

rindia — Fri, 23 Aug 2013 17:11:46 GMT

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

Re: Memory allocation failed error

hugo_amo — Fri, 23 Aug 2013 17:26:02 GMT

Hi Raj,

Could you check this KBA? It might help.

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

Regards,

Hugo

Re: Memory allocation failed error

Former Member — Fri, 23 Aug 2013 17:55:39 GMT

Hi Raj,

Depending on your views will be necessary use variables / parameters to filter on lowest level of data.

If you are conducting development you have also an option to hard code these filters on biggest tables of your model.

Anyhow, this is a thing you must investigate as there's a possibility of your views are avoiding push down of selection filters.

No enough information to judge.

Regards, Fernando Da Rós

Re: Memory allocation failed error

rindia — Fri, 23 Aug 2013 18:00:24 GMT

Thanks Amo.

I am waiting for the approval to change the settings.

Will update once I get the approval.

Regards

Raj

Re: Memory allocation failed error

hugo_amo — Fri, 23 Aug 2013 18:02:31 GMT

Keep us updated,

Regards,

Hugo

Re: Memory allocation failed error

rindia — Fri, 23 Aug 2013 18:12:37 GMT

Hi Fernado,

I am on support and not in development.

Regards

Raj

Re: Memory allocation failed error

Ravi_Channe — Fri, 23 Aug 2013 19:51:38 GMT

Hi Raj,

I agree with Fernando. Even my first impression of this post was, "not enough information".

I understand you are currently supporting the HANA application, but you may suggest the user to execute the reports with some additional filters.

I think many of the applications developed so far, were initially developed on the early revisions of HANA. Considering that HANA is relatively new development platform, the applications might not have been tuned properly for the performance. Now with high data volume you may face performance issues. But that doesn't mean, you cannot change the existing application with some Change Request.

As part of the support team, you can perform basic analysis with the query plan and identify the bottlenecks. You are among the very active member on this forum and quite experienced on HANA, . So I don't need to mention here how the basic analysis should be done.

As Fernando mentioned, I think the filters should be pushed down to reduce the result set generated. Unless the intermediate result set and data transfer between the engines is reduced, it would be difficult to get good performance or even query execution on HANA.

You already know quite many things on how to achieve it and I am sure you will figure that out.

Regards,

Ravi

Re: Memory allocation failed error

rindia — Wed, 28 Aug 2013 03:26:52 GMT

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

Re: Memory allocation failed error

Former Member — Fri, 03 Oct 2014 04:10:19 GMT

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

Re: Memory allocation failed error

rindia — Sun, 26 Oct 2014 01:39:32 GMT

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

Re: Memory allocation failed error

Former Member — Wed, 13 Jul 2016 08:59:49 GMT

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.

Re: Memory allocation failed error

Former Member — Wed, 13 Jul 2016 09:20:12 GMT

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

Re: Memory allocation failed error

Former Member — Wed, 13 Jul 2016 09:49:16 GMT

This message was moderated.

Re: Memory allocation failed error

Former Member — Wed, 13 Jul 2016 11:42:18 GMT

This message was moderated.

Re: Memory allocation failed error

Mushfiq — Wed, 13 Jul 2016 11:51:57 GMT

This message was moderated.

Re: Memory allocation failed error

Former Member — Tue, 19 Jul 2016 14:36:47 GMT

This message was moderated.