3621798 - Error ' Failed to convert to datatype: 'string'. The original datatype of the column is: 'long'. ' during extraction in Process Intelligence

You face an error like the one below during a table extraction from an SAP source system using an RFC connection type:

Detail: {"message":"Exception caught, caused by: Preview request failed with (Error obtaining value '9.921.199' for column '<column_name>'. Failed to convert to datatype: 'string'. The original datatype of the column is: 'long'. Original Exception: Error parsing long value [9.921.199].)

It looks like in your SAP source system, the table <table_name>, column <column_name>, contains a non integer number. 
The data type 'Long' is a type of integer and therefore cannot include any decimal points.
As during the extraction, the value '9.921.199'  is extracted where a non decimal whole number was expected, the error shown is thrown.

Please investigate why in your SAP source system, the column in question contains such a value. If it is a once off or rare occurrence, you can add the following extra connection argument to your Connection setup:

ReplaceInvalidTypesWithNull=True 

If however there are many occurances of decimal values in this column, an internal SAP BASIS Team investigation will be needed to find the root cause.

process, intelligence, long, integer, string, fail, convert, obtaining, value, column , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Known Error