How to find why record is not inserted or updated

[Vidya Shree]

Hi All,

I am working on SCCM integration using Service Graph Connector. A few records are present in the import set table but not inserted into the CMDB table after it is processed. I don't know where we can see why the record is not inserted.

Has anyone faced this issue? Can anyone help to find out where the issue is?

Thanks,

Vidyashree

[suvro]

Check the transform map and the data in the import table you will understand the reason may be coalesce field does not exists and it is getting skipped or due to transform scripts it is getting ignored. Or there is no change in the record hence ignored

[#3]

The comments and error fields on the import set table should give you a starting point.

I would recommend installing the IntegrationHub ETL application.

Once you have that installed you can use it to debug issues.  To bring the scope of records down I would recommend doing the following:

1. Insert and Stay on the import set you are having issues with
2. Update the import set field of any records that you are seeing an issue with to the new import set from step 1
3. In the IntegrationHub ETL select the new import set in step 1

From there you can reprocess your import set and see detailed logging information in the preview step within the IntegrationHub ETL.

[Vidya Shree]

Hi,

Thank you for your reply.

Can you please explain step 3 in detail?

How do I select the import set in integrationHub ETL?

[#5]

It's step 1 once you have picked your data feed: