JR44997: CMVC 225420 - TO IMPORVE ADDTOREMOVEFROM CUSTOMER SEGMENT ACTION TO NOT HAVE A DB EXCEPTION WHEN CUSTOMER IS ALREADY IN SEGMENT

WebSphere Commerce Version 7.0.0.7 Fix Pack

APAR status

• Closed as program error.

Error description

• When the Add To or Remove From Customer Segment action (within a
  web or dialog activity) attempts to add a user into the customer
  segment, if the user is already in the segment then an exception
  similar to the following will appear in the logs:
  
  11/14/12 2:02:08:146 PST] 00000088 jdbc I
  com.ibm.commerce.foundation.internal.server.services.dataaccess.
  graphbuilderservice.jdbc.JDBCGraphBuilderService saveGraph
  Original exception:DB2 SQL Error: SQLCODE=-803,
  SQLSTATE=23505,SQLERRMC=1;BECWCS.DMMBRGRPPZN, DRIVER=4.3.111
  
  The current implementation of the action does not check if the
  customer is already in the segment before trying to insert a
  record into the DMMBRGRPPZN relationship table.
  The code tries to insert a record, and if the insertion fails,
  it catches and reports the exception as this means the user is
  already in the segment.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce v7.0 users using the Management Center
  Marketing Add To or Remove From Customer Segment action
  
  PROBLEM ABSTRACT:
  A database exception occurs in the "Add To or Remove From
  Customer Segment" action when the customer is already in the
  segment.
  
  BUSINESS IMPACT:
  Excessive exception tracing can slow down performance. Reviewing
  database errors can result in suspecting the application is not
  working correctly.
  
  RECOMMENDATION:
  

Problem conclusion

• The Add To or Remove From Customer Segment action was modified
  to first check if the user is already in the segment. The insert
  statement is only run if the user is not already in the segment.
   This change prevents database error reporting, and excessive
  exception tracing.
  
  -------------------------------------------------------------
  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

• 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