JR50674: Queries with certain table names in them are not automatically cached.

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• Starting in WebSphere Commerce Feature Pack 7, the Search Server
  has the ability to automatically cache certain queries when
  they contain certain table names, which can be configured in the
   CrossTransactionCache/autoCacheableTableNames setting in the
  com.ibm.commerce.foundation/wc-component.xml configuration file.
    There is also a hard coded list of table names which, if they
  occur in a query, will disqualify a query from being
  automatically cached.  The problem is that when one of these
  disqualifying table names also occurs in the
  CrossTransactionCache/autoCacheableTableNames, it still
  disqualifies queries that contain it.  However, it seems more
  reasonable to remove a table name from the hard coded list of
  disqualifying table names when it appears in the
  CrossTransactionCache/autoCacheableTableNames setting.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce Version 7 Feature Pack 7 customers who want
  to customize the CrossTransactionCache/autoCacheableTableNames
  Search Server setting to include additional table names.
  
   PROBLEM ABSTRACT:
   Queries with certain table names in them are not automatically
  cached.
  
   BUSINESS IMPACT:
   A certain performance improvement cannot be achieved since the
  auto caching feature does not provide as much caching as
  expected.
  
   RECOMMENDATION:
  

Problem conclusion

• The automatic caching feature has been changed to remove, from
  the hard coded list of disqualifying table names, table names
  explicitly configured in the
  CrossTransactionCache/autoCacheableTableNames Search Server
  setting in the com.ibm.commerce.foundation/wc-component.xml
  configuration file.
   -------------------------------------------------------------
   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