# Failed to execute \[org.elasticsearch.action.search.SearchRequest@31e1eed3\] lastShard \[true\] **URL:** \ **Category:** Elasticsearch\ **Created:** [December 4, 2017, 2:09pm UTC](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-31e1eed3-lastshard-true/110156 "2017-12-04T14:09:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![yedukondalu](https://avatars.discourse-cdn.com/v4/letter/y/ecb155/32.png) [@yedukondalu](https://discuss.elastic.co/u/yedukondalu)\ **Post date:** [December 4, 2017, 2:09pm UTC](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-31e1eed3-lastshard-true/110156/1 "2017-12-04T14:09:00Z")
[2017-12-04 14:04:48,600][DEBUG][action.search.type] [Morgan Le Fay] [cms-2017-w41][0], node[b2Jk8MLcR9evD012hWulmg], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@5ff4c8aa] lastShard [true] org.elasticsearch.search.SearchParseException: [cms-2017-w41][0]: query[rfcCi.ciId:499194],from[-1],size[1]: Parse Failure [Failed to parse source [{"size":1,"query":{"query\_string":{"query":"499194","fields":["rfcCi.ciId"]}},"sort":[{"searchTags.responseDequeTS":{"order":"desc"}}]}]] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:747) at org.elasticsearch.search.SearchService.createContext(SearchService.java:572) at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:544) at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:306) at org.elasticsearch.search.action.SearchServiceTransportAction$5.call(SearchServiceTransportAction.java:231) at org.elasticsearch.search.action.SearchServiceTransportAction$5.call(SearchServiceTransportAction.java:228) at org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:559) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.elasticsearch.search.SearchParseException: [cms-2017-w41][0]: query[rfcCi.ciId:499194],from[-1],size[1]: Parse Failure [No mapping found for [searchTags.responseDequeTS] in order to sort on] at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:214) at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:188) at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:86) at org.elasticsearch.search.SearchService.parseSource(SearchService.java:731) ... 9 more [2017-12-04 14:04:48,604][DEBUG][action.search.type] [Morgan Le Fay] [cms-2017-w41][0], node[b2Jk8MLcR9evD012hWulmg], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@31e1eed3] lastShard [true] org.elasticsearch.search.SearchParseException: [cms-2017-w41][0]: query[rfcCi.ciId:497958],from[-1],size[1]: Parse Failure [Failed to parse source [{"size":1,"query":{"query\_string":{"query":"497958","fields":["rfcCi.ciId"]}},"sort":[{"searchTags.responseDequeTS":{"order":"desc"}}]}]] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:747) at org.elasticsearch.search.SearchService.createContext(SearchService.java:572) at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:544) at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:306) at org.elasticsearch.search.action.SearchServiceTransportAction$5.call(SearchServiceTransportAction.java:231) at org.elasticsearch.search.action.SearchServiceTransportAction$5.call(SearchServiceTransportAction.java:228) at org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:559) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.elasticsearch.search.SearchParseException: [cms-2017-w41][0]: query[rfcCi.ciId:497958],from[-1],size[1]: Parse Failure [No mapping found for [searchTags.responseDequeTS] in order to sort on] at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:214) at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:188) at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:86) at org.elasticsearch.search.SearchService.parseSource(SearchService.java:731) ... 9 more ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [December 4, 2017, 3:48pm UTC](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-31e1eed3-lastshard-true/110156/2 "2017-12-04T15:48:14Z")
Please format your code using `` icon as explained in [this guide](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will make your post more readable. Or use markdown style like: ```` ``` CODE ``` ```` The cause is: ``` No mapping found for [searchTags.responseDequeTS] in order to sort on ``` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 1, 2018, 3:48pm UTC](https://discuss.elastic.co/t/failed-to-execute-org-elasticsearch-action-search-searchrequest-31e1eed3-lastshard-true/110156/3 "2018-01-01T15:48:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.