org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"query_string":{"fields":["name","label*","description*","maelstrom*"],"query":"datasource:\"opal2\" AND table:\"ConclusionQuestionnaire\""}},"sort":{"index":{"order":"asc"}},"fields":["name","datasource","table","label","label-en","index"],"from":0,"size":10}]]

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 09:32:58,426 DEBUG org.obiba.opal.search.IndexSynchronizationManager.run:107 - Check index for table: opal2.2 09:33:14,863 DEBUG org.elasticsearch.action.search.type.internalDebug:99 - [Zach] [opal-variables][0], node[Otir2JmMSSKiWaLPMGUPZQ], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@40e669bb] org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"query_string":{"fields":["name","label*","description*","maelstrom*"],"query":"datasource:\"opal2\" AND table:\"ConclusionQuestionnaire\""}},"sort":{"index":{"order":"asc"}},"fields":["name","datasource","table","label","label-en","index"],"from":0,"size":10}]] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:566) at org.elasticsearch.search.SearchService.createContext(SearchService.java:481) at org.elasticsearch.search.SearchService.createContext(SearchService.java:466) at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:236) at org.elasticsearch.search.action.SearchServiceTransportAction.sendExecuteQuery(SearchServiceTransportAction.java:141) at org.elasticsearch.action.search.type.TransportSearchQueryThenFetchAction$AsyncAction.sendExecuteFirstPhase(TransportSearchQueryThenFetchAction.java:80) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:205) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:192) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$2.run(TransportSearchTypeAction.java:178) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [No mapping found for [index] in order to sort on] at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:164) at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:138) at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:76) at org.elasticsearch.search.SearchService.parseSource(SearchService.java:554) ... 11 more
    via by Etienne Morency-Bachand [X],
  • 09:32:58,426 DEBUG org.obiba.opal.search.IndexSynchronizationManager.run:107 - Check index for table: opal2.2 09:33:14,863 DEBUG org.elasticsearch.action.search.type.internalDebug:99 - [Zach] [opal-variables][0], node[Otir2JmMSSKiWaLPMGUPZQ], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@40e669bb] org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"query_string":{"fields":["name","label*","description*","maelstrom*"],"query":"datasource:\"opal2\" AND table:\"ConclusionQuestionnaire\""}},"sort":{"index":{"order":"asc"}},"fields":["name","datasource","table","label","label-en","index"],"from":0,"size":10}]] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:566) at org.elasticsearch.search.SearchService.createContext(SearchService.java:481) at org.elasticsearch.search.SearchService.createContext(SearchService.java:466) at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:236) at org.elasticsearch.search.action.SearchServiceTransportAction.sendExecuteQuery(SearchServiceTransportAction.java:141) at org.elasticsearch.action.search.type.TransportSearchQueryThenFetchAction$AsyncAction.sendExecuteFirstPhase(TransportSearchQueryThenFetchAction.java:80) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:205) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:192) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$2.run(TransportSearchTypeAction.java:178) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [No mapping found for [index] in order to sort on] at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:164) at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:138) at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:76) at org.elasticsearch.search.SearchService.parseSource(SearchService.java:554) ... 11 more
    via by Etienne Morency-Bachand [X],
  • error w/ arcDistance* in script
    via GitHub by dblado
    ,
  • Corrupted ElasticSearch index ?
    via by bizzorama,
  • Marvel not showing nodes stats
    via by Prometheus WillSurvive,
  • Elasticsearch Version?
    via by Steve,
    • org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"query_string":{"fields":["name","label*","description*","maelstrom*"],"query":"datasource:\"opal2\" AND table:\"ConclusionQuestionnaire\""}},"sort":{"index":{"order":"asc"}},"fields":["name","datasource","table","label","label-en","index"],"from":0,"size":10}]] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:566) at org.elasticsearch.search.SearchService.createContext(SearchService.java:481) at org.elasticsearch.search.SearchService.createContext(SearchService.java:466) at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:236) at org.elasticsearch.search.action.SearchServiceTransportAction.sendExecuteQuery(SearchServiceTransportAction.java:141) at org.elasticsearch.action.search.type.TransportSearchQueryThenFetchAction$AsyncAction.sendExecuteFirstPhase(TransportSearchQueryThenFetchAction.java:80) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:205) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:192) at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$2.run(TransportSearchTypeAction.java:178) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: org.elasticsearch.search.SearchParseException: [opal-variables][0]: query[+datasource:opal2 +table:conclusionquestionnaire],from[-1],size[-1]: Parse Failure [No mapping found for [index] in order to sort on] at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:164) at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:138) at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:76) at org.elasticsearch.search.SearchService.parseSource(SearchService.java:554) ... 11 more

    Users with the same issue

    kid
    kid62 times, last one,