1. Home
  2. Support
Article - CS259491

SolrException is happened when you run a search including multi sub-types with Name sorted table view at Advanced Search.(Windchill PDMLink)

Modified: 10-May-2017   


Applies To

  • Windchill PDMLink 11.0 M020

Description

  • SolrException is happened when you run a search including multi sub-types with Name sorted table view at Advanced Search.
  • Advanced Search shows error with no results as below.
ERROR: There is an error executing the query. Check your query syntax.
  • The query includes multi of the sub-types defined by the customer.
  • The Table view is defined the sorting by Name column.
  • Solr.log shows error as below.
2017-03-28 05:17:50.515 ERROR (qtp314337396-15) [   x:wblib] o.a.s.h.RequestHandlerBase org.apache.solr.common.SolrException: can not sort on multivalued field: containerInfo.name_t
    at org.apache.solr.schema.SchemaField.checkSortability(SchemaField.java:168)
    at org.apache.solr.schema.TextField.getSortField(TextField.java:100)
    at org.apache.solr.schema.SchemaField.getSortField(SchemaField.java:149)
    at org.apache.solr.search.SortSpecParsing.parseSortSpecImpl(SortSpecParsing.java:202)
    at org.apache.solr.search.SortSpecParsing.parseSortSpec(SortSpecParsing.java:60)
    at org.apache.solr.search.QParser.getSort(QParser.java:247)
    at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:189)
    at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:267)
    at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:156)
    at org.apache.solr.core.SolrCore.execute(SolrCore.java:2036)
    at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:657)
    at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:464)
    at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:257)
    at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:208)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
                 :
  • ​MethodServer.log as below.
2017-03-28 14:17:50,531 ERROR [DataSource Task Executor-63] wt.indexsearch.AbstractIndexSearchDelegate demo - Failed to query Solr: 
org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error from server at  http://WindchillServer.site.com:8085/solr/wblib: can not sort on multivalued field: containerInfo.name_t
    at org.apache.solr.client.solrj.impl.HttpSolrClient.executeMethod(HttpSolrClient.java:590)
    at org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:259)
    at org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:248)
    at org.apache.solr.client.solrj.SolrRequest.process(SolrRequest.java:149)
    at wt.index.service.SolrServiceImpl.query(SolrServiceImpl.java:104)
    at wt.indexsearch.SolrSearchDelegate.executeQuery(SolrSearchDelegate.java:159)
    at wt.indexsearch.SolrSearchDelegate.executeQueryList(SolrSearchDelegate.java:136)
    at wt.indexsearch.SolrSearchDelegate.performSearch(SolrSearchDelegate.java:590)
    at wt.indexsearch.AbstractIndexSearchDelegate.search(AbstractIndexSearchDelegate.java:226)
    at com.ptc.windchill.enterprise.search.mvc.service.IndexService.queryIndexServer(IndexService.java:218)
    at com.ptc.windchill.enterprise.search.mvc.service.IndexService.doGetPage(IndexService.java:112)
                 :
This is a printer-friendly version of Article 259491 and may be out of date. For the latest version click CS259491