ServiceNow keyword not returning search results

[ceraulo]

Hello!

I added the Application Services table to the Configuration Item text search group. When I search for ServiceNow I get this message.

Do you guys have any idea why this message appears for ServiceNow. This word is not included in the Stop Words list.

Thanks!

[Slava Savitsky]

This typically happens when your query only contains stop words. Perhaps "ServiceNow" is on the stop words list in your instance.

[ceraulo]

Hi Slava,

It was not included in the Stop Words (ts_stop) but in the Index Stop Word (ts_index_stop). The comment for the 'ServiceNow' Index Stop Word record is "Automatically generated stop word since index frequency, 25XXXX, exceeds automated stop threshold: 250,000".

I have the option to tag this as Not a Stop Word. Would this cause performance issue if I tag 'ServiceNow' as not a stop word?

Thank you.

[Slava Savitsky · Accepted solution]

After making changes to the stop words list, you will likely need to regenerate the text index as explained here. I would recommend doing it outside the business hours for two reasons:

1. Search may not work while the text index is being regenerated
2. System performance may be impacted if your table is very large

[ceraulo]

Thank you.