JR42911: CMVC 222732 - PREVENT DUPLICATE PRODUCTSET.NAME ENTRIES FROM BEING GENERATED DUE TO CATALOGIMPORT UTILITY.

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
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• The core issue revolves around how the exclusion product set ID
  is automatically generated to 34 characters long using the
  following rules:
  
  "PE_<hexadecimal value of  (current time as long - random
  number)>_TC_<hexadecimal value of (terms-and-conditions-id for
  the contract)>".
  
  When this value is trimmed down to 32 characters, the maximum
  length of PRODUCTSET.NAME, it is possible for two entries to
  have the same ID if their time stamp is the same and their
  terms-and-conditions-id is the same up to the last 2 characters.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who use catalog filtering.
  
  PROBLEM ABSTRACT:
  Duplicate exclusion product set IDs generated through
  CatalogImport utility.
  
  BUSINESS IMPACT:
  Low
  
  RECOMMENDATION:
  

Problem conclusion

• Update
  com.ibm.commerce.productset.commands.DeployProductSetFilterTCCmd
  Impl, expose the method makeUpCatEntryProductSetXML(Vector
  catEntryIds, boolean isExclusion) and
  makeUpCatGroupProductSetXML(Long anCatalogId, Long catGroupId)
  so that custom can do customization here to make their own
  product set name.
  
  With this APAR the client can implement the following steps to
  resolve their issue:
  
  1)  Apply the APAR then perform the following customizations for
  the command.
  
  2)  Write a command class MyDeployProductSetFilterTCCmdImpl
  which extends DeployProductSetFilterTCCmdImpl.
  
  3)  Override the method makeUpCatEntryProductSetXML (can
  override makeUpCatGroupProductSetXML if needed).
  
  4)  Write some specific logic here to reduce the random number
  duplication (you can also use your own approach to do so).  See
  PMR 70869,499,000 for sample code.
  
  5)  Update command registry table and execute below SQL to
  register the new customized command.
  
      insert into cmdreg values
  (0,'com.ibm.commerce.productset.commands.DeployProductSetFilterT
  CCmd',null,'com.ibm.commerce.productset.commands.MyDeployProduct
  SetFilterTCCmdImpl',null,null,'Local',null);
  
  6)  Update the record if there is already an existing one.
  
  7)  Restart server or update Registry in Administration Console.
  
  -------------------------------------------------------------
  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