JR56268: EXPRESSION table is not updated after loading catalog filter data

7.0.0.0-WS-WC70Fep8Server-IFJR56268
7.0.0.0-WS-WC70Fep8Developer-IFJR56268

APAR status

• Closed as program error.

Error description

• After applying JR53113, you might notice that the EXPRESSION is
  populated the first time that you load catalog filter data with
  the Data Load utility.
  
  However, when you subsequently use the Data Load utility to
  update this catalog filter? the EXPRESSION table is not updated,
   even if you run the SetupSearchIndex utility for action
  configWCScheduleforCatalogFilter.
  
  The expected behavior is that the EXPRESSION.QUERY column should
   be updated to include the setting of the new loaded catalog
  filters.
  
  The issue occurs because a DataCache invalidation is missing.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 Feature Pack 7 or later, and
  Version 8.
  
  PROBLEM ABSTRACT:
  EXPRESSION table is not updated after loading catalog filter
  data
  
  BUSINESS IMPACT:
  The catalog filter is not updated by the Data Load utility in
  terms of EXPRESSION table, so the entitlement check does not
  take effect.
  
  RECOMMENDATION:
  

Problem conclusion

• This fix triggers an invalidation to the catalog filter
  datacache so that the EXPRESSION table picks up the latest
  changes in the catalog filter.
  
  This fix also makes the getContractToGenerateExpression() method
   protected
  protected List<Long> getContractToGenerateExpression()
  
  Therefore, if you only want a subset of contracts to generate
  expression, then you can customize
  getContractToGenerateExpression.
  

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