3748673 - Extraction job fails in Process Intelligence - Error obtaining value 'X' for column 'Y'. Failed to convert to datatype: 'decimal'

Extraction job is failing in Process Intelligence.

Error displayed:

"Error obtaining value 'X' for column 'Y'. Failed to convert to datatype: 'decimal'

Original Exception: Error parsing decimal value"

• Product: SAP Signavio Process Intelligence
• Data Source: SAP ERP connector (RFC)

A character used as a column delimiter is actually a part of the data in the table.

For example, the tilde "~" character is the column delimiter. Where a table contains a tilde "~" character, the information after the tilde in the cell is pushed into the next column to the right and the information in all subsequent columns of that row is pushed one column to the right.

1. Open the SAP ERP (RFC) data source connection configuration in Process Intelligence.

2. To replace the character used as the column delimiter, add the following argument in the Extra connection arguments field in the SAP ERP (RFC) connection:

   ReadTableDelimiter=<Delimiter character>

   For example, ReadTableDelimiter=§

3. Save the configuration and re-run the extraction job.
4. If the issue persists, collect ETL logs (pi-etl-adapter.log and extractor.log) from the etltmp/logs directory and review or share them with support as described in the referenced note.

Refer to: 

• SAP Help | Tilde "~" Acting As Delimiter on Extracted Table
• SAP Note 3465993 - Capturing etltmp logs directory in Process Intelligence

extraction job fails, process intelligence, sap erp connector, rfc connection, s/4hana, table extraction, bsak, bsik, bsad, connection parameters, connection arguments, etl logs, pi-etl-adapter.log, extractor.log, delimiter, column delimiter , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , How To