Error in Transform Map while creating assets and CI

SKum
Kilo Sage

‎03-07-2025 11:35 PM

Hello all, 

 

I am having issue when creating  assets in alm_hardware table when assets are created.

Here is the scenario, we receive asset data from external system into a import set able and from there i have a transform map to map data from import set table to alm_hardware table, All the mandatory fields are available including asset tag, serial number, category, model etc when the data is transformed i see this error "Operation against file 'alm_hardware' was aborted by Business Rule 'Create CI on insert^1fb8e78b97446e9467a0bce3a253afcb'. Business Rule Stack:Create CI on insert".

 

Why am i getting this error? also i noticed CI are created in cmdb_ci table but assets are not created in alm_hardware table due to this error

 

TIA

0 Helpfuls
  • 571 Views
2 REPLIES 2

J Siva
Tera Sage

‎03-08-2025 01:11 AM

Hi @SKum 

You can see the root cause of the issue from the error log.

Check the business rules "Create CI on insert" ..

0 Helpfuls

Viraj Hudlikar
Tera Sage

‎03-08-2025 01:19 AM

Hello @SKum 

 

This rule is designed to create a Configuration Item (CI) in the CMDB whenever a new asset is inserted into the alm_hardware table. The error you're seeing indicates that this Business Rule is being triggered but is failing, which prevents the asset from being created in the alm_hardware table.

Ensure that the Model field in your import set is correctly populated. If the Model field is blank or contains invalid data, it can cause the Business Rule to fail.

Verify that the "Create CI on insert" Business Rule is correctly configured and has not been modified. Sometimes, customizations or updates to the Business Rule can cause unexpected behavior.

Check the data being imported for any inconsistencies or missing mandatory fields. Ensure that all required fields, such as asset tag, serial number, category, and model, are correctly populated.

 

Check this KB article - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1002894

 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.