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

Subscribe

You can track all active APARs for this component.

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 number

    JR44997

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-03

  • Closed date

    2013-01-09

  • Last modified date

    2013-01-09

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Reference #:

JR44997

Modified date:

2013-01-09

Translate my page

Machine Translation

Content navigation