Error log from IntegrationHub ETL import results
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-17-2022 11:57 AM
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
|
Labels:
- Labels:
-
Data Foundations
-
Service Graph
1 REPLY 1
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-18-2022 05:54 AM
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.