Integration hub ETL mapping Records not updated for few attributes.

[Deep Singh]

We are experiencing an issue with our Integration Hub ETL mapping where the  Vendor fields are not being populated .

The vendor field is mapped to its correct source on the ETL mapping 

When I delete all my records on the table and insert it , the field values shows but I cannot delete the existing data.   When I try to update with a new data source or imports, then some of the fields value does not get updated and shows as empty even though that field have values on them. 

Any help will be appreciated.

[Kieran Anson]

This could be a couple of things

1. Reconciliation Rule - Your data source isn't allowed to overwrite the field. 

2. Source Recency - ServiceNow won't attempt to update a record if it's had data passed with a more recent timestamp. I don't think it's this option as your ETL mapping doesn't have source recency timestamp populated.

Have you checked on whether cmdb_ci_spkg as any reconciliation rules for your discovery source? 

[Deep Singh]

Hello Kieran, Thank you for your response.

1)  I do see there are three Reconciliation rules but they are not tied to the vendor field not showing because I deactivated to try and the vendor field still showed empty.

Source Recency we do not have anything mapped 

Thank you 

[asifnoor]

Hello @Deep Singh  Did you find the fix for this? I am also facing similar issue. 

[Damhoej]

Try to transform your vendor data with a "Cleanse Company" transform.
That way you make sure you have the correct data/sys_ID.