IBM Support

JR49932: FacetHelper.getFacetConfigurationForSearchColumn() is no longer used after installing JR49158

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • After installing APAR JR49158, the
    FacetHelper.getFacetConfigurationForSearchColumn() is no longer
    being called.  It has been replaced by
    SolrSearchConfigurationRegistry.getFacetConfigurationForSearchCo
    lumn(),
    
    You will see issues if you have custom code using the
    FacetHelper.getFacetConfigurationForSearchColumn() code because
    it will be looking for a specific SQL in the wrong directory.
    
    You will see an error like  this:
    
    1/31/14 12:11:37:243 GMT] 00000052 CommerceSrvr  E
    com.ibm.commerce.datatype.AbstractFinderResult invokeFinder
    CMN0409E: The following error occurred during processing:
    "CWXFD2010E: Direct SQL statement
    "SELECT_FACETABLE_COLUMNS_SRCHATTRPROP" is missing from a query
    template file.".
    com.ibm.commerce.foundation.server.services.dataaccess.exception
    .QueryServiceSystemException: CWXFD2010E: Direct SQL statement
    "SELECT_FACETABLE_COLUMNS_SRCHATTRPROP" is missing from a query
    template file.
     at
    com.ibm.commerce.foundation.server.services.dataaccess.JDBCQuery
    Service.getSQLStatementWithParameterMarkers(JDBCQueryService.jav
    a:1388)
     at
    com.ibm.commerce.foundation.server.services.dataaccess.JDBCQuery
    Service.executeQuery(JDBCQueryService.java:875)
     at
    com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
    ediator.util.FacetHelper.getAllFacetColumns(FacetHelper.java:230
    4)
     at
    com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
    ediator.util.FacetHelper.myGetFacetProperties(FacetHelper.java:1
    643)
     at
    com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
    ediator.util.FacetHelper.access$7(FacetHelper.java:1635)
     at
    com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
    ediator.util.FacetHelper$MyGetFacetProperties.generateCacheableD
    ata(FacetHelper.java:177)
     at
    com.ibm.commerce.datatype.AbstractFinderResult.invokeFinder(Abst
    ractFinderResult.java:602)
     at
    com.ibm.commerce.datatype.CacheableFinderResult.invokeFinder(Cac
    heableFinderResult.java:195)
     at
    com.ibm.commerce.dynacache.commands.AbstractFinderResultCache.my
    InvokeFinder(AbstractFinderResultCache.java:1411)
     at
    com.ibm.commerce.dynacache.commands.AbstractFinderResultCache.in
    vokeFinder(AbstractFinderResultCache.java:1102)
     at
    com.ibm.commerce.dynacache.commands.AbstractDistributedMapCache$
    Cache.getOrPut(AbstractDistributedMapCache.java:452)
     at
    com.ibm.commerce.dynacache.commands.AbstractDistributedMapCache$
    Cache.access$3(AbstractDistributedMapCache.java:439)
     at
    com.ibm.commerce.dynacache.commands.AbstractDistributedMapCache.
    getOrPut(AbstractDistributedMapCache.java:284)
     at
    com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
    ediator.util.FacetHelper.getFacetConfigurationForSearchColumn(Fa
    cetHelper.java:2751)
    

Local fix

  • Update your custom code to use
    SolrSearchConfigurationRegistry.getFacetConfigurationForSearchCo
    lumn() instead of
    FacetHelper.getFacetConfigurationForSearchColumn()
    

Problem summary

  • USERS AFFECTED:
    Commerce V7 users with JR49158 installed and who use
    FacetHelper.getFacetConfigurationForSearchColumn() to return
    facet configurations.
    
    PROBLEM ABSTRACT:
    FacetHelper.getFacetConfigurationForSearchColumn() is no longer
    used after installing JR49158
    
    BUSINESS IMPACT:
    Facet configurations will not be returned.
    
    RECOMMENDATION:
    

Problem conclusion

  • Added support for backward compatibility for the
    FacetHelper.getFacetConfigurationForSearchColumn() by adding
    queries back to the
    xml\config\com.ibm.commerce.catalog\wc-query-utilities-fep5.tpl
    file.
    
    -------------------------------------------------------------
    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

    JR49932

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-04-11

  • Closed date

    2014-08-07

  • Last modified date

    2015-05-15

  • 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:
15 May 2015