SAP Knowledge Base Article - Public

3622232 - Thousands separator misinterpreted as Decimal Separator when extracting or previewing via RFC connection

Symptom

  1. When attempting to Preview or Extract data from some tables using the RFC connector, an error similar to this is returned:
    Detail: {"message":"Exception caught, caused by: Preview request failed with (Error obtaining value 'n.nnn.nnn' for column 'XXXXXX'. Failed to convert to datatype: 'string'. The original datatype of the column is: 'long'. Original Exception: Error parsing long value [n.nnn.nnn].)
  2. Datetime field of type DEC is truncated. For example, value 20,250,527,125,420 which is 20250527 (Date part - 2025-05-27) and 125420 (Time part 12:54:20) but displayed in numeric form with the thousands separator. What is happening in the Process Intelligence extraction and/or preview is that the driver is implicitly casting the decimal value to int therefore dropping the part after the first comma thus retaining only 20.

Cause

This is caused when the region personas conflict.

Resolution

Add this extra connection argument to the Connection and extract/preview the table:

Other=Culture=de_DE;  

Keywords

process, intelligence, soe, error, long, string, extra, connection, arguments, culture , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem

Product

SAP Signavio Process Intelligence all versions