SAP DBTech JDBC: [4]: cannot allocate enough memory / details

[jordan72]

HI,

when I get this message

SAP DBTech JDBC: [4]: cannot allocate enough memory: search table error:  [9] Memory allocation failed;exception 1000002: Allocation failed ; $size$=338864576; $name$=Results; $type$=pool; $inuse_count$=951; $allocated_size$=142451349600; $alignment$=8; $failure_type$=GLOBAL_ALLOCATION_LIMIT; $failure_flag$=

from a JDBC query on 2.00.053.00, is there a way to immediately see how much more memory is/was needed ?

Does $allocated_size$=142451349600 mean, that 142GB was already allocated and that the request to allocate another 338MB failed and that adding 1GB would solve the issue ?

Regards

Volker

[ganapathi_govindan]

The dump or error message may not give the required memory details to execute the query.

There are 2 ways to understand the memory requirement.

1. Remove statement memory limit and execute the query to understand the memory requirement by generating the planviz where you can get all the details about the memory consumption.

2. Analyse the involved tables size and try to minimise the data selection by adding some filter.

This note may help you.

1984422 - How-To: Analyzing SAP HANA Out-of-memory (OOM) Dumps

Best regards,

Ganapathi.