3469407 - Error with BW Query using Characteristic /ERP/PROFTCTR

There are below possible symptoms.

1. When inputting data in a BW Planning Query and clicking "Save Data" or "Recalculate", error occurs.
   • Critical error during characteristic derivation (BRAIN 240)
   • Derivation: Characteristic value XXX for /ERP/PROFTCTR characteristic does not exist (RSPLS_CR 010)
      
2. When doing input help on characteristic /ERP/PROFTCTR for a BW Query, error occurs:
   • Instantiation of calculation model failed;exception 306002: An internal error occurred (DBMAN 099)
   • "SAPS4H_RT_7937"."sap.erp.sfin.co.pl::FCO_C_PROFIT FM Name = TREX_DBS_AGGREGATE] (DBMAN 099)
   • Error 34.023 has occurred in the BWA/SAP HANA server (DBMAN 901)

In the indexserver trace, there is error like this:

• Failed to convert SQL expression "to_date("DATAB") <=to_date('<date>') and to_date("DATBI" >=to_date('<date>')" to column store expression at node "PProfitCenter". Reason: Evaluation of expression failed.;Failed to parse the expression: expected token: ')'

SAP S/4HANA

BRAIN240, BRAIN-240, RSPLS_CR010, RSPLS_CR-010, FCO_C_PROFIT_CENTER, DATBI, F4 help, LOV, value help , KBA , BW-PLA-IP , Integrated Planning , CO-FIO-OM-PL , Planning , BW-BEX-OT-F4 , MasterData read services , Problem