Direct links to fixes
APAR status
Closed as program error.
Error description
The attribute dictionary data model allows for sharing and reuse of attributes by using the "allowed value" attribute type. If the "assigned value" attribute type is used instead, the attribute value information is not shared. When multiple products have values that are logically the same, using assigned values attributes creates duplication in the ATTRVAL and ATTRVALDESC tables leading to performance degradation.
Local fix
Problem summary
Duplicate assigned attribute values can cause a performance impact
Problem conclusion
This ifix introduces changes to the way Data Load, Catalog Upload and Management Center handle attribute dictionary - assigned attribute values to allow for sharing of attribute data. Two additional configuration flags are introduced: 1) Attributes/KeepAssignedAttributeValueLocal (default true) in wc-business-object-mediator.xml for Management Center 2) shareAssignedAttributeValues (default true) for com.ibm.commerce.catalog.dataload.mediator.CatalogEntryAttribute DictionaryAttributeMediator for the dataload utility and catalog upload These flags are used to control the following behaviors: When an assigned value attribute is added to a product, the dictionary will now be consulted to see if the value already exists for the attribute. If it does, the product's attribute value will stored as a reference to the existing value. When an attribute value is changed for a product, the dictionary is consulted to determine if the new value already exists for the attribute. If it does, the product's attribute value is simply changed to use the existing attribute value. If the new attribute value does not already exist in the dictionary, it will be added and the product's attribute value will use the newly created attribute value. Any products which reference the previous value will be unaffected.
Temporary fix
Comments
APAR Information
APAR number
JR50043
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
2014-04-22
Closed date
2015-08-07
Last modified date
2015-08-07
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
11 December 2021