JR55976: During Catalog Upload of Catalog Entry Description Override, database connections might run out when there are many stores.

APAR status

• Closed as program error.

Error description

• This APAR JR55976 supercedes APAR JR54835.
  
  The original problem in JR54835 indicated that the Data Load
  utility might lose database connections when used with a
  customized dataload configuration that includes the store
  identifier and there are more stores specified than the number
  of available database connections in the DataSource connection
  pool.
  
  The issue occurs because the Data Load utility uses
  StoreRegistry to retrieve the store owner ID, but StoreRegistry
  gets a new database connection every time. When there are more
  stores than the available connections, a connection time out
  occurs and the connection is lost.
  

Local fix

• As a workaround, the CSV input files can be split such that each
   input file contains only a small number of distinct store
  identifiers.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 Fix Pack 8 or later, and WebSphere
  Commerce Version 8.
  
  PROBLEM ABSTRACT:
  During Catalog Upload of Catalog Entry Description Override,
  database connections might run out when there are many stores.
  
  BUSINESS IMPACT:
  Business users cannot load catalog entry description overrides
  in Management Center for many stores at the same time.
  
  RECOMMENDATION:
  

Problem conclusion

• The Data Load utility was updated to execute a SQL query to
  retrieve the owners of the stores and save the results in
  memory, avoiding the need to use the StoreRegistry to retrieve
  that data.
  

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