JR44538: CMVC 224701 - ADDRESS DATALOAD LIMITATION DUE TO LOADING OF AD ATTRIBUTES WITH 'SEARCHABLE' AND 'FACETABLE' COLUMNS

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

  • When trying to populate data in SEARCHABLE and FACETABLE columns
    in ATTR the dataload utility fails with error, for example:
    
    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)
    
    because the ATTR row is not committed to the database yet.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 using dataload to dataload
    Attribute Dictionary (AD) attributes and populate SEARCHABLE and
    FACETABLE columns in ATTR table.
    
    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

  • Included xpaths for the SEARCHABLE and FACETABLE columns in ATTR
    table in the loader configuration.
    Enabled the dataload mediator code to populate 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

Comments

APAR Information

  • APAR number

    JR44538

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive

  • Submitted date

    2012-10-26

  • Closed date

    2013-01-30

  • Last modified date

    2013-01-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



Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Reference #:

JR44538

Modified date:

2013-01-30

Translate my page

Machine Translation

Content navigation