SAP Knowledge Base Article - Preview

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

Symptom

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: ')'


Read more...

Environment

SAP S/4HANA

Product

SAP S/4HANA all versions

Keywords

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

About this page

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

Search for additional results

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