JR56567: EXPRESSION table is incorrectly updated when deleting an existing catalog filter condition

APAR status

• Closed as program error.

Error description

• When you use the Data Load utility to delete an existing catalog
  filter condition, you might notice that the QUERY column of the
   EXPRESSION database table includes some invalid syntax, which
  will break the catalog filter entitlement check.
  
  The following scenario is an example of how you might encounter
  the issue:
  1.  Create a new catalog filter.
  2.  Load ManufacturerName not equals 'A' and ManufacturerName
  not equals 'B' and divisionCode equals 'D'.
  3.  Use the Data Load utility to delete ManufacturerName not
  equals 'A' and ManufacturerName equals 'B'.
  4.  Run setupSearchIndex with action
  configWCScheduleforCatalogFilter to update the EXPRESSION table.
  
  When you check the QUERY column of EXPRESSION table, you the
  following invalid entry:
  ( +divisionCode:"D" + mfName_ntk_cs:)
  
  This issue occurs because the delete action only removes the
  rows in the CFCONDVAL table and leave the CFCOND in the
  database.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 Feature Pack 8, and Version 8.
  
  PROBLEM ABSTRACT:
  EXPRESSION table is incorrectly updated when deleting an
  existing catalog filter condition
  
  BUSINESS IMPACT:
  Catalog filter entitlement check does not work.
  
  RECOMMENDATION:
  

Problem conclusion

• Updated logic so that if all the CFCONDVAL in one condition is
  empty, a Solr query is not generated.
  

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