JR45906: CMVC 227503 - When using Catalog Upload, the values in the CATENCALCD.CALFLAGS column may not be updated as expected.
Direct links to fixes
Closed as program error.
Using the Catalog Upload function for CatalogEntryCalculationCode type upload clears the CATENCALCD.CALFLAGS column of existing entries.
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" >
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:
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
Reported component name
WC BUS EDITION
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WC BUS EDITION
Fixed component ID
Applicable component levels