Hi,
am getting the following error while navigating to web user list on dashboard.
on elasticsearch log the following error displayed
tail -f /opt/data/elasticsearch-2.4.6/logs/covid-es.log
Caused by: SearchParseException[failed to parse search source [{"query": {"filtered": {"filter": {"and": [{"or": [{"term": {"domain.exact": "$
ovid19"}}, {"term": {"domain_memberships.domain.exact": "covid19"}}]}, {"term": {"doc_type": "WebUser"}}, {"term": {"base_doc": "couchuser"}},
{"term": {"is_active": true}}]}, "query": {"match_all": {}}}}, "sort": [{"username.exact": {"order": "asc"}}], "from": 0, "size": 5}]]; neste
d: SearchParseException[No mapping found for [username.exact] in order to sort on];
at org.elasticsearch.search.SearchService.parseSource(SearchService.java:873)
at org.elasticsearch.search.SearchService.createContext(SearchService.java:667)
at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:633)
at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:377)
at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportActi
on.java:368)
at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAct$
on.java:365)
at org.elasticsearch.transport.TransportRequestHandler.messageReceived(TransportRequestHandler.java:33)
at org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:77)
at org.elasticsearch.transport.TransportService$4.doRun(TransportService.java:378)
at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: SearchParseException[No mapping found for [username.exact] in order to sort on]
at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:213)
at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:187)
at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:85)
at org.elasticsearch.search.SearchService.parseSource(SearchService.java:856)
... 12 more
and this is the django.log
tail -f /home/cchq/www/echis/log/django.log
return view_func(request, domain, *args, **kwargs)
File "/home/cchq/www/echis/releases/2020-04-24_06.56/python_env-3.6/lib/python3.6/site-packages/django/views/decorators/http.py", line 40, in inner
return func(request, *args, **kwargs)
File "/home/cchq/www/echis/releases/2020-04-24_06.56/corehq/apps/users/views/init.py", line 579, in paginate_web_users
.start(skip).size(limit).run()
File "/home/cchq/www/echis/releases/2020-04-24_06.56/corehq/apps/es/es_query.py", line 220, in run
es_instance_alias=self.es_instance_alias,
File "/home/cchq/www/echis/releases/2020-04-24_06.56/corehq/elastic.py", line 216, in run_query
raise ESError(e)
corehq.elastic.ESError: TransportError(400, 'search_phase_execution_exception')
while all elasticsearch indices showing healthy
curl -XGET 172.31.85.158:9200/_cat/indices
green open smslogs_2020-01-28 5 1 0 0 1.5kb 795b
green open xforms_2016-07-07 5 1 0 0 1.5kb 795b
green open case_search_2018-05-29 5 1 0 0 1.5kb 795b
green open hqgroups_2017-05-29 5 1 0 0 1.5kb 795b
green open report_cases_czei39du507m9mmpqk3y01x72a3ux4p0 5 1 0 0 1.5kb 795b
green open hqapps_2020-02-26 5 1 61 180 5.4mb 2.7mb
green open hqusers_2017-09-07 2 1 5 1 153.5kb 76.7kb
green open hqdomains_2020-02-10 5 1 1 1 59kb 29.5kb
green open report_xforms_20160824_1708 5 1 0 0 1.5kb 795b
green open hqcases_2016-03-04 5 1 0 0 1.5kb 795b