SAP Knowledge Base Article - Public

3597252 - Error during extraction in SAP Signavio Process Intelligence due to datatype mismatch Failed to Convert to Datatype: 'date'

Symptom

Extraction Job failed in using template Invoice to Cash with the message "Error processing field at index 16 (type 91 value 'Not Available (Error obtaining value 'XXXXXX' for column 'XXXXX'. " 


Environment

SAP Signavio Process Intelligence

Reproducing the Issue

Extract using the template Invoice to Cash in SAP Signavio Process Intelligence.

Cause

The error is caused by invalid date format. The date must be in the ISO-8601 format. 

Resolution

Add the following argument in the Extra Connection Arguments field on your connector configuration screen and then extract data.

ReplaceInvalidDatesWithNull=True

See Also

For reference, please refer to the following Help Documentation: Failed to Convert to Datatype: 'date' 

Keywords

SAP Signavio Process Intelligence, extraction, template, Invoice to Cash, error, schema, datatype mismatch, table, field. , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Bug Filed

Product

SAP Signavio Process Intelligence all versions