SAP Knowledge Base Article - Preview

2532826 - "Column store error: search table error: [2620] executor: plan operation failed;currency/unit..." in a CDS query or Fiori App

Symptom

  • The S/4 conversion is performed with a database change. The current database schema is different from that of the source system.
  • A Fiori app failed with error:  
    Failed to load resource: the server responded with a status of 400 (error)
    The following problem occurred: HTTP request failed 400,Bad Request,......"Database returned the SQL code 2,048. Error text: column store error: search table error: [2620] executor: plan operation failed;currency/unit ..."....
  • Run the OData query in transaction /n/iwfnd/gw_client on the gateway system, failed with error:
    <code>RS_EXCEPTION/000</code>
    <message xml:lang="en">Database returned the SQL code 2.048. Error text: column store error: search table error: [2620] executor: plan operation failed;currency/unit ...</message>
    ...
    <code>/IWBEP/CX_MGW_BUSI_EXCEPTION</code>
  • Run the CDS query in transaction RSRT on the backend BW system (usually S/4HANA system), hit exception of:
    Object Collapsed Database returned the SQL code 2.048. Error text: column store error: search table error: [2620] executor: plan operation failed;currency/unit ...
    Error message Object Collapsed sion error,could not read currency precisions from table "XXX"."TCURX" - invalid schema name: XXX: line 1 col 33 (at pos 32) at ...
    Error message Object Collapsed ...../workspace/..../s/ptime/query/che cker/check_clause.cc:5332
    Error message Object Collapsed Error reading the data of InfoProvider 2CXXXX
    Error message Object Collapsed Error while reading data; navigation is possible
    Information Message Object Collapsed CL_RSDRS_SQL_QUERY_OSQL_EXT >> Row: Inc: 48 Prog: _FETCH_DATA_OPENSQL

Read more...

Environment

  • S/4HANA 1610
  • SAP NetWeaver 751
  • SAP NetWeaver 750 SP4 and above

Product

SAP NetWeaver 7.5

Keywords

CX_SY_OPEN_SQL_DB , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , HAN-DB , SAP HANA Database , BC-DB-HDB-POR , DB Porting for SAP HANA , How To

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.