JR45906: CMVC 227503 - When using Catalog Upload, the values in the CATENCALCD.CALFLAGS column may not be updated as expected.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
JR49616 - Performance issue with DynacacheInvalidation Job after applying certain Fix Pack 7 APARs

APAR status

• Closed as program error.

Error description

• Using the Catalog Upload function for
  CatalogEntryCalculationCode type upload clears the
  CATENCALCD.CALFLAGS column of existing entries.
  

Local fix

• To preserve CALFLAGS and have the Dataload utility or Catalog
  Upload function to leave it alone, the columns can be excluded
  from update by adding the following lines to
  wc-loader-catalog-entry-calculation-code.xml:
  
     <_config:ColumnExclusionList>
       <_config:table name="CATENCALCD" columns="CALFLAGS" />
     </_config:ColumnExclusionList>
  
   immediately after
   <_config:DataLoader
  className="com.ibm.commerce.foundation.dataload.BusinessObjectLo
  ader" >
  

Problem summary

• USERS AFFECTED:
   Customers using Dataload or Catalog Upload to update the
  CATENCALCD table's CALFLAGS column
  
   PROBLEM ABSTRACT:
   When using Catalog Upload, the values in the
  CATENCALCD.CALFLAGS column may not be updated as expected.
  
   BUSINESS IMPACT:
   Entries may need to be manually or updated using Accelerator.
  
   RECOMMENDATION:
  

Problem conclusion

• The following changes were made to address this issue:
   - add CalFlags xpath to loader file, so it is able to load that
  column directly through the csv
   - make PartNumber optional in csv; it is deemed "All" products
  when omitted so it is able to explicitly load or delete the
  "All" products row
   - automatically delete CATENCALCD row for "All" products when
  loading specific part numbers
   - automatically delete CATENCALCD row for specific part numbers
  when loading "All" products
  
   -------------------------------------------------------------
   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