CMDB Import - Asset Record Created but CI Not Created for Certain Classes (Suspected Model Category

[pallavishah]

Hi Community,

I'm facing an issue while importing CMDB data from Excel into ServiceNow and would appreciate any guidance.

Environment

• Importing CI data from multiple Excel files (different CMDB classes).
• Using Import Sets and Transform Maps.
• Target tables is alm_hardware

Issue

When I run the import:

• The Asset record is created successfully.
• The CI reference field on the Asset record gets populated.
• However, the actual CI record is not created in the target CMDB table. Searching by Serial Number or Sys ID in the target CI table returns no record.

What I've Checked

• Verified the Import Set completed successfully.
• Verified the Transform Map mappings.
• Confirmed mandatory fields are mapped.
• Checked transform logs for errors.
• Waited to ensure it wasn't an asynchronous CI creation process.
• Verified the Asset record is created and linked to a CI sys_id, but no corresponding record exists in the CMDB class table.

Current Suspicion

We suspect the issue may be related to the Model Category configuration.

So we added/updated the Product models (mentioned in the excel file)  in the model category 

Questions

• Has anyone encountered a similar issue where the Asset is created but the CI is not?
• Can an incorrect Model Category cause this behavior?
• Are there any specific logs or IRE diagnostics that should be checked to determine why the CI is not being inserted?
• Is there any configuration related to Model Categories, IRE, or duplicate validation that I should verify?

• Any lead and configuration would be appreciated asap as this is urgent.

Any suggestions or troubleshooting steps would be greatly appreciated.

Thank you!