Skip to Content

CDS view memory allocation failed error

Hello all,

I have a CDS view which in turn has many CDS views inside merged by union all. When i run this CDS view i get memory allocation failed error

"Database returned the SQL code 2.048. Error text: column store error: search table error: [9] Memory allocation failed;exception 1000002: Allocation failed ; $size$=410872064; $name$=Results; $type$=pool; $inuse_count$=387; $allocated_size$=271895727900; $alignment$=8; $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$= ,Exception in executor plan31326183@srv34051c2n2:31303 while executing pop 71"

Steps followed to check the error:

1) I ran each and every CDS view separately which are in union, that time it is not failing it is showing result for each and every cds view, but when running the base consumption cds view it fails

2) Even i checked the total record count, it is not more than 6000 records totally

3) I tried taking the trace file from index server of HANA db activating the "Plan trace" but still i am not able to see much info from that trace , it is not showing where exactly query failed

4) I tried checking the visualize plan of cds view by taking the planviz from ST12 trace , no luck in that also when clicking the “Execution Trace” it loads for sometime and again showing same memory allocation error.

Can anyone please let me know how to check which query exactly it fails or how to visualize this plan.

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 14 at 10:55 AM

    In your system a Statement Memory Limit is set which is reached by executing your CDS view (even the result are "just" 6000 records, the statement itelf can/will consume more memory during resolving the whole model).

    As it is an Out of Memory (OOM) failure, your system should have created an OOM Dump. Probably this gives you more information. Details regarding the analysis with OOM Dumps please check note 2332170.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.