While running RTM, the import records are showing as processed but not transformed to target table

[Mounica6]

Hello Everyone,

We are using Robust Transform Maps for Intune Integration through the Service Graph Connector and while running the scheduled imports for devices, the import set shows that all the records are processed and also available in the Staging table but, records are not being transformed to Target table. We didn't modify any OOB data sources and transformer definition. 

When I've checked for the import log it's empty but, when checked the import set rows, I found something in the comments field which says - 

"{"sn_intune_integrat_device_related":{"mergedPartialPayloads":1,"partial":1},"cmdb_sam_sw_install":{"mergedPartialPayloads":1,"partial":1},"cmdb_ci_network_adapter":{"mergedPartialPayloads":1,"warnings":1,"partial":1},"cmdb_serial_number":{"incomplete":1,"errors":1},"cmdb_rel_ci":{"warnings":2,"partial":2},"cmdb_ci_ip_address":{"mergedPartialPayloads":1,"warnings":1,"partial":1},"cmdb_ci_handheld_computing":{"mergedPartialPayloads":1,"warnings":1,"partial":1}}" 

Can anyone help me with the inputs, please?

[GlideFather]

Hi @Mounica6,

it seems that the incoming values might be the same as existing ones, because the first picture says "Updated: 0, Inserted: 0"... is there any chance to verify this?

If it's not PROD, export the existing data, remove or update (at least 1 record) and then perform the transformation again. Then you will see whether it will update the one touched record or if it still be 0 and 0...

With that, you shall be able to see if the transformation works or not.

[Mounica6 · Accepted solution]

@GlideFather Thanks for your response.

We had found a fix for the problem. I don't know if this is the exact solution, but it has worked for us.

Below is the process,

1) After the records were processed, they were moved to the CMDB IRE Partial Payloads table (this refers to an incomplete data payload that, due to missing or non-existent referenced configuration items (CIs), cannot be fully processed or merged at that moment).

2) I have copied the payload from the above table and found a few errors in the payload

3) I searched for the errors in the IRE error messages and rectified them (errors were  IDENTIFICATION_RULE_FOR_RELATED_ITEM_MISSING)

4) Then, I deleted the records from the CMDB IRE Partial Payloads table (as it may cause performance degradation due to a huge number of records) and reprocessed the Import set. And, the data was transformed into the target table.

 

[GlideFather]

Oh yeah @Mounica6! Great that you found it!