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 , Dictionary & Consistency checks 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.