IBM Support

JR44531: CMVC 224701 - This fix is to address a dataload limitation for loading AD Attributes with 'searchable' and 'facetable' columns

Direct link to fix

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When trying to populate data in SEARCHABLE and FACETABLE columns
    in ATTR the dataload utility fails an error similar to the
    following:
    com.ibm.commerce.foundation.dataload.exception.DataLoadSQLExcept
    ion:
    The ID was not resolved for the table SELECT STOREENT_ID FROM
    ATTR WHERE ATTR_ID = ?  with the unique index data
    7000000000000012901.
    at
    com.ibm.commerce.catalog.dataload.mediator.AttributeDictionaryAt
    tributeMediator.populateSRCHATTR(AttributeDictionaryAttributeMed
    iator.java:573)
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 using dataload to load
    Attribute Dictionary (AD) attributes that are declared to be
    SEARCHABLE and FACETABLE.
    
    PROBLEM ABSTRACT:
    Loading Attribute Dictionary (AD) attributes fails to populate
    SEARCHABLE and FACETABLE columns in ATTR table
    
    BUSINESS IMPACT:
    Dataload for Attribute Dictionary (AD) fails and needs
    troubleshooting.
    
    RECOMMENDATION:
    

Problem conclusion

  • The dataload limitation for the loading of AD Attributes with
    'searchable' and 'facetable' columns is removed with this ifix.
     Included in this ifix are xpaths for the SEARCHABLE and
    FACETABLE columns in ATTR table in the loader configuration.
    This will enable the dataload mediator code to populate the
    SEARCHABLE and FACETABLE columns in ATTR table and related
    tables.
    
    -------------------------------------------------------------
    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

  • APARNOPUB
    

Comments

APAR Information

  • APAR number

    JR44531

  • Reported component name

    WC BUS DEV ED W

  • Reported component ID

    5724I3900

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive

  • Submitted date

    2012-10-25

  • Closed date

    2013-05-14

  • Last modified date

    2013-05-14

  • 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 DEV ED W

  • Fixed component ID

    5724I3900

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer 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:
07 December 2021