Error log from IntegrationHub ETL import results

[kris29]

Hi,

I use IntegrationHub ETL to import data into cmdb_ci_ot_isa_entity.

All records are inserted but a number of records have an error after import.

Can someone explain what is missing here?

error log

Identification Reconciliation Engine(IRE) Processing errors-> 1: In payload missing minimum set of input values for criterion (matching) attributes from identify rule for table [cmdb_ci_service]. Add these input values in payload item '{"className":"cmdb_ci_ot_isa_entity","values":{"discovery_source":"SG-Equipment Model Excel Import"},"internal_id":"9719aa666b4d41103536fd8f0b19e03a","sys_object_source_info":{"source_feed":"SG-Equipment Model Import Using Spreadsheet","source_name":"SG-Equipment Model Excel Import"},"settings":{"updateWithoutDowngrade":"true"},"sys_ire_info":{"ire_received_time":"2022-01-15 06:30:33"},"display_values":{}}' 2: Identifier keys could not be generate based on either criterion attributes or source_name/source_native_key

[#2]

Looking at the payload in the log it appears that no values are being sent over:

{
  "className": "cmdb_ci_ot_isa_entity",
  "values": {
    "discovery_source": "SG-Equipment Model Excel Import"
  },
  "internal_id": "9719aa666b4d41103536fd8f0b19e03a",
  "sys_object_source_info": {
    "source_feed": "SG-Equipment Model Import Using Spreadsheet",
    "source_name": "SG-Equipment Model Excel Import"
  },
  "settings": {
    "updateWithoutDowngrade": "true"
  },
  "sys_ire_info": {
    "ire_received_time": "2022-01-15 06:30:33"
  },
  "display_values": {}
}

You can see that the only item in "values" is the discovery source.  There also is no "source_native_key" value in "sys_object_source_info".  The mapping to cmdb_ci_ot_isa_entity should be made conditional and check that the value mapped to "source_native_key" is not null.