JR44695: CMVC 225007 - ENSURE TRANSACTION MGT FOR SENDMARKETINGTRIGGERS IS HANDLED CORRECTLY WITH ISSUING COMMITS

WebSphere Commerce Version 7.0.0.7 Fix Pack

APAR status

• Closed as program error.

Error description

• The SendMarketingTriggers scheduled job fails with a transaction
  timeout when processing a large number of entries in the
  DMTRIGSND database table.  A large number of entries in the
  DMTRIGSND occurs when there are a lot of customers participating
  in dialog activities with Customer Places Order, Customer
  Registers, and Wait triggers.  As a result of the transaction
  timeout, many dialog activity triggers are not processed.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 using Management Center dialog
  activities
  
  PROBLEM ABSTRACT:
  The SendMarketingTriggers scheduled job fails with a transaction
  timeout.
  
  BUSINESS IMPACT:
  Prevents customers from successfully participating in dialog
  activities.
  
  RECOMMENDATION:
  

Problem conclusion

• The SendMarketingTriggers scheduled job was changed to better
  handle the case of a large number of entries in the DMTRIGSND
  database table.
  -------------------------------------------------------------
  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