"Count Knowledge Use" scheduled job results in creation of large amount of text index events leading to performance issues (includes some fixes to hints and error messages).
Steps to Reproduce
Create 10 to 20 knowledge articles.
Go to the Count Knowledge Use jobs /nav_to.do?uri=sys_trigger.do?sys_id=377187cd0a0a0b52005a19f2d02d178e
Execute the job.
Go to /sysevent_list.do.
There are now 10 to 20 new text index events on kb_knowledge.use_count.
Note: This is not scalable past a few thousand articles without causing a delay to text index event process.
This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine the versions that have a planned or permanent fix.
Related Problem: PRB1173454