Skip to Content
Former Member
Apr 03, 2014 at 03:31 PM

Exception when combining COUNT() with CONTAINS() (TextSearch), not possibly?


Dear all,

Keep on running into the following exception:

[34021] Invalid query;Textsearch not supported on calcIndex

One of the SQL statements that is giving me an head-ache:

SELECT "BasicMaterial" AS "individual_BasicMaterial" , COUNT(*) AS "count"

FROM "_SYS_BIC"."sap.hba.ecc/MaterialBasicData"

WHERE "SAPClient" = '800' AND CONTAINS( "BasicMaterial", '%A% OR %B% OR %C% OR %D%' )

AND ( "BasicMaterial" != 'STAHL' ) AND ( "MaterialType" != 'AEM' ) AND ( "MaterialType" != 'ROH' ) GROUP BY "BasicMaterial"

The complete exception in the trace file is: : unexpected excpetion at remote: code=2048(ltt=false), error=column store error: search table error: [34021] Invalid query;Textsearch not supported on calcIndex.

Another permutation I implemented using intermediate local temp table.

Does anyone have an hint how to attack this? I already tried to used CE_ calc plan operators but as far as I know I cannot make those dynamic, more precise I have to generate a SQLscript procedure for every view as it is not possible to set the table using an input param (scalar.....).

Kind regards,