2800044 - BW query execution fails with "type error in expression evaluator" error message.

• Composite provider built on HANA calculation view with direct mappings.  
• Running Bex query gives the following error:

Evaluator: type error in expression evaluator;Evaluator: type error in expression evaluator;[here]rtrim("/B631/S_CATEGORY", 4) = ...
Error 'PLAN',D00::SAPABAP1:/B631/SCATEGORY (t 57718),BwPopSearch pop3(D00::SAPABAP1:/B631/SCATEGORYen): calcEngine ...
Error search on olapIndex failed.,QueryId: 003YPWXSKUJS8NUEEHN5YG8JU:MINE/[Request Info: Object Name = "SAPABAP1"."0BW:BIA:ZXX_XXXXX", FM ...
Error Name = TREX_DBS_AGGREGATE]
Error Error 6.970 has occurred in the BWA/SAP HANA server
Error Error reading the data of InfoProvider ZXX_XXXXX$X
Error Error while reading data; navigation is possible
Information CL_RSDRH_TREX_STORAGE >> Row: Inc: 114 Prog: MAP_TREX_EXCEPTION

• Index server trace shows the following: 

66707]{321244}[19/-1] 2019-05-27 12:37:13.107681 e expr ExpressionTree.cpp(02242) : type conflict: can not find code for node 2, in addConversions(), tree: node 4 TK_EQ, type VALUE_CLASS_UNKNOWN
node 2 TK_RTRIM_FUNCTION, type VALUE_CLASS_UNKNOWN
node 0 TK_ID, 'CATEGORY', type VALUE_CLASS_STRING(10), variable type VALUE_CLASS_STRING(10)
node 1 TK_CONSTANT, '4', type VALUE_CLASS_INT
node 3 TK_CONSTANT, 'PLAN', type VALUE_CLASS_STRING
[66707]{321244}[19/-1] 2019-05-27 12:37:13.107718 e expr Evaluator.cpp(00362) : addConversions failed with Evaluator: type error in expression evaluator;[here]rtrim("CATEGORY", 4) = 'PLAN'(6970)
node 4 TK_EQ, type VALUE_CLASS_UNKNOWN
node 2 TK_RTRIM_FUNCTION, type VALUE_CLASS_UNKNOWN
node 0 TK_ID, 'CATEGORY', type VALUE_CLASS_STRING(10), variable type VALUE_CLASS_STRING(10)
node 1 TK_CONSTANT, '4', type VALUE_CLASS_INT
node 3 TK_CONSTANT, 'PLAN', type VALUE_CLASS_STRING
[66707]{321244}[19/-1] 2019-05-27 12:37:13.107745 e trex_qo Evaluate.cpp(01282) : searchDocuments failed; rc: 6970 (Evaluator: type error in expression evaluator); table: D00::SYSTEM:tempindex_qe_FA84B20012900848BC8A7D287EE2CDF0_90627 (t 4618441417896115831); column: CATEGORY(201)
[66707]{321244}[19/-1] 2019-05-27 12:37:13.107770 e trex_qo OptimizerImpl.cpp(00555) : evaluate failed; rc: 6970 (Evaluator: type error in expression evaluator); table: D00::SYSTEM:tempindex_qe_FA84B20012900848BC8A7D287EE2CDF0_90627 (t 4618441417896115831); query: [0]PRED: CATEGORY(0):'rtrim("CATEGORY", 4) = 'PLAN''[EQ]''

SAP BW

SAP HANA Database

wrong, rtrim, failed , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , Problem