column store error search table error 9 memory allocation failed

[Former Member]

Hi Folks,

I'm creating a scripted Calculation view with below sql query,

var_out = SELECT A.PERIO, SUM(A.VV010) AS Revenue, SUM(A.VV290) AS Price_Variance, A.VKORG from _SYS_BIC."ASHOK_ECC/AV_ACTUAL" AS A JOIN _SYS_BIC."ASHOK_ECC/AV_PLAN" AS B ON A.VKORG = B.VKORG

GROUP BY A.PERIO, A.VKORG ORDER BY A.PERIO;

while previewing the data I'm receiving  an error "column store error search table error 9 memory allocation failed".

Earlier I have created an scripted calculation view by joining two analytic views and it came of successfully... But his one I'm trying to join both Analytic and Attribute view.

Could anyone explain me why I'm getting this error?

[former_member183326]

Hello Ashok,

1: What entries are seeing in the indexserver trace files?

2: This means you are hitting a out of memory error.

3: Do you have a limit currently on SQL executions?

4: What revision of HANA are you running?

Kind Regards,

Michael

[Former Member]

Hello Michael,

1. I'm not receiving any index server trace files. I'm receiving this error while previewing the Calculation view, not while activating and validating.

2. Could you please explain me how to check the SQL executions.

3.And I'm using HANA 2.0.7

[former_member183326]

Hello,

So could you attach the latest indexserver trace file? You are running out of memory whilst previewing the data. Note 1999997 will explain the SQL limits to you. Also what HANA Revision are you using, ie: 85.03, 97.03, etc?

BR

Michael