SAP Knowledge Base Article - Preview

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

Symptom

  • 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]''


Read more...

Environment

SAP BW

SAP HANA Database

Product

SAP BW/4HANA 2.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.