IBM Support

JR39370: CMVC 208504 - PREVENT ERROR CAUSED BY NEGATIVE NUMBER IN SOLR EXPRESSION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In IBM WebSphere Commerce, while performing a SOLR search, you
    encounter the following error:
    
    [3/17/11 15:29:39:788 EDT] 00000085 solr 1
    com.ibm.commerce.foundation.internal.server.services.search.proc
    essor.solr.SolrSearchExpressionProcessor getEntityObjects Final
    Solr query expression:
    q=*:*&fq=catalog_id:13007&fq=storeent_id:(10651
    10551)&fq=published:1&fq=( +productset_id:(( +*:* +( +*:*
    --50000)))
    +*:*)&fl=catentry_id&start=0&rows=1&timeAllowed=3000&facet.query
    =parentCatgroup_id_search:13007_82569&facet.query=parentCatgroup
    _id_search:13007_82573&facet.query=parentCatgroup_id_search:1300
    7_82571&facet.query=parentCatgroup_id_search:13007_82570&facet.q
    uery=parentCatgroup_id_search:13007_82572&facet.sort=count&facet
    .mincount=1&facet.limit=-1&facet=true&debugQuery=true
    [3/17/11 15:29:39:791 EDT] 00000085 SolrCore E
    org.apache.solr.common.SolrException log
    org.apache.solr.common.SolrException:
    org.apache.lucene.queryParser.ParseException: Cannot parse '(
    +productset_id:(( +*:* +( +*:* --50000))) +*:*)': Encountered "
    "-" "- "" at line 1, column 34.
    Was expecting one of:
    "(" ...
    "*" ...
    <QUOTED> ...
    <TERM> ...
    <PREFIXTERM> ...
    <WILDTERM> ...
    "[" ...
    "{" ...
    <NUMBER> ...
    <TERM> ...
    "*" ...
    
    at
    org.apache.solr.handler.component.QueryComponent.prepare(QueryCo
    mponent.java:108)
    at
    org.apache.solr.handler.component.SearchHandler.handleRequestBod
    y(SearchHandler.java:181)
    at
    org.apache.solr.handler.RequestHandlerBase.handleRequest(Request
    HandlerBase.java:131)
    at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
    at
    org.apache.solr.client.solrj.embedded.EmbeddedSolrServer.request
    (EmbeddedSolrServer.java:139)
    at
    org.apache.solr.client.solrj.request.QueryRequest.process(QueryR
    equest.java:89)
    at
    org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:12
    2)
    at
    com.ibm.commerce.foundation.internal.server.services.search.proc
    essor.solr.SolrSearchExpressionProcessor.getEntityObjects(SolrSe
    archExpressionProcessor.java:591)
    at
    com.ibm.commerce.foundation.server.services.dataaccess.AbstractD
    ataServiceFacade.getEntityObjects(AbstractDataServiceFacade.java
    :158)
    at
    com.ibm.commerce.foundation.server.services.dataaccess.AbstractD
    ataServiceFacade.getPhysicalDataContainer(AbstractDataServiceFac
    ade.java:85)
    at
    com.ibm.commerce.foundation.server.services.dataaccess.AbstractD
    ataServiceFacade.getReadNounMediator(AbstractDataServiceFacade.j
    ava:189)
    

Local fix

  • This problem will only occur if negative primary keys are used.
    Typically negative primary keys are reserved for internal IBM
    use, so please change your custom primary key to be a positive
    value.
    

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0.0.2 Feature Pack 2 or higher,
    that make use of SOLR
    
    PROBLEM ABSTRACT:
    WebSphere Commerce error caused by negative number in SOLR
    expression
    
    BUSINESS IMPACT:
    Customers using negative primary keys, will encounter this error
    while performing SOLR searches.
    
    RECOMMENDATION:
    

Problem conclusion

  • Applying APAR JR39370 provides SOLR with the ability to handle
    negative primary keys by updating the CatalogFilterHelper class.
    -------------------------------------------------------------
    The latest available maintenance information can be obtained
    from the Recommended Fixes for WebSphere Commerce technote:
    http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR39370

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-04-11

  • Closed date

    2011-05-30

  • Last modified date

    2011-05-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WC BUS EDITION

  • Fixed component ID

    5724I3800

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
30 May 2011