Loading...
Loading...
Mismatches were identified on the ‘hash’ columns of the core company table, causing issues during the normalization process. In order to fix these mismatches in core_company table an initial fix script was created, however later found causing an increase in the upgrade time, especially in few instances which present 'null' hash values and missing unique index on hash column. ServiceNow reverted the fix script for Rome Patch 1 and Rome Patch 2, however that could not be done for Rome EA. Hence, depending on the count of records with 'null' value in the 'hash' column users might experience higher upgrade times when they upgrade from a non-Rome version to Rome EA. Ref.: PRB1492322/KB0995177 Invalid mismatching hashes for core company names PRB1520324/KB1002530 Invalid mismatching company hashes created as part of NDS data
Run the script below in scripts background on an instance to determine impact: (function() { var results = { 'note': '', 'details': { 'null_hash_count': -1, 'total_record_count': -1 }, 'reason': 'PRB1515341' }; if (!GlidePluginManager.isActive('com.glide.data_services_canonicalization.client')) { results.note = "NDS plugin not active"; } else { var coreCompanyAgg = new GlideAggregate('core_company'); if (!coreCompanyAgg.isValidField('hash')) { results.note = 'NDS plugin active, but no `hash` column'; } else { coreCompanyAgg.addNullQuery('hash'); results.details.null_hash_count = coreCompanyAgg.getCount(); coreCompanyAgg.initialize(); results.details.total_record_count = coreCompanyAgg.getCount(); } } gs.print(JSON.stringify(results)); }());
Instances that have at least 10k count returned in null_hash_count can have their upgrade time impacted when the instance upgrades from pre-Rome version to Rome EA. This problem was definitely fixed since Rome Patch 1-2. If you are able to upgrade, review the Fixed In section to determine the latest version with a permanent fix your instance can be upgraded to.
PRB1515341
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.