Question
Staidlogic
IN
Last activity: 20 Apr 2018 9:51 EDT
Elastic Search is not working
Hi,
For all work objects created newly or saved, i don't see a entry in pr_sys_queue_ftsindexer table or pr_sys_workindexer_queue.
Checked all the steps in the above url and i don't see entries in pr_sys_queue_ftsindexer.
Search is working intermittently on blob fields (looking for a word in rich text editor). Is there a way to check all the work objects are indexed?
Can you please help me on the above issue.
Pegasystems Inc.
IN
Hi,
Hi,
Note that pr_sys_workindexerqueue table is corresponds to Lucene search (used as a search library till PRPC 7.1.6) and holds data in an upgraded system (not a fresh installation) till all indexes have been converted to Elastic Search (Introduced from PRPC 717). The user must explicitly re-index from the search landing page to create Elastic Search indices to get this conversion done. Till such time, search will be serviced by the older Apache Lucene library (used as the search library till 7.1.6) and SystemIndexer and SystemWorkIndexer are needed to keep those indices up to date.
Can you please let us know your PRPC version ?
Can you please let us know what error you could see in search landing page ?
For an instance, If the state is shown "Available" and you still get this message means that the index file has not been completely built. Doing a full re-index from the search landing page will fix the issue.
Please let me know if this helps.
Thanking you,
venkat
Pegasystems Inc.
US
What version of Pega is in use?
Does performing a full reindex allow all work to be searched?
Is this a multi-node environment?
Is the FTSIncrementalIndexer agent running?
Can you provide screen shots of your search settings landing page with all sections expanded?
Staidlogic
IN
Pega 7.2.2
I'm able to do full re-index and search for Work Object. But blob field RichTexEditor is not not working properly in search.
FTSIncrementalIndexer is up and running but i don't see records in pr_sys_queue_ftsindexer table.
Pegasystems Inc.
US
Is the thing you're specifically concerned about the ability to search for data that has been stored in a RichText field or is there another issue where indexing doesn't seem to be working for other data?
Staidlogic
IN
Data that has been stored in RichText editor is not working during search (it is work's intermitently), for rest of the fields indexing works fine.
Pegasystems Inc.
US
You may want to enter an SR for us to look into it more deeply... But just thinking about this, I'm not sure it's going to work. The RichText field is probably a text property... So it's going to be saved into the database with the HTML formatting, which will get indexed along with the text itself. When you search, if there is HTML breaking up the string you're looking for, it may not work.
Looking at the RichText value on the clipboard after it's saved will confirm if the HTML is being saved too. If this is the case, I'm not sure if there is anything we could do.
Pegasystems Inc.
US
What is kept in a RichText field that you're searching for? Could this data be placed in a standard text field instead so that it can be indexed and searched on more easily?
Staidlogic
IN
Few text sentences (50 lines) followed by images, templates and few text sentences.
I search for a word in the last sentence, search is not bringing the corresponding WO ID.
Pegasystems Inc.
US
Are you just looking at the results displayed or are you also clicking Show All Results and looking there? It's possible that it's being returned, but just not in the first set of results given on screen.
In any case, if you believe there to be a bug please open an SR for us to look into it. We'll want to see what the RichText value looks like on the clipboard, and logs where debug is enabled on 'com.pega.pegarules.search.internal.es' and the issue reproduced.