Skip to Content

Memory Allocation Failed, column store error, search table error


For Hana 2.0 SPS02 rev 23 256 GB license. Lumria Server 1.31 Add-on BI platform 4.2 SPS 05.

I am getting what seems like very High Memory usage on my Hana Server. Can someone please tell me how to debug and optimize ? I did a HDB stop/start as well as machine reboot. My large join queries in Lumira are failing due to HDB i believe.

Thanks for your insight,


Add comment
10|10000 characters needed characters exceeded

  • A great starting point for such questions are the HANA documentation and the SAP notes around memory management.

    I highly recommend to get a grip on the concepts of SAP HANA first as any analysis will build on these.

  • Get RSS Feed

2 Answers

  • Jun 13, 2018 at 09:02 AM

    Are you getting some out of memory dumps? Without these it's impossible to know whats going on. More details needed.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 13, 2018 at 09:01 AM

    Hi Matt,

    There is a guide answer might provide you with some ideas.

    Also note 1999997 helps, which covers most of OOM situation.

    To detailed analyze this issue, you can create an incident to HAN-DB, as planViz and traces are needed for deep analysis.

    Best regards,


    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Candy, This is still an issue for me and will be fore the foreseeable future. I need a better understanding of the HANA engine, memory requirements, and query limitations.