JR44997: CMVC 225420 - TO IMPORVE ADDTOREMOVEFROM CUSTOMER SEGMENT ACTION TO NOT HAVE A DB EXCEPTION WHEN CUSTOMER IS ALREADY IN SEGMENT
Direct links to fixes
Closed as program error.
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.
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:
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
Reported component name
WC BUS EDITION
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WC BUS EDITION
Fixed component ID
Applicable component levels