SAP DBTech JDBC: [2048]: column store error: search table error: [2994] general search engine error

[Former Member]

Hi,

We've been getting General Search Engine Error [2994] from HANA studio when tried to do run a select statement on a particular measure which comes out of a temp table.

While there is lot of inputs about column Store Error in community, i couldn't find anything specific to General Search Engine Error [2994].

Any help would be greatly appreciated.

SELECT "Column_A", SUM("Column_B") as "COL_B"

FROM "_SYS_BIC"."Schema.hana_calc_view" 

group by GROUPING SETS WITH SUBTOTAL STRUCTURED RESULT WITH OVERVIEW PREFIX

'#BICS_1465741408717_' ((("Column_A") ORDER BY "Column_A" ASC ))

SELECT "attribute", "table no", "values" FROM "#BICS_1465741408717_0"

SELECT  "Column_A"  FROM "#BICS_1465741408717_1" -- Works fine

SELECT  "Column_B"  FROM "#BICS_1465741408717_1" -- Throws error

//SAP DBTech JDBC: [2048]: column store error: search table error:  [2994] general search engine error

[former_member183326]

This error generally points to a memory issue. What SAP notes have you searched?

[varma_narayana]

Hi,

In your temp table, you have named the column as COL_B.

SELECT "Column_A", SUM("Column_B") as "COL_B"

Hence you need to use the same in the SELECT (as given below).

SELECT  "COL_B"  FROM "#BICS_1465741408717_1"

Please check if that works..

regards,

Varma