Notifications

615 views

Description

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.

Workaround

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

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Policy and Compliance PA Content - Madrid 2019 Q1
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - SecOps - Configuration Compliance - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - CrowdStrike Intel Integration - Madrid 2019 Q1
SR - SIR - PaloAlto AutoFocus Integration - New York 2019 Q3
SR - SIR - PaloAlto Firewall Integration - New York 2019 Q3
SR - SIR - PaloAlto WildFire Integration - New York 2019 Q3
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Splunk Sighting Search Integration - Madrid 2019 Q1
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - Threat intelligence - New York 2019 Q3
SR - SIR - VirusTotal Integration - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Fixed In

London

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-11-26 09:23:05
Published:2018-06-01