Updates during the import process to sn_vul_vulnerable_item.age column cause text index events to back up.

Steps to Reproduce

Import a large volume of vulnerable items and observe the text index events process/queue.


Sn_vul_vulnerable_item.age should not have a text index because it is an integer field.

To turn off the text index on age:

  1. Navigate to System Definition > Dictionary.

  2. Search for Table = sn_vul_vulnerable_item.

  3. Find the age column name (Column name = age).

  4. Open the record and find the Advanced View. At the top of the record, you have the option to edit the record. Click to edit and either add a new Attribute or append a comma separated value: no_text_index=true, and click "Update". 

Related Problem: PRB1248469

Seen In

There is no data to report.

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-07-09 14:25:06