TRM product phase field keeps on updating the Hardware Model - Known Error

TRM product phase field keeps on updating the Hardware Model Description TRM product phase field keeps on updating the Hardware Model on every run of the schedule job: HAM - Sync TRM information

https:// .service-now.com/sysauto_script.do?sys_id=ed19cded773131106873136f1b5a9902&sysparm_record_target=sysauto

Steps to Reproduce

1. Navigate to cmdb_hardware_product_model.LIST 2. Pick any Model that doesn't have a Normalised Product 3. Check the audit of the record for field trm_product_phase, and you will see multiple entries.

Workaround The HAMTRMUtil script include is responsible for this behaviour.

The current code considers all records in TRM_PRODUCT_TABLE and tries to sync to models, but the expectation is to only consider records of TRM_PRODUCT_TABLE that have a value for the hw_product (norm_product) field. As we don't have this condition, all records are being considered, even records with hw_product null are also considered. This resulted in updating the hardware models, which have an empty normalised_product as well.

Below is the current code: var trmProdGr = new global.GlideQuery(sn_hamp.HAMTRMUtil.TRM_PRODUCT_TABLE) .toGlideRecord();

Update code with not null check on hw_product -- **add --> whereNotNull('hw_product')**. This ensures only the records with hw_product not null in TRM_PRODUCT_TABLE are considered for updating the hardware models.

var trmProdGr = new global.GlideQuery(sn_hamp.HAMTRMUtil.TRM_PRODUCT_TABLE) .whereNotNull('hw_product') .toGlideRecord();