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

WebSphere Commerce Version 7.0.0.7 Fix Pack

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