Resolved slowness when loading forms with TableChoice fields on instances with many archive tables

Zurich security and notable fixes

Security Fixes:
The Zurich release contains important fixes for security-related issues in various ServiceNow applications and the ServiceNow AI Platform. It is recommended that customers upgrade for the most secure and up-to-date features. More details can be found in KB2249737.

Access Control and User Management:

• Resolved slowness when loading forms with TableChoice fields on instances with many archive tables.
• Addressed excessive syslog logging related to AccessTerm ‘Slow ACL’.
• Fixed an issue where itil role users received errors when using short description suggestions on incident records.
• Corrected a problem where newly created users would not receive the snc_internal role when other roles were added to it, leading to unexpected behavior.

Activity Stream and Workspace:

• Fixed an issue where the Activity Stream didn't limit the size of journal fields, which could cause browsers and the Glide server to crash due to out-of-memory errors with large entries.
• Corrected a problem where work notes were displayed as encrypted text in the ServiceNow Workspace even for users with the correct roles.
• Resolved an issue where a user's display name was not shown correctly in the activity stream if their user_id was in a sys_id format.
• Fixed an issue where the Email tab in the CSM Configurable Workspace wouldn't resize for large text.
• Resolved a problem where an incorrect action bar would intermittently display in the Agent Workspace.

Agent Chat and Notifications:

• Fixed an issue where a Show audio modal would appear for Safari users whenever an agent's presence state changed to 'Available'.
• Corrected a problem where new message sounds and desktop notifications were not working in the legacy workspace.
• Resolved an issue where inbox audio was delayed when the Workspace tab was inactive, which could cause agents to miss work item notifications.

AI Search and Indexing:

• Fixed a bug where global search was not working for certain records after upgrading, especially for records created with old prefixes.
• Addressed an issue where AI Search indexing for Topic Path Translation would not work correctly for non-system user preference languages.
• Corrected a race condition that could cause the deletion of excessive records from the sys_variable_value table, impacting various components like Integration Hub and Service Catalog.
• Fixed a problem where a translated reference field was indexed in a different language after a single record update.
• Resolved an issue where AI Search attachment results were not redirecting to the parent record but to a broken URL.

CMDB and Configuration:

• Fixed a bug where the Conflict Detection job could lead to an OutOfMemoryError and node restarts when the Affected CIs table had a very large number of records.
• Resolved an issue where the CMDB Query Builder Suggested Relations job could fail to process all records under certain conditions.
• Fixed a problem where CMDB Health jobs would get stuck if a CI's sys_mod_count value was empty.

Other Notable Fixes:

• Resolved an issue with the PurgeOrphanAttachments job that could lead to the unintentional removal of records from the sys_attachment table.
• Fixed a problem where a Business rule on the Audit delete table would not trigger.
• Addressed an issue where a Multi-Level approval could skip steps due to race conditions.
• Corrected an issue where the Service Bridge Base plugin was not automatically upgraded when the Service Bridge for Providers plugin was upgraded.