IBM Support

JR59553: SqlDataException for findUsersByPersonalizationId

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When submitting an order, the following error is seen:
    [5/14/18 9:27:31:653 CDT] 000000f5 RemoteExcepti E CNTR0019E:
    EJB threw an unexpected (non-declared) exception during
    invocation of method "findUsersByPersonalizationId". Exception
    data: com.ibm.ejs.persistence.EJSPersistenceException: find
    failed:; nested exception is:
    com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error:
    SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.19.49 at
    com.ibm.commerce.user.objects.EJSJDBCPersisterCMPUserBean_dca866
    44.findUsersByPersonalizationId(EJSJDBCPersisterCMPUserBean_dca8
    6644.java:704) at
    com.ibm.commerce.user.objects.EJSCMPUserHomeBean_dca86644.findUs
    ersByPersonalizationId(EJSCMPUserHomeBean_dca86644.java:175) at
    com.ibm.commerce.user.objects.EJSRemoteCMPUserHome_dca86644.find
    UsersByPersonalizationId(EJSRemoteCMPUserHome_dca86644.java:501)
     at
    com.ibm.commerce.user.objects._UserHome_Stub.findUsersByPersonal
    izationId(_UserHome_Stub.java:550) at
    com.ibm.commerce.user.objects.UserAccessBean.findUsersByPersonal
    izationId(UserAccessBean.java:1202) at
    com.ibm.commerce.member.internal.server.util.MemberAttributeHelp
    er.isMarketingTrackingOptIn(MemberAttributeHelper.java:209) at
    com.ibm.commerce.marketing.internal.runtime.persistence.TriggerH
    andlerPersistenceManager.createTriggerSender(TriggerHandlerPersi
    stenceManager.java:1500) at
    com.ibm.commerce.marketing.runtime.engine.TriggerHandler.registe
    rTriggerSender(TriggerHandler.java:238) at
    com.ibm.commerce.marketing.runtime.engine.TriggerHandler.forward
    Triggers(TriggerHandler.java:2256) at
    com.ibm.commerce.marketing.runtime.engine.TriggerHandler.raiseTr
    igger(TriggerHandler.java:1706) at
    com.ibm.commerce.marketing.facade.server.commands.ProcessMarketi
    ngTriggerSendActionCmdImpl.performExecute(ProcessMarketingTrigge
    rSendActionCmdImpl.java:68)
    
    After the error, we can see the following personalizationId was
    used which caused a problem:
    [5/14/18 9:27:31:653 CDT] 000000f5 MemberAttribu W There was an
    error while fetching marketing tracking consent for
    personalizationId: 1549635041590-1496MKT2018-05-14 09:28:25.325
    

Local fix

  • Disable the marketing activities before applying the new fix.
    

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce V8.0.4.12 or later, and WebSphere Commerce
    Version 7 customers who applied the JR59223 GDPR APAR.
    
    PROBLEM ABSTRACT:
    SqlDataException for findUsersByPersonalizationId
    
    BUSINESS IMPACT:
    Some dialog activities do not work as expected if you enable
    GDPR-related features. If you create marketing activities with
    the trigger "Customer Places Order", shoppers cannot complete
    the order.
    
    
    RECOMMENDATION:
    

Problem conclusion

  • Added a processing logic to get the accurate personalization id.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR59553

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive / Xsystem

  • Submitted date

    2018-05-15

  • Closed date

    2018-05-25

  • Last modified date

    2018-05-25

  • 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

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021