Skip to Content
1
Jul 14, 2020 at 10:24 AM

CDS view memory allocation failed error

1329 Views

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