JR50509: The dataload utility and catalog upload may incorrectly delete existing Assigned attribute attrval_id=0 records.

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• When using dataload or catalog upload with
  supportMultipleValuesForADAttributes=false, dataload/catalog
  upload will delete existing CATENTRYATTR records with the same
  ATTR_ID and CATENTRY_ID as the attribute relationship currently
  being loaded. As part of this process, when using assigned
  attributes, dataload will delete corresponding ATTRVAL records
  as they will no longer be in use if the relationship is removed.
  
  
   This can cause data corruption issues if the environment has
  existing relationships in the CATENTRYATTR table with
  products/skus and attrval_id=0. The
  AbstractCatalogEntryMediator's deletion logic will remove
  records with ATTRVAL_ID=0 in the CATENTRYATTR table, and also
  remove its corresponding record in the ATTRVAL table, causing a
  cascade delete on all records in the CATENTRYATTR table with
  ATTRVAL_ID=0.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce v7 users who use data load to load attribute
  dictionary attribute relationships for assigned attribute values
  with supportMultipleValuesForADAttributes=false.
  
   PROBLEM ABSTRACT:
   The dataload utility and catalog upload may incorrectly delete
  existing Assigned attribute attrval_id=0 records.
  
   BUSINESS IMPACT:
   Cascade deletes may lead to data corruption due to the
  incorrect deletion of the attribute values.
  
   RECOMMENDATION:
  

Problem conclusion

• The logic handling the deletion of attribute values is modified
  so that if attribute value id is 0, only the relationship is
  deleted, not the attribute value itself.
   -------------------------------------------------------------
   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