JR41337: CMVC 213574 - MAKE THE SCHEDULER ABLE TO RECOVER FROM A TIMEOUT EXCEPTION.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
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

• When the SCHACTIVE table is locked for an extended period of
  time (for example, during database backup), the scheduler thread
  trying to access the SCHACTIVE table can timeout waiting for the
  database lock to be released. When this happens, a transaction
  rollback exception is seen:
  
  
  [10/25/11 20:18:30:170 EDT] 00000121 TranManagerIm I
  WTRN0041I:
  Transaction
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  00000001 has been rolled back.
  [10/25/11 20:18:30:273 EDT] 00000121 ExceptionUtil E
  CNTR0019E: EJB
  threw an unexpected (non-declared) exception during invocation
  of method
  "findByPrimaryKey". Exception data:
  
  The rollback then gets stuck, trying to roll back the same
  transaction every two seconds:
  
  
  
  [10/25/11 20:18:32:331 EDT] 00000121 TranManagerIm I
  WTRN0041I:
  Transaction
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  00000001 has been rolled back.
  [10/25/11 20:18:32:331 EDT] 00000121 ExceptionUtil E
  CNTR0019E: EJB
  threw an unexpected (non-declared) exception during invocation
  of method
  "findByPrimaryKey". Exception data:
  
  ...
  
  [10/25/11 20:18:34:365 EDT] 00000121 TranManagerIm I
  WTRN0041I:
  Transaction
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  000001333D7E8A9E00000001000320974BBE5F7BC8CF9A5AB1AF7867597FD551
  4D32395F
  00000001 has been rolled back.
  [10/25/11 20:18:34:366 EDT] 00000121 ExceptionUtil E
  CNTR0019E: EJB
  threw an unexpected (non-declared) exception during invocation
  of method
  "findByPrimaryKey". Exception data:
  ...
  
  When the scheduler gets stuck in this rollback state, scheduled
  jobs are no longer able to be run until the server is restarted.
  

Local fix

• Restarting the server clears up the rollback exception, allowing
  the scheduler to run again
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce V6 users that lock the SCHACTIVE table for
  extended periods
  
  PROBLEM ABSTRACT:
  Scheduler hangs when SCHACTIVE table is locked
  
  BUSINESS IMPACT:
  scheduled jobs can not be run until a server restart
  
  RECOMMENDATION:
  

Problem conclusion

• APAR JR41337 changes the code flow to prevent the scheduler
  thread from getting stuck in this rollback loop.
  
  -------------------------------------------------------------
  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