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 number
JR56567
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-08-26
Closed date
2017-08-16
Last modified date
2017-08-16
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
11 December 2021