Transform map of CMDB data Import taking forever!!!!!

vk_tripper
Tera Contributor

I'm using import sets to load and transform data in our CMDB. The data loads pretty quickly but the transformation process takes a very long time (sometimes more than a day and hence overlaps with the next daily load) because of all the business rules that run on the cmdb. What is the effect of not running the business rules in a transform map?  Are there any specific recommendations you'd want to share on how to speed up this process without giving up the benefits of running business rules upon transformation of data? How do I identify which business rules are taking longer than others to process?

1 REPLY 1

Nayan Mahato
Tera Guru

Hi vk_tripper,

If you have to load the data for a specific CMDB class please use that specific class as a target table.

When "Run Business Rule" is checked, business rules and workflow with other engines are triggered on the target table. We do this to do some additional validations on the target table.

For Example: If you want to check for duplicate serial numbers getting inserted, we will write a before insert business rule and then can avoid insertion if the serial number is already present in there. Thanks.

 

For large imports (10,000 to 100,000), it is advised to disable business rules. 

 

Please gro through with below KB article for determining if a business rule is running on top of the transform map. Thanks.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0538161 

 

Regards,

Nayan