IBM Support

JR42906: CMVC 222723 - RESOLVE NUMBERFORMATEXCEPTION WHEN EVALUATING SEGMENT AND USERS.LANGUAGE_ID IS NULL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Customer Segment is created which uses the Language condition.
    The logs contain errors when
    CheckUserInMemberGroupCmdImpl.evaluateLocaleCondition is
    evaluating the customer segment for users that do not have
    USERS.LANGUAGE_ID set.
    A NumberFormatException is thrown in the storefront, which
    overpopulates the logs with errors.
    
    [5/21/12 0:00:21:428 CEST] 00000d19 CommerceSrvr  E
    com.ibm.commerce.command.ECCommandTarget executeCommand
    CMN0420E: The following command exception has occurred during
    processing: "java.lang.NumberFormatException: For input string:
    """. java.lang.NumberFormatException: For input string: ""
        at java.lang.Throwable.<init>(Throwable.java:67)
    at
    java.lang.NumberFormatException.forInputString(NumberFormatExcep
    tion.java:59)
        at java.lang.Integer.parseInt(Integer.java:481)
        at java.lang.Integer.<init>(Integer.java:671)
        at
    com.ibm.commerce.common.objsrc.LanguageCache.findByPrimaryKey(La
    nguageCache.java:156)
        at
    com.ibm.commerce.membergroup.commands.CheckUserInMemberGroupCmdI
    mpl.evaluateLocaleCondition(CheckUserInMemberGroupCmdImpl.java:1
    123)
        at
    com.ibm.commerce.membergroup.commands.CheckUserInMemberGroupCmdI
    mpl.evaluate(CheckUserInMemberGroupCmdImpl.java:569)
        at
    com.ibm.commerce.condition.SimpleCondition.evaluate(SimpleCondit
    ion.java:213)
        at
    com.ibm.commerce.condition.AndListCondition.evaluate(AndListCond
    ition.java:89)
        at
    com.ibm.commerce.membergroup.commands.CheckUserInMemberGroupCmdI
    mpl.evaluateSegment(CheckUserInMemberGroupCmdImpl.java:432)
        at
    com.ibm.commerce.membergroup.commands.CheckUserInMemberGroupCmdI
    mpl.performExecute(CheckUserInMemberGroupCmdImpl.java:369)
    

Local fix

  • Ensure all users (shoppers) have a value set in
    USERS.LANGUAGE_ID that is not null.
    

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce V7 users that use the customer segment
    Language condition and the marketing feature.
    
    PROBLEM ABSTRACT:
    NumberFormatException is logged when evaluating a customer
    segment that uses the Language condition to target a marketing
    activity based on a customer's preferred language.
    
    BUSINESS IMPACT:
    The logs are overpopulated with errors.
    
    RECOMMENDATION:
    

Problem conclusion

  • The customer segment code was changed to correctly detect when
    the USERS.LANGUAGE_ID column is null, and not throw an
    exception.  The expected behavior is that when USERS.LANGUAGE_ID
    column is null, the segment Language condition is not met.
    
    
    -------------------------------------------------------------
    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 number

    JR42906

  • 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-05-22

  • Closed date

    2012-08-28

  • Last modified date

    2012-08-28

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 August 2012