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

• 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

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

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 , Dictionary & Consistency checks for SAP HANA , How To