Question

Case and Rule Search

Hi

We recently upgraded from Pega 7.1.5 to 7.4. And as you all know we use elastic search.

Problem : If we have the DSS "Pega-SearchEngine • indexing/distributed/enabled" as true the rule search doesnot work. if we update this as false the rule search works but the Case search doesnt work. Any permanent solution?

***Edited by Moderator: Lochan to update platform capability tags***

Comments

Keep up to date on this post and subscribe to comments

Pega
December 3, 2019 - 9:42am

Hi,

Could you please provide us the snapshot of the search landing page to look further?

Thanks, 

Geeda.

December 3, 2019 - 10:06am
Response to GeedA

attaching

Pega
December 3, 2019 - 9:49am

Also, please check the following Dynamic System Settings exist and are set to true:
Pega-SearchEngine/indexing/distributed/enabled
Pega-SearchEngine/indexing/distributed/index_enabled
Pega-SearchEngine/indexing/distributed/search_enabled

December 3, 2019 - 10:06am
Response to GeedA

yes ... all these are set as true

December 4, 2019 - 6:51am

We are seeing below error for some of the obj classes .. any idea?

 

2019-12-04 04:00:39,007 [   PegaRULES-Batch-4] [  STANDARD] [                    ] [rack:Pega03:02.07.01] (Search.Indexer.AbstractIndexer) WARN   YQTM00M - Error on reading the next instance for class [XXXXXX-XXXX-CSWork-MiscDrCr]. Skipping instances of this class. 

com.pega.pegarules.pub.database.DatabaseException: Problem creating result pages: code: 17010 SQLState: 99999 Message: Closed Resultset: next 

DatabaseException caused by prior exception: java.sql.SQLException: Closed Resultset: next 

| SQL Code: 17010 | SQL State: 99999 

Pega
December 11, 2019 - 8:54pm

Hello Arvind,

Can you confirm if you implemented all the steps of the upgrade guide which are under the section named: "Upgrading from Pega 7.1.6 and earlier:Configuring the default search nodes and storagedirectory" (Page 73)?

Here's a quick link to review it: https://community.pega.com/knowledgebase/documents/pega-platform-74-upgrade-guide

I suspect that there are misses while implementing them or they were skipped altogether since they are marked "optional".

Thank you,
Pawan