SCCM Populates - Error during update of cmdb_ci_computer / Error during insert of cmdb_ci_computer

[ersureshbe]

Hi,

I'm trying to implement the SCCM with the help of Service Graph. The following actions taken and I can connect the SCCM database.

1. Installed the SG- Graph plugin

2. Enabled the set up and tested the connection. It's success.

3. In Data Source, disabled the 'Robust Transformer' and Manually created the transform map and completed the field mapping.

4. Serial number field sets as coalesce and acting as unique id.

5. Schedule import configuration completed and CI's are coming to the 'sn_sccm_integrate_sccm_2019_computer_id' import set table. I configured the transform map and it;s working as expected. i.e, when name field mapping is not configured then it's working fine. If configured it will throw an error as 'Error during update of cmdb_ci_computer / Error during insert of cmdb_ci_computer' eitheir one error depends the insert or update.

I can see cmdb_ci_computer table sets the name field as 'Mandatory'. I tried to change as non-mandate and checked the transaction still producing the same error. There is no script configured in the import set table. I just configured one to one field mapping.

Can you help me how to resolve the error?

Regards,

Suresh.

[emir]

Why are you disabling robust transformer?

Without knowing how you have mapped it and how you coalesce we can't help you. How are you using the correlation id?

[ersureshbe]

Emir,

Source table is having the field and the same field is present in cmdb_ci_computer table. I have configured the fieldmapping manually. I explained the steps above. 

I'm not sure whats wrong in it?

Regards,

Suresh.

[CMDB Whisperer]

You are using this incorrectly.  I suggest going back to the beginning, reverting everything you have done and starting over.  You should not disable Robust Transforms as they are the only way to ensure your integration is using the Identification and Reconciliation Engine (IRE).

IRE does not use transform maps or coalesce fields.  It uses identifier entries, of which serial number is already the preferred entry for all hardware CIs, so you don't need to change anything there.

You should not make your Name field mandatory.  You should undo this setting and in general should never make CI fields mandatory!  Rather, you should use recommended fields and measure your conformance via the Recommended metric in CMDB Health.  Making fields mandatory at the dictionary level will cause your IRE-based and other integrations to fail to update records if those fields are empty.  So best practice is, if you are trying to make a field mandatory during data entry when using a form, use UI Policies to do this instead, and allow the data to come in from external data sources unimpeded.

All ServiceGraph Connectors use the IRE and Robust Transform Engine to integrate CMDB Data Sources.  This is the only way you should import data into the CMDB.  If you need to modify the mapping or other logic in those integrations you should only do so using the IntegrationHub ETL application (free plugin).  This is the methods that users can use to interact with and modify Robust Transform Entries, which you should typically not modify directly unless you have expertise in that area.  That said, nothing in your description suggests that you have a justifiable case for modifying Service Graph Connector for SCCM.  The out-of-box plugin should work fine.  The only problem you have is that your Name field is mandatory, which it shouldn't be.

TL;DR - Revert to out of box SG-SCCM and remove the Mandatory flag on the Name field and you should be fine (unless there are other customizations not mentioned here.)

[Arturo]

Graph Connectors introduced Robust transform map and Flow designer. Let the robust transform be there available. Use the schedule data import , last step when setting the graph connector to test the settings for your SCCM_GC including the mappings part.