Support Article
Lack of dedicated PEGA Alert for slow FTS search queries
SA-85416
Summary
Unable to identify poor performing FTS Search queries due to the lack of Pega alerts.
Error Messages
RequestorLockExceptions
PEGA0086 alerts
Steps to Reproduce
- Index the work items.
- Launch a slow query (for example, 1 && 2 && 3 && 4 && 4 && 5 && 6 && 7 && 8 && 8 && 9 && 0 && a && aa && ab && ac && ad && ae && af).
- Launch a fast query (for example, pyDefault). The Request #3 is served after Request #2. The slow requests or timeouts are not reported by an Alert.
Root Cause
A defect or configuration issue in the operating environment
PEGA0054 already exists for this issue; however the alert is not enabled by default.
Resolution
Perform the following local-change:
Define a threshold which matches the SLA for FTS searches.
Follow the instructions in the article to define the threshold: https://community.pega.com/knowledgebase/articles/pega0054-alert-query-exceeded-operation-time-threshold
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.