QueryShardException: No mapping found for [sortOrder] in order to sort on

Hi Everyone!
I connect Fess to external Elastic then have error after created index of fess :
QueryShardException: No mapping found for [sortOrder] in order to sort on

Below is version of Fess & Elastic

Elastic :

{
“name” : “URG6Bz5”,
“cluster_name” : “elasticsearch”,
“cluster_uuid” : “EBB6PgrmTCeIyQ6XXfcLbA”,
“version” : {
“number” : “6.6.1”,
“build_flavor” : “default”,
“build_type” : “zip”,
“build_hash” : “1fd8f69”,
“build_date” : “2019-02-13T17:10:04.160291Z”,
“build_snapshot” : false,
“lucene_version” : “7.6.0”,
“minimum_wire_compatibility_version” : “5.6.0”,
“minimum_index_compatibility_version” : “5.0.0”
},
“tagline” : “You Know, for Search”
}

Fess Version: 12.5
I removed REM in content of fess.in.bat:

set FESS_JAVA_OPTS=%FESS_JAVA_OPTS% -Dfess.es.http_address=http://localhost:9200
set FESS_JAVA_OPTS=%FESS_JAVA_OPTS% -Dfess.es.transport_addresses=localhost:9300
set FESS_JAVA_OPTS=%FESS_JAVA_OPTS% -Dfess.dictionary.path=D:/option/elasticsearch-6.6.1/config/

Error:

[2021-02-02T10:22:39,875][INFO ][o.e.c.m.MetaDataCreateIndexService] [URG6Bz5] [fess_log.click_log] creating index, cause [api], templates , shards [5]/[0], mappings
[2021-02-02T10:22:40,220][INFO ][o.e.c.r.a.AllocationService] [URG6Bz5] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[fess_log.click_log][0], [fess_log.click_log][4]] …]).
[2021-02-02T10:22:40,309][INFO ][o.e.c.m.MetaDataMappingService] [URG6Bz5] [fess_log.click_log/blW8_hBNQnGd6mmBoBV3Tw] create_mapping [click_log]
[2021-02-02T10:22:40,377][INFO ][o.e.c.m.MetaDataCreateIndexService] [URG6Bz5] [fess_log.favorite_log] creating index, cause [api], templates , shards [5]/[0], mappings
[2021-02-02T10:22:40,687][INFO ][o.e.c.r.a.AllocationService] [URG6Bz5] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[fess_log.favorite_log][4]] …]).
[2021-02-02T10:22:40,760][INFO ][o.e.c.m.MetaDataMappingService] [URG6Bz5] [fess_log.favorite_log/0JayfaGiTAKHSqre7Cr4GA] create_mapping [favorite_log]
[2021-02-02T10:22:40,846][INFO ][o.e.c.m.MetaDataCreateIndexService] [URG6Bz5] [fess_log.search_log] creating index, cause [api], templates , shards [5]/[0], mappings
[2021-02-02T10:22:41,182][INFO ][o.e.c.r.a.AllocationService] [URG6Bz5] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[fess_log.search_log][4]] …]).
[2021-02-02T10:22:41,288][INFO ][o.e.c.m.MetaDataMappingService] [URG6Bz5] [fess_log.search_log/bJtt0bYaRFmCZLh0zgjhFg] create_mapping [search_log]
[2021-02-02T10:22:41,393][INFO ][o.e.c.m.MetaDataCreateIndexService] [URG6Bz5] [fess_log.user_info] creating index, cause [api], templates , shards [5]/[0], mappings
[2021-02-02T10:22:41,712][INFO ][o.e.c.r.a.AllocationService] [URG6Bz5] Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[fess_log.user_info][4]] …]).
[2021-02-02T10:22:41,780][INFO ][o.e.c.m.MetaDataMappingService] [URG6Bz5] [fess_log.user_info/oyW_m0OuQTmRjVCJAYyNTQ] create_mapping [user_info]
[2021-02-02T10:22:41,989][DEBUG][o.e.a.s.TransportSearchAction] [URG6Bz5] [.fess_config.path_mapping][0], node[URG6Bz5lTw26I6BvB03oLg], [P], s[STARTED], a[id=wljBnsTTQnKJI5XsOVjb-g]: Failed to execute [SearchRequest{searchType=QUERY_THEN_FETCH, indices=[.fess_config.path_mapping], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[path_mapping], routing=‘null’, preference=‘null’, requestCache=null, scroll=null, maxConcurrentShardRequests=5, batchedReduceSize=512, preFilterShardSize=128, allowPartialSearchResults=true, source={“from”:0,“size”:1000,“query”:{“terms”:{“processType”:[“D”,“B”],“boost”:1.0}},“sort”:[{“sortOrder”:{“order”:“asc”}}]}}]
org.elasticsearch.transport.RemoteTransportException: [URG6Bz5][127.0.0.1:9300][indices:data/read/search[phase/query]]
Caused by: org.elasticsearch.index.query.QueryShardException: No mapping found for [sortOrder] in order to sort on
at org.elasticsearch.search.sort.FieldSortBuilder.build(FieldSortBuilder.java:319) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.sort.SortBuilder.buildSort(SortBuilder.java:153) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService.parseSource(SearchService.java:823) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService.createContext(SearchService.java:656) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:631) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:388) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService.access$100(SearchService.java:126) ~[elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:360) [elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:356) [elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.search.SearchService$4.doRun(SearchService.java:1117) [elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:759) [elasticsearch-6.6.1.jar:6.6.1]
at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) [elasticsearch-6.6.1.jar:6.6.1]

Fess 12.5 is EOLed…

1 Like