Greetings. I am using Solr 3.4.0 with tomcat 7.0.22. I've been using
these versions successfully for a while, but on my latest project, I cannot
sort ANY field without getting this exception:
SEVERE: org.apache.solr.common.SolrException: can not sort on multivalued
field: id
at
org.apache.solr.schema.SchemaField.checkSortability(SchemaField.java:161)
at org.apache.solr.schema.TrieField.getSortField(TrieField.java:126)
at
org.apache.solr.schema.SchemaField.getSortField(SchemaField.java:144)
at
org.apache.solr.search.QueryParsing.parseSort(QueryParsing.java:385)
at org.apache.solr.search.QParser.getSort(QParser.java:251)
at
org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:82)
at
org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:173)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[snip]
The thing is, I have only one multivalued field in my schema, at least, I
thought so. I even tried sorting on id, which is the unique key, and got
the same error. Here are the fields in my schema:
<fields>
<!-- id -->
<field name="id" type="int" indexed="true" stored="true" required="true"
/>
<!-- idstring -->
<field name="idstring" type="string" indexed="true" stored="true"
required="true" />
<!-- solicitationId -->
<field name="solicitationid" type="textUnhyphenated" indexed="true"
stored="true" />
<field name="solicitationidpart" type="textNormal" indexed="true"
stored="false" />
<!-- agencyId -->
<field name="agencyid" type="string" indexed="true" stored="true" />
<!-- piid -->
<field name="piid" type="string" indexed="true" stored="true" />
<!-- modificationNumber -->
<field name="modnumber" type="string" indexed="true" stored="true" />
<!-- transactionNumber -->
<field name="txnnumber" type="int" indexed="true" stored="true" />
<!-- refAgencyID -->
<field name="refagencyid" type="string" indexed="true" stored="true" />
<!-- refPIID -->
<field name="refpiid" type="string" indexed="true" stored="true" />
<!-- refModificationNumber -->
<field name="refmodnumber" type="string" indexed="true" stored="true" />
<!-- fiscalYear -->
<field name="fiscalyear" type="int" indexed="true" stored="true" />
<!-- recType -->
<field name="rectype" type="int" indexed="true" stored="true" />
<!-- contractSignedDate -->
<field name="signeddate" type="date" indexed="true" stored="true" />
<!-- contractObligatedAmount -->
<field name="obligation" type="long" indexed="true" stored="true" />
<!-- prodinfoPrincipalNaicsCode -->
<field name="naics" type="int" indexed="true" stored="true" />
<!-- prodinfoPscCode -->
<field name="psc" type="string" indexed="true" stored="true" />
<!-- purchaserContractingOfficeId -->
<field name="buyingoffice" type="string" indexed="true" stored="true" />
<!-- purchaserFundingRequestingOfficeId -->
<field name="fundingoffice" type="string" indexed="true" stored="true"
/>
<!-- Vendor fields, hoo boy -->
<field name="vendor" type="textOriginalAndSubstring" indexed="true"
stored="true" />
<field name="vendorexact" type="textOriginalAndExactPhrase"
indexed="true" stored="false" />
<field name="vendornormal" type="textNormal" indexed="true"
stored="false" />
<field name="vendorsort" type="string" indexed="true" stored="false"/>
<copyField source="vendor" dest="vendorexact" />
<copyField source="vendor" dest="vendorsort" />
<copyField source="vendor" dest="vendornormal" />
<field name="vendoralt" type="textOriginalAndSubstring" indexed="true"
stored="true" />
<field name="vendoraltexact" type="textOriginalAndExactPhrase"
indexed="true" stored="false" />
<field name="vendoraltnormal" type="textNormal" indexed="true"
stored="false" />
<copyField source="vendoralt" dest="vendoraltexact" />
<copyField source="vendoralt" dest="vendoraltnormal" />
<field name="vendorlegal" type="textOriginalAndSubstring" indexed="true"
stored="true" />
<field name="vendorlegalexact" type="textOriginalAndExactPhrase"
indexed="true" stored="false" />
<field name="vendorlegalnormal" type="textNormal" indexed="true"
stored="false" />
<copyField source="vendorlegal" dest="vendorlegalexact" />
<copyField source="vendorlegal" dest="vendorlegalnormal" />
<field name="vendordba" type="textOriginalAndSubstring" indexed="true"
stored="true" />
<field name="vendordbaexact" type="textOriginalAndExactPhrase"
indexed="true" stored="false" />
<field name="vendordbanormal" type="textNormal" indexed="true"
stored="false" />
<copyField source="vendordba" dest="vendordbaexact" />
<copyField source="vendordba" dest="vendordbanormal" />
<!-- General vendor search helper fields -->
<field name="generalvendorterm" type="textNormal" indexed="true"
stored="false" multiValued="true" />
<copyField source="vendor" dest="generalvendorterm" />
<copyField source="vendorexact" dest="generalvendorterm" />
<copyField source="vendornormal" dest="generalvendorterm" />
<copyField source="vendoralt" dest="generalvendorterm" />
<copyField source="vendoraltexact" dest="generalvendorterm" />
<copyField source="vendoraltnormal" dest="generalvendorterm" />
<copyField source="vendorlegal" dest="generalvendorterm" />
<copyField source="vendorlegalexact" dest="generalvendorterm" />
<copyField source="vendorlegalnormal" dest="generalvendorterm" />
<copyField source="vendordba" dest="generalvendorterm" />
<copyField source="vendordbaexact" dest="generalvendorterm" />
<copyField source="vendordbanormal" dest="generalvendorterm" />
</fields>
<uniqueKey>id</uniqueKey>
I can post the entire schema.xml if need be. Can anyone please tell me
what's going on?
cheers,
Travis
--
**
*Travis Low, Director of Development*
** <t...@4centurion.com>* *
*Centurion Research Solutions, LLC*
*14048 ParkEast Circle *•* Suite 100 *•* Chantilly, VA 20151*
*703-956-6276 *•* 703-378-4474 (fax)*
*http://www.centurionresearch.com* <http://www.centurionresearch.com>
**The information contained in this email message is confidential and
protected from disclosure. If you are not the intended recipient, any use
or dissemination of this communication, including attachments, is strictly
prohibited. If you received this email message in error, please delete it
and immediately notify the sender.
This email message and any attachments have been scanned and are believed
to be free of malicious software and defects that might affect any computer
system in which they are received and opened. No responsibility is accepted
by Centurion Research Solutions, LLC for any loss or damage arising from
the content of this email.
