Loading...
Loading...
After the instance is upgraded to Xanadu, users may experience slowness while accessing any form with a TableChoice field. Before Xanadu, the cache for the archive tables stores 1 entry per archive table, with a default cache size of 500. In Xanadu, we introduced a feature that creates 2 entries per archive table. Due to this, instances with more than 250 archive tables now have over 500 entries in the cache, causing slowness when accessing forms with a TableChoice field. This issue happens only if the instance has more than 250 archive tables (name starts with ar_ in sys_db_object table).
Have an instance on Xanadu with over 250 archive table Load any form with TableChoice field. For example, Opening a record on sys_security_acl, it takes abnormally long to open the record (30 seconds or more)
The problem has been fixed. Upgrade to a version that has a permanent fix by reviewing the Fixed In section at the bottom of the KB. If you are unable to upgrade to a fixed version at this time, please apply the below workaround.
1) Navigate to Tables list by typing sys_db_object.list in the navigator. 2) Filter the list with field Name starts with ar_ 3) Note the archive table record count from Step 2 4) Update or Create the System Property as below. Property Name
Type Value Ignore Cache glide.cache.size.CACHE_ARCHIVE_TABLE_HAS_ACL_TERMS Property created as part of PRB1833782 workaround Integer 2+ times the value of the archive table count (record count noted in Step 3) Note: we are recommending 2.5 times in case if the number of archive tables increases. true Note: You may need to do a cache.do on the instance once the property is set. Also, when the record loads the first time, it may be a little slow since it will need to cache into memory. On the second refresh, it should load much faster.
PRB1833782
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.