Corrupt text index may occur when collecting scores and text indexes for a monthly indicator that is collected daily.
Steps to Reproduce
- Create a monthly indicator source (incident_metric)
- Create an indicator with aggregate count for the indicator source created in previous step
- Create a text analytics configuration for field incident_short_description
- Add the indicator to a daily data collection and activate the collection
If this issue only happens once you can delete the text index for the month where collection starts to fail.
If this issue happens periodically then a daily scheduled script execution can be created to run to remove the text index for the current month before the PA data collection is scheduled to run.
Related Problem: PRB1373497