BugZero | ServiceNow BugID PRB1426481 - sys_cs_topic needs new text ts

ServiceNow - Defect ID: PRB1426481

sys_cs_topic needs new text ts_configuration

ServiceNow - Defect ID: PRB1426481

sys_cs_topic needs new text ts_configuration

Last updated on November 15th, 2023

BugZero Risk Score
5.8 Medium

Overall: 5.8

Severity: 6.4

Community: 3.7

Lifecycle: 9.1

What is the BugZero Risk Score?

ServiceNow Integration

Learn more about where this data comes from

ServiceNow Integration

Learn more

Bug Scrub Advisor

Streamline upgrades with automated vendor bug scrubs

Bug Scrub Advisor

Learn more

BugZero Enterprise

Wish you caught this bug sooner? Get proactive today.

BugZero Enterprise

Learn more

Bug Details

Priority: Sev3
Article Views: 195
Affected Component: Cloud Management
Views: 1

Description

In a high volume event, when a user types in virtual agent, text searches are executed (for auto suggest). This causes additional load on the database. If there are a high amount of text_index events noticed, check to see if sys_metadata is in an indexing state. If so, there is a strong possibility that they are impacted by this PRB. Steps to Reproduce 1. Send autosuggest a high amount of traffic via VA web client. 2. As a result, the database can be overwhelmed. Workaround ** Note: This requires the maint role which is only available to ServiceNow technical support. ** The best option is to create a new text ts_configuration for sys_cs_topic. Goto ts_configuration_list.do > New > Select sys_cs_topic and v4 > Save. Then open that record and click Generate Text Index. This will move sys_cs_topic text index from under sys_metadata and into this own ts_ group of text. The query should be much faster as there are only 50 or record in sys_cs_topic.

Related Problem

PRB1426481

Change history

2023-11-15 Added: Paris Patch 1 Hot Fix 1, Quebec Patch 1 Hot Fix 1, Quebec Patch 4, Quebec Patch 5, Quebec Patch 9, Quebec Patch 9 Hot Fix 3a, Rome Patch 1, Rome Patch 10 Hot Fix 2b, Rome Patch 10 Hot Fix 4b, Rome Patch 3, Rome Patch 7, Rome Patch 9a, Rome Patch 9b, San Diego Patch 1 Hot Fix 1, San Diego Patch 10, San Diego Patch 10 Hot Fix 1, San Diego Patch 10 Hot Fix 1a, San Diego Patch 10 Hot Fix 1b, San Diego Patch 10 Hot Fix 2b, San Diego Patch 3, San Diego Patch 7a, San Diego Patch 7b, San Diego Patch 9, San Diego Patch 9a, San Diego Patch 9b, Tokyo, Tokyo Patch 1, Tokyo Patch 1b, Tokyo Patch 3, Tokyo Patch 4a, Tokyo Patch 4b, Tokyo Patch 5, Tokyo Patch 6, Tokyo Patch 6 Hot Fix 1, Tokyo Patch 6 Hot Fix 2, Tokyo Patch 7, Tokyo Patch 7 Hot Fix 1, Tokyo Patch 7a, Tokyo Patch 7b, Tokyo Patch 8, Tokyo Patch 8 Hot Fix 1, Tokyo Patch 9, Tokyo Patch 9 Hot Fix 2, Tokyo Patch 9 Hot Fix 2a, Utah, Utah Patch 1, Utah Patch 1 Hot Fix 1, Utah Patch 1 Hot Fix 1a, Utah Patch 1 Hot Fix 1b, Utah Patch 2, Utah Patch 3, Utah Patch 3 Hot Fix 1, Utah Patch 4, Utah Patch 4 Hot Fix 2, Utah Patch 4 Hot Fix 2a, Utah Patch 4 Hot Fix 3, Utah Patch 5, Vancouver

Relevant Products

Click on a version to see all relevant bugs

