3262051 - "NULL" value was extracted from ERP table when the field has a value "00:00:00" - SAP Signavio Process Intelligence

When extracting the data from SAP ERP system via SAP ERP connector, the table field with a value '00:00:00' was extracted to Process Intelligence as "NULL".

Example: 
In ERP table VBFA, there is an entry which the field ERZET has a value ''00:00:00"

After the data has been extracted to Process Intelligence, the field ERZET value is missing for this entry

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Signavio Process Intelligence

Something wrong with the data type when extracting data from SAP ERP。

To fix the issue, we have introduced a new property "InitialValueMode".

By default the value of this property is "InitialValueMode=Null", to make it work, please add "InitialValueMode= InitialValue" to the Extra Connection Arguments in the ERP connector.

And please update the On-Premise Extractor to the latest version if you are using On-Premise Extractor.

https://cdn.cdata.com/help/RYH/jdbc/RSBSAP_p_InitialValueMode.htm

SAP Signavio Process Intelligence, NULL, InitialValueMode, Connector, SAP ERP，ERZET , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , Problem