Text index frequency

[milesdpratt]

Hi all,

We are running into issues with global search. We have an incident opened 6 days ago, that has an email address in a string field on the form. When this email address is searched in global search (6 days after it was entered in the incident) there are no results returned. If I regenerate the text index on the task tables, you are then able to find this incident by using the same search term. This is not the first tie this has happened, and regenerating the index fixes the issue every time.

It seems to me that the index is not running frequently enough. Does anyone know how the re-index is controlled? I can't find any definite info on this.

Thanks!

[davidkeen_snow_ · Accepted solution]

Indexing is processed by the "text index events process" job on the sys_trigger table.

[INSTANCE_NAME].service-now.com/sys_trigger.do?sys_id=8b35903740fd0a00d23a78d881b126d6

By default, this runs every 30 seconds.

If this is configured in the standard manner, it may be best to get in touch with Support to have them debug the indexing in more depth.

[milesdpratt]

Hi David,

Opened an incident with support, and they found we had old syntax in our scheduled job. I was provided with the new syntax, and all is well.

I am hesitant to provide the syntax here because our case may be a tad unique, and I don't want others messing up their indexes with our code.