SAP Knowledge Base Article - Preview

3132788 - currency/unit conversion error: because of an error during rate\ lookup: both empty source & target unit are not allowed

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

SAP HANA, platform edition all versions ; SAP S/4HANA all versions

Keywords

SQLCODE    : 719, SQL code 719 , 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.