Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Recent items not available in work item search

SA-18976

Summary



Pega search was not working as expected, and the search landing page reported that there were 170,000 items in the indexing queue. Users see empty results while searching for work items that were created recently.


Error Messages



Not Applicable


Steps to Reproduce



Not Applicable


Root Cause



The search index queue fell behind when there was downtime in the indexing node.  However, because the indexer underperforms when the queue is large, leaving the most recent items in queue unindexed.

Resolution



There are two steps to resolve this issue.  

1a. TRUNCATE pr_sys_workindexer_queue to delete the agent's queue.  The performance of this agent degrades noticably as the queue increases.  
1b. Rebuild the queue using the reindex process from the search landing page.  This process will take a long time - potentially several days, but searching will begin to come online as each item is reindexed.  This works in a different mechanism from the indexing queue and does not perform less well against large numbers of items to index.

2. To prevent the indexing queue from falling behind when an indexing node goes down, provision multiple indexing nodes (new feature in 7.1.7 and newer versions.)  This will both distribute the indexing load, and allow a second node to take over as the primary node if the primary node is offline.

 

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us