A fix is available
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