"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

  1. Create 10 to 20 knowledge articles.

  2. Go to the Count Knowledge Use jobs /

  3. Execute the job.

  4. Go to /

    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

Seen In

There is no data to report.

Fixed In

Jakarta Patch 10

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:36:29