3628969 - Error 6970 occurs when running a BW query

Following errors occur when running a BW query:
Error 6.970 has occurred in the BWA/SAP HANA server TREX_DBS_AGGREGATE 
Object Name = XXX, FM Name = TREX_DBS_AGGREGATE]  
if(isnull("XXX"), "XXX", "XXX"), "XXX"))(6970),QueryId: ...  
"XXX", "XXX" ))': Evaluator: type error in expression evaluator;int(if(isnull("XXX"), ...  
Evaluator: type error in expression evaluator; $message$=unable to create expressioncolumn 'int(COALESCE( "XXX", ...  
Errors occurred during parallel processing of query 3, RC: 3  
Error while reading data; navigation is possible  

Additionally, following errors can be seen in the index server trace: 
e expr             ExpressionTree.cpp(04307) : if or jf with different types of if and else branches not supported in node 3, in generate(), tree: node 4 TK_INT_FUNCTION, type VALUE_CLASS_INT, at 272
  node 3 TK_IF_FUNCTION, type VALUE_CLASS_STRING, at 64
    node 6 TK_ISNULL_FUNCTION, type VALUE_CLASS_INT
      node 0 TK_ID, 'XXX', type VALUE_CLASS_INT, at 128, variable type VALUE_CLASS_INT at 128
    node 7 TK_IF_FUNCTION, type VALUE_CLASS_STRING, at 0
      node 9 TK_ISNULL_FUNCTION, type VALUE_CLASS_INT
        node 1 TK_ID, 'XXX', type VALUE_CLASS_STRING, at 208, variable type VALUE_CLASS_STRING at 208
      node 2 TK_ID, 'XXX', type VALUE_CLASS_STRING, at 144, variable type VALUE_CLASS_STRING at 144
      node 8 TK_ID, 'XXX', type VALUE_CLASS_STRING, at 208, variable type VALUE_CLASS_STRING at 208
    node 5 TK_ID, 'XXX', type VALUE_CLASS_INT, at 128, variable type VALUE_CLASS_INT at 128
[10416]\{312389\}[60/4236623967] 2025-07-01 13:21:57.801684 e itab             ExpressionColumn.cpp(01124) : exception  1: no.70006970  (AttributeEngine/ExpressionColumn.cpp:1124) TID: 10416

• SAP BW/4HANA 2.0 
• SAP BW/4HANA 2021
• SAP BW/4HANA 2023

KBA , BW4-DM-HCPR , Composite Provider , BW4-AE-DBIF , DB Interface Data Manager , Problem