IBM Support

JR42667: CMVC 221119 - ADD A FLAG TO TURN OFF VALIDATION FOR ATTRIBUTE DICTIONARY ALLOW VALUE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When loading Attribute Dictionary attributes with allowed
    values, the validation logic will check to see whether the new
    value already belongs to the current store before attempting to
    add it to the database.  If the new value does exist, an
    exception will be thrown and the next record will be processed.
    
    If the batch size is larger than 1, the previous entries in the
    batch are not yet committed to the database so the new one will
    not be found in the database and will be added to the current
    batch.  When the batch is executed, it will then fail due to the
    duplicate records contained within it.
    

Local fix

  • Set the batch size to 1 to ensure that each entry is committed
    as it is encountered, and the validation logic will detect the
    duplicate entry in the database.
    

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce customers on V7 who use the dataload utility
    or catalog upload capability to load Attribute Dictionary
    attributes with allowed values, which may contain duplicate
    entries.
    
    PROBLEM ABSTRACT:
    New Attribute Dictionary values may fail to load when the file
    contains duplicate entries and the loading is batched.
    
    BUSINESS IMPACT:
    Duplicate entries will be detected by the database (instead of
    the loader) during the transaction commit and the transaction
    will be rolled back.
    
    RECOMMENDATION:
    

Problem conclusion

  • A flag named "validateAttribute" is now added in
    wc-loader-AD-attribute-allowed-values.xml to control the
    execution of this validation logic.
    
    <_config:BusinessObjectMediator
    className="com.ibm.commerce.catalog.dataload.mediator.AttributeD
    ictionaryAttributeMediator"
    componentId="com.ibm.commerce.catalog" >
      <_config:property name="allowChangeAttributeType"
    value="false" />
      <_config:property name="validateAttribute" value="false" />
    </_config:BusinessObjectMediator>
    
    If this flag is not set, or is set to "true",  the validation
    logic will be executed.  If this flag is set to false the
    validation logic will be bypassed.
    
    If the data to be loaded is known to be "clean" (with no
    possibility of duplicate entries) then setting the flag to
    "false" will improve performance by eliminating the validation
    step.
    -------------------------------------------------------------
    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

    JR42667

  • 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

    2012-05-01

  • Closed date

    2012-07-06

  • Last modified date

    2012-07-06

  • 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:
06 July 2012