Posted: 24 Aug 2017 1:23 EDT Last activity: 30 Aug 2017 0:48 EDT
Search in PEGA 7.1.9 is failing. That does not mean search is not working. The search is working but few cases miss out from search. Logs do not have any entries. How do we monitor what has gone wrong with search and remediate it ?
***Edited by Moderator Marissa to update categories***
YEs the location looks fine. The search is not failing completely but few records dont come up randomly. That number of complaints that fail in such a way sometimes is high. How to find where the issue is ?
Posted: 4 years ago
Posted: 30 Aug 2017 0:48 EDT
Vikash Ranjan Karn (Vikash Karn)
Senior Technical Solutions Engineer
You can try truncating pr_sys_statusnodes and pr_sys_queue_ftsindexer table and then perform reindexing as there are scenarios when some stale data will be present in these tables which might be causing the issue with the searching.
NOTE: But before truncating these tables take the backup of these tables.
If after going through the suggested PDN links etc and depending on how deep you need to go into this: you can directly interrogate the Search Indexes (which are Lucene-based) using various tools.
For instance: this 'Luke' Tool can be used to look directly at the underlying Indexes (you can just copy the underlying Lucene directory to a separate directory - or indeed access them directly - but be careful about modifying them by mistake).
You'll need to build the tool using a combination of 'git' (to fetch the source-code) and 'maven' - to build the JAR file; some of the older binary version of 'Luke' will NOT work with the Elastic Search built Lucene Indexes - due to version differences. (You need Lucene V5 [I think, it might be V6 even]).