JR46827: CMVC 228852 - Data is loaded for only one category when loading calculation code for multiple categories.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When using the CatalogGroupCalculationCode keyword to load
  category calculation code information into the database tables,
  even if  multiple categories are specified in the CSV file, only
   the first record will be populated.
  
   For example, in the CSV file, we have specified the following
  categories:
  
   CatalogGroupCalculationCode
   GroupIdentifier, SalesTaxCalculationCode, Delete
   25_251_2992,     0GST,                    0
   15_152_1655,     0GST,                    0
   65_656_9639,     0GST,                    0
  
   After the data load, only the first category(25_251_2992) will
  be populated in the database tables.
  
   The problem only occurs when GroupIdentifier keyword is used as
  the CSV column.
  

Local fix

• You can use the GroupUniqueId keyword as the CSV column.
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 who using the
  CatalogGroupCalculationCode keyword to load category calculation
  code information.
  
   PROBLEM ABSTRACT:
   Data is loaded for only one category when loading calculation
  code for multiple categories.
  
   BUSINESS IMPACT:
   The calculation may not be correct as the code is not loaded
  properly.
  
   RECOMMENDATION:
  

Problem conclusion

• The problem was caused by the category id getting cached and not
   reset after processing the first row.  The code is changed so
  that the category id is reset after processing each record.
  
   -------------------------------------------------------------
   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