Symptom
- 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].) - 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