Support Article
Elastic Search on External Table Only Returns 1 Result
SA-16527
Summary
Elastic search has been enabled on an external table. After indexing the class mapped to the external table and running pxRetrieveSearchData, only 1 result is returned. A normal report definition on the external class returns the correct number of results. Elastic search is not behaving correctly on external tables.
Error Messages
No error on screen. Incorrect amount of results are returned.
Steps to Reproduce
Step 1) Enable Elastic Search on external table
1.1) Create an external table
1.2) Map table to a PRPC class using the connection and metadata wizard
1.3) Navigate to the class create through the wizard and select the advanced tab. Modify the to have ruleform type of harness
1.4) create pySearchModel data transform in the same class and add the properties of the class that you want to be indexed
1.5) create simple report definition on class that retrieves the properties you added in pySearchModel
1.6) Run the reindexer through designStudio > System > Settings
1.5) reindex data classes
Step 2) Run activity pxRetrieveSearchData and enter the following values for the parameters:
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply Hfix-24761
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.