Question
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
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.
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
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.
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
I tried re-indexing but nothing happened. Also there is no error on tracer
Hi,
I got an article related to elastic search can you please go through below article & do the required changes before raising SR.
Thanks,
Abhinav
Hi,
Do you have the below DSS?
indexing/useDataInstances
Thank You,