Identification Reconciliation Engine(IRE) Processing errors - SGC for Microsoft Intune

[ponranjitham]

Hi,

We are receiving below error in Import Log for "SG-Intune Computer" Data Source. 

Identification Reconciliation Engine(IRE) Processing errors->
1: INSERT_FAILED: Insertion failed with error: Commit was not attempted due to other errors
2: INSERT_FAILED: Insertion failed with error: Commit was not attempted due to other errors
3: Insertion failed with error: Error occurred during commit

And below error in Import Set Rows.

{"cmdb_sam_sw_install":{"mergedPartialPayloads":1,"incomplete":3,"errors":3},"cmdb_ci_computer":{"mergedPartialPayloads":1,"incomplete":1,"errors":1},"cmdb_ci_network_adapter":{"mergedPartialPayloads":1,"incomplete":1,"errors":1},"cmdb_serial_number":{"mergedPartialPayloads":1,"incomplete":4,"errors":4},"sn_intune_integrat_computer_related":{"mergedPartialPayloads":1,"incomplete":1,"errors":1},"cmdb_rel_ci":{"incomplete":2,"errors":2},"cmdb_ci_ip_address":{"inserted":1}}

No errors when i tried to test that payload in "Identification Simulation". Please help me to find out what is causing the issue.

Thanks.

[AJ-TechTrek]

Hi @ponranjitham 

When there is an identification error like this, their is usually required attributes missing in the payload.  You need to get the identification payload from the error message and try it with the identification simulator (Configuration -> Identification Simulation).  It will reproduce the error and you can see where in the payload that it is failing.  cmdb_ci_computer depends on some hardware to be inserted successfully (cmdb_ci_hardware or cmdb_ci_computer ) You probably have some required attribute values missing or possibly something is wrong with the payload.

Also check the configured IRE rules for Computer class as well as other classes for which you are pulling data from Intune

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[Cindy Trieu]

Hi @ponranjitham, 

Try to get the payload that is getting sent to the IRE. This import set row is not exactly what will be sent. You will have to turn on logging, run the import set again, then look in your system logs for the payload which will be logged by the source identification_engine. Check out this KB for precise steps: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0750382

After you get the payload from the logs, try that payload in the Identification Simulation again. It might have new logs. If that does not work, let me know and we can try further steps.

[ponranjitham]

Hi Cindy,

I tried above solution and i can see below errors also in logs.

1. identification_engine : logId:[4f994edf1b28] Detected error while processing payload from SG-Intune. Using options: {partial_payloads:true,partial_commits:true,deduplicate_payloads:true,generate_summary:false,include_internal_id_in_output:false,dynamic_ire_engine:false}

2. identification_engine : logId:[4f994edf1b28] PartialPayloadProcessor::mergeRelations - No target child found in rel - {"parent":0,"child":0,"parent_id":"5df77b28b3e8465856c8ccdc73ccf404","child_id":"ddf77b28a8e84658ea3b15f6345fc504","type":"Owns::Owned by","sys_rel_source_info":{"source_feed":"SG-Intune Computers","source_name":"SG-Intune"}}

Thanks.

[Cindy Trieu]

Okay so it is trying to merge the payload with a partial payload you have. There should be a related input= and output= log near the same time stamp as these records. Do you see such logs?