Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Engincan Yildiz (EngincanY)
EIB
Software Engineer
EIB
PL
EngincanY Member since 2018 85 posts
EIB
Posted: Sep 24, 2019
Last activity: Sep 29, 2019
Posted: 24 Sep 2019 4:55 EDT
Last activity: 29 Sep 2019 5:53 EDT
Closed

Elastic search implementation

Hi,

I would like to query a data table using elastic search feature. For this I followed the steps below;

  • Created a custom search property
  • Re-indexed Data class
  • Created an activity and called the call Rule-Obj-Report-Definition.pxRetrieveSearchData

The property I added as custom search belongs to the class I send as parameter in the activity.

However I get no results. Is there anything else I need to configure ?

Thanks

To see attachments, please log in.
Low-Code App Development
Reporting

Posted: 5 years ago
Posted: 26 Sep 2019 10:29 EDT
Engincan Yildiz (EngincanY)
EIB
Software Engineer
EIB
PL

Yes and the value is "true". I noticed that data instances have not been indexed. I click re-index but still it does not work. There must be 30000+ instances. But the number of documents is 1700 in search landing page.

To see attachments, please log in.
Posted: 5 years ago
Posted: 26 Sep 2019 10:58 EDT
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN

Hi,

Can you trace the sql query & which is being called during execution of this activity. Run this query directly in the database using sql developer. Please verify if you are getting any result.

I suspect you will be getting an exception during the execution of this activity. Please verify tracer & above step once. Please let me know the result after that.

Thanks,
Abhinav

To see attachments, please log in.
Posted: 5 years ago
Posted: 27 Sep 2019 1:58 EDT
Engincan Yildiz (EngincanY)
EIB
Software Engineer
EIB
PL

Hi,

I do not see any sql query in the tracer. And pySearchResultsData page is empty. I think it is because of the data indexes. As I said in my above comment, the number of documents for data indexes should be 30000+. But there is just 1700.

To see attachments, please log in.
Posted: 5 years ago
Posted: 27 Sep 2019 2:51 EDT
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN

Hi,

If there is no sql query it means DB operation doesn't happen.Did you find any exception in the tracer logs.

As per your analysis index is not built properly.So can you try to rebuild index & verify.

Thanks,
Abhinav

To see attachments, please log in.
Posted: 5 years ago
Posted: 29 Sep 2019 5:53 EDT
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN

Hi,

I got an article related to elastic search can you please go through below article & do the required changes before raising SR.

https://community.pega.com/knowledgebase/articles/system-administration/troubleshooting-pega-platform-search?utm_source=pega_support&utm_medium=announcements&utm_campaign=troubleshooting_platform_search

Thanks,

Abhinav

To see attachments, please log in.

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

Pega Collaboration Center 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