Symptom
A transaction involving unit or currency conversion fails in the below error
- Work process trace dumps in error in ST11 :
C Thu Oct 21 07:09:21:240 2021
C *** ERROR => execute() of C_0328, #rec=0, rc=1, rcSQL=719
[dbsdbsql.cpp 2315]
C {root-id=36313731344130343631373134413034}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => EXECUTE C_0328 on connection 0, rc=719
[dbslsdb.cpp 10037]
C SQLCODE : 719
C SQLERRTEXT : currency/unit conversion error: search table error: Conversion( "COL$4$", "COL$5$", "COL$19$", "COL$\
C 20$", "COL$21$", "COL$22$", "COL$23$" ), row 141: could not determine valid conversion rate for valu\
C e(s) 0, 0, 0, 0, NULL, 0, 0 from unit '' to unit '' for client '200' because of an error during rate\
C lookup: both empty source & target unit are not allowed
.......................
B ***LOG BY4=> sql error 719 performing PRE on table /<table_prefix>/<schema>/<table_name> [dbdbslst 5212]
B ***LOG BY0=> currency/unit conversion error: search table error: Conversion( "COL$4$", "COL$5$", "COL$19$", "COL$20$", "COL$21$", "COL$22$", "COL$23$" ), row 141: could not determine valid conversion rate for value(s) 0, 0, 0, 0, NULL, 0, 0 from unit '
- RSRT transaction may return a similar error to the following :
Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( "COL$5$", "COL$7$", "COL$58$", ...
Error message Object Collapsed $", "COL$60$", "COL$61$", "COL$62$" ), row 0: could not determine valid conversion rate for value(s) 5, 5, 0, 0, NULL, 0, 5 from unit 'CS' to ...
Error message Object Collapsed ' for client '200'
Error message Object Collapsed Error reading the data of InfoProvider <InfoProvider_ID>/<table_prefix>/<name>
Error message Object Collapsed Error while reading data; navigation is possible
Information Message Object Collapsed CL_RSDRS_SQL_QUERY >> Row: Inc: 48 Prog: _FETCH_DATA_OPENSQL
Read more...
Environment
SAP HANA, platform edition
Product
Keywords
SQLCODE : 719, SQL code 719, performing PRE on table , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.