SAP Knowledge Base Article - Public

3594910 - Number values of '0' or '0.000' are being imported as NULL

Symptom

When I import data into Process Intelligence via an individual table extraction or Process Data Pipeline ETL run, values which are '0.000' or '0' in my source system are being shown as NULL.

Cause

It may be caused by a known bug in SAP's RFC user settings. If the language is set to 'US' for the connected user, numeric values of '0.000' or '0' may be imported as NULL into Process Intelligence.

Resolution

To ensure this does not happen, please ensure that you have the following required SAP NOTE installed on your source system: 

3297175 - RFC_READ_TABLE | type handling for option USE_ET_DATA_4_RETURN

Keywords

process, intelligence, source, system, null, 0, import, extract, value , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Known Error

Product

SAP Signavio Process Intelligence 3.0