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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.