Affected versions:Paris Patch 1 Hot Fix 1, Quebec Patch 1 Hot Fix 1, Quebec Patch 4, Quebec Patch 5, Quebec Patch 9, Quebec Patch 9 Hot Fix 3a, Rome Patch 1, Rome Patch 10 Hot Fix 2b, Rome Patch 10 Hot Fix 4b, Rome Patch 3, Rome Patch 7, Rome Patch 9a, Rome Patch 9b, San Diego Patch 1 Hot Fix 1, San Diego Patch 10, San Diego Patch 10 Hot Fix 1, San Diego Patch 10 Hot Fix 1a, San Diego Patch 10 Hot Fix 1b, San Diego Patch 10 Hot Fix 2b, San Diego Patch 3, San Diego Patch 7a, San Diego Patch 7b, San Diego Patch 9, San Diego Patch 9a, San Diego Patch 9b, Tokyo, Tokyo Patch 1, Tokyo Patch 1b, Tokyo Patch 3, Tokyo Patch 4a, Tokyo Patch 4b, Tokyo Patch 5, Tokyo Patch 6, Tokyo Patch 6 Hot Fix 1, Tokyo Patch 6 Hot Fix 2, Tokyo Patch 7, Tokyo Patch 7 Hot Fix 1, Tokyo Patch 7a, Tokyo Patch 7b, Tokyo Patch 8, Tokyo Patch 8 Hot Fix 1, Tokyo Patch 9, Tokyo Patch 9 Hot Fix 2, Tokyo Patch 9 Hot Fix 2a, Utah, Utah Patch 1, Utah Patch 1 Hot Fix 1, Utah Patch 1 Hot Fix 1a, Utah Patch 1 Hot Fix 1b, Utah Patch 2, Utah Patch 3, Utah Patch 3 Hot Fix 1, Utah Patch 4, Utah Patch 4 Hot Fix 2, Utah Patch 4 Hot Fix 2a, Utah Patch 4 Hot Fix 3, Utah Patch 5, Vancouver

Fixed versions: No known fixed versions

Relevant Products

Click on a version to see all relevant bugs

Affected versions:Paris Patch 1 Hot Fix 1, Quebec Patch 1 Hot Fix 1, Quebec Patch 4, Quebec Patch 5, Quebec Patch 9, Quebec Patch 9 Hot Fix 3a, Rome Patch 1, Rome Patch 10 Hot Fix 2b, Rome Patch 10 Hot Fix 4b, Rome Patch 3, Rome Patch 7, Rome Patch 9a, Rome Patch 9b, San Diego Patch 1 Hot Fix 1, San Diego Patch 10, San Diego Patch 10 Hot Fix 1, San Diego Patch 10 Hot Fix 1a, San Diego Patch 10 Hot Fix 1b, San Diego Patch 10 Hot Fix 2b, San Diego Patch 3, San Diego Patch 7a, San Diego Patch 7b, San Diego Patch 9, San Diego Patch 9a, San Diego Patch 9b, Tokyo, Tokyo Patch 1, Tokyo Patch 1b, Tokyo Patch 3, Tokyo Patch 4a, Tokyo Patch 4b, Tokyo Patch 5, Tokyo Patch 6, Tokyo Patch 6 Hot Fix 1, Tokyo Patch 6 Hot Fix 2, Tokyo Patch 7, Tokyo Patch 7 Hot Fix 1, Tokyo Patch 7a, Tokyo Patch 7b, Tokyo Patch 8, Tokyo Patch 8 Hot Fix 1, Tokyo Patch 9, Tokyo Patch 9 Hot Fix 2, Tokyo Patch 9 Hot Fix 2a, Utah, Utah Patch 1, Utah Patch 1 Hot Fix 1, Utah Patch 1 Hot Fix 1a, Utah Patch 1 Hot Fix 1b, Utah Patch 2, Utah Patch 3, Utah Patch 3 Hot Fix 1, Utah Patch 4, Utah Patch 4 Hot Fix 2, Utah Patch 4 Hot Fix 2a, Utah Patch 4 Hot Fix 3, Utah Patch 5, Vancouver

Fixed versions: No known fixed versions

Top ServiceNow Defects

9.4Defect ID: PRB1954123
Instance access issues due to Mutual TLS (mTLS) enablement on Zurich instances
8.5Defect ID: PRB1871576
Data visualization can be accessed by anyone with URL to visualization designer
8.5Defect ID: PRB1611377
CMDB Baseline creation job causing app node out of memory when a CI has a huge number of records referencing it
8.5Defect ID: PRB1788540
AWS Events Driven discovery is overloading Default Semaphores.
8.5Defect ID: PRB1928008
Upgrade to Yokohama releases can hang for Haraka enabled instance because of contention on kagami query registrar