JR45210: CMVC 225848 - PREVENT CATALOGUPLOAD FROM HOLDING A STALE DATABASE CONNECTION AFTER FAILING.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• Concurrent catalog uploads fail because one catalog upload
  thread holds a database connection longer than the firewall
  time-out. This happens for users who have a firewall setup
  between the Commerce server and database. After failing, all
  subsequent catalog uploads fail with the same database
  connection issue until the server is restarted.
  

Local fix

• Use Dataload instead of Catalog Upload.
  

Problem summary

• USERS AFFECTED:
  Users who have setup a firewall between their Commerce server
  and Database.
  
  PROBLEM ABSTRACT:
  Concurrent catalog uploads fail because one catalog upload
  thread holds a database connection longer than the firewall
  time-out
  
  
  BUSINESS IMPACT:
  Regular server restarts cause downtime
  
  RECOMMENDATION:
  

Problem conclusion

• Added error handling code for catalog upload to clear the stale
  connection, instead of holding it for the next catalog upload.
  -------------------------------------------------------------
  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