Symptom
When running a CDS Query with a currency_conversion function an error such as the follows occur:
Error Database returned the SQL code 2,048. Error text: column store error: search table error: [2620] executor: plan operation failed;currency/unit ... Error sion error,Conversion( "COL$8$", "COL$9$" ), row 760: could not determine valid conversion rate for value(s) 41.34, 41.34 from unit 'CNY' to unit ... Error ' on date 2017-09-12 00:00:00.0000000Error Error reading the data of InfoProvider 2CCMMSPLRCMPURVAL2 Error while reading data; navigation is possible Information CL_RSDRS_SQL_QUERY_OSQL_EXT >> Row: Inc: 48 Prog: _FETCH_DATA_OPENSQL |
In the indexserver logfile of HANA database more detailed information related to the error is written(Transaction DBACOCKPIT. The file starts with indexserver_alert_ (path: Diagnostics -> Diagnosis Files))
PlanExecutor.cpp(00872) : pop1 (rc 2048, search table error: |
In some case a BRAIN 380 error message is visible in the ODATA Response or when testing the CDS query in RSRT:
- BRAIN 380: No echange rate from <...> to <...> and date <...> found
Read more...
Environment
-
SAP Netweaver 7.5
-
SAP BW/4HANA
- SAP S/4HANA
Product
Keywords
ECC, FIORI, CURRENCY, CURR, TCURR, C_SALESVOLUMEBYYEARQUERY_CDS, CDS view, BRAIN380, BRAIN 380, currency issue, F1905 , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , HAN-DB-CDS , SAP HANA Activation of HDBDD-files (CDS Definitions) , BC-DWB-AIE-DIC , Tools in Eclipse for Data Dictionary (without CDS) , BC-SRV-BSF-CUR , Currency translation / Expiring currencies , SD-FIO-HBA , Analytical Apps , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , MM-FIO , Fiori UI for Materials Management , 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.