IBM Support

JR49634: CMVC 234768 - SELECT_FACET_VALUE_IMAGE_AND_SEQUENCE query will fail when sales catalogId is used

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In wc-query-utilities-fep5.tpl, the
    SELECT_FACET_VALUE_IMAGE_AND_SEQUENCE query expects a master
    catalogId to be used:
    
     BEGIN_SQL_STATEMENT
             name=SELECT_FACET_VALUE_IMAGE_AND_SEQUENCE
             base_table=ATTRDICTSRCHCONF
             sql=
             select distinct
    attrdictsrchconf.SRCHFIELDNAME,attrvaldesc.value,attrval.storeen
    t_id,attrvaldesc.sequence,attrvaldesc.image1,attrvaldesc.image2
             from
               attrdictsrchconf, attr, attrvaldesc, attrval
             where
               attrdictsrchconf.attr_id=attr.attr_id and
               attr.attr_id=attrvaldesc.attr_id and
               attrval.attr_id = attr.attr_id and
               attrdictsrchconf.ATTR_ID is not NULL and
               attr.facetable=1 and
               attrval.storeent_id in (?storeList?) and
               attrvaldesc.language_id=?language_id? and
               attrdictsrchconf.SRCHFIELDNAME in (?searchFieldList?)
     END_SQL_STATEMENT
    
     As a result, if a sales catalodId is used in the query, no
    results will be returned by the query.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 Feature Pack 5+ who have the
    specified version of this query.
    
    PROBLEM ABSTRACT:
    SELECT_FACET_VALUE_IMAGE_AND_SEQUENCE query will fail when sales
    catalogId is used
    
    BUSINESS IMPACT:
    No facet results are returned in search for sales catalog
    
    RECOMMENDATION:
    

Problem conclusion

  • Change behavior in
    SolrFacetEntryViewImageAndSequenceResultFilter.class so it is
    not reading the catalogId from the business context (where it
    may not be master catalogId).
    -------------------------------------------------------------
    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

    JR49634

  • 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

    2014-03-14

  • Closed date

    2014-06-04

  • Last modified date

    2014-06-04

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021