Aggregation Count does not work in some cases

[Former Member]

Hi All,

The Aggregation count is giving error in some cases and i some cases it is not,

Requesting help in understanding why this is happening, Is this a bug related to SAP HANA? (I am using SAP HANA revision 60)

or is this error due to the SQL Query?

or Any other possibility?

select	a11.CUST_REGION_ID  ,
	count(a11.CUSTOMER_ID)
from	"_SYS_BIC"."Analytic view_1"	a11
	join Table_1 pa12
	on	(a11.ORDER_ID = pa12.ORDER_ID_2)
where	a11.ORDER_ID < 100000
group by	a11.CUST_REGION_ID;

select	a11.CUST_STATE_ID ,
	a11.GENDER_ID  ,
	count(a11.CUSTOMER_ID)
from	"_SYS_BIC"."Analytic view_1"	a11
	join Table_1 pa12
	on	(a11.ORDER_ID = pa12.ORDER_ID_2)
where	a11.ORDER_ID < 100000
group by	a11.CUST_STATE_ID,
	a11.GENDER_ID;

Result:

Could not execute 'select a11.CUST_REGION_ID , count( a11.CUSTOMER_ID)  from ...' in 2.886 seconds .

SAP DBTech JDBC: [2048]: column store error: search table error:  [6900] Error executing physical plan: exception 6900:

AttributeEngine/Parallel/Aggregation.cpp:4793

Attribute engine failed; $function$=createAggregators; $message$=invalid keyfigure SCHEMA1:_SYS_SPLIT_ORDER_FACT~1en CUSTOMER_ID@count@

,in executor::Executor in cube: _SYS_BIC:SCHEMA/ORDER_FACT_HANA_AN/olap

Statement 'select a11.CUST_STATE_ID , a11.GENDER_ID , count(a11.CUSTOMER_ID)  from ...'

successfully executed in 3.115 seconds  (server processing time: 3.084 seconds)

Fetched 96 row(s) in 47 ms 29 µs (server processing time: 0 ms 313 µs)

Thanks,

Gayathri

Message was edited by: Tom Flanagan

[Former Member]

What happens if you put table Table_1 into the Analytic View?

Also go ahead and and update HANA, Rev.60 is very old by now.