We've recently been working with upgrading to Sugar 7.6. One of the main problems is that the Search (Global) at the top left does not ever return any results. The list view search works fine. Elasticsearch works correctly when curl'ing to it. I have tested the Search options in the Admin, and subsequently run an index using the scheduler. I still get an empty array as a response for every single query in this input. Is there anything else I can try? I know for a fact that my data exists, for example: I get plenty of records with %test% in listview, but never any in the global search.

A couple of other places to check. Could you make sure that cron is set up properly? The re-index is scheduled as a background job. Indexing jobs need to finish before you'd see results. https://support.sugarcrm.com/Knowledge_Base/Administration/Schedulers/Troubleshooting_Cron_and_Schedulers Also, any errors in sugarcrm.log?

Search always returns "No results were found"

Richard Coleman over 9 years ago

We've recently been working with upgrading to Sugar 7.6. One of the main problems is that the Search (Global) at the top left does not ever return any results.

The list view search works fine.

Elasticsearch works correctly when curl'ing to it.

I have tested the Search options in the Admin, and subsequently run an index using the scheduler.

I still get an empty array as a response for every single query in this input.

Is there anything else I can try?

I know for a fact that my data exists, for example:

I get plenty of records with %test% in listview, but never any in the global search.

0 Matt Marum over 9 years ago

A couple of other places to check.
Could you make sure that cron is set up properly? The re-index is scheduled as a background job. Indexing jobs need to finish before you'd see results.
https://support.sugarcrm.com/Knowledge_Base/Administration/Schedulers/Troubleshooting_Cron_and_Schedulers
Also, any errors in sugarcrm.log?

App Ecosystem @ SugarCRM
0 Richard Coleman over 9 years ago in reply to Matt Marum

Hi Matt,
Thanks for the quick response.
I hadn't thought to check sugarcrm.log but unfortunately there's nothing of note in there.
Also, my cron job log in Sugar is stating that the status for the indexing (i.e. running function performFullFTSIndex) was "done" as of earlier today.
So seems like everything is connecting and validating, but just not retrieving anything. So strange.
Thanks for the help so far, let me know if you have any more suggestions!
Richard
0 Richard Coleman over 9 years ago in reply to Richard Coleman

For some odd reason, I had to run subsequent indexes in order for results to show. Either that, or it didn't run for all expected modules first time.
Suffice it to say, running indexes resolved the issue.
0 Matt Marum over 9 years ago in reply to Richard Coleman

I believe the performFullFTSIndex function just puts index jobs on the queue, it doesn't necessarily guarantee that indexing will run synchronously.
The only way that I know (right now) to monitor progress of FTS indexing is to check status of fts_queue table in database. Cron should be run until this table is empty and then you will be sure that indexing has completed.

App Ecosystem @ SugarCRM