JR59553: SqlDataException for findUsersByPersonalizationId

7.0.0.8-WS-WCServer-IFJR59553
7.0.0.8-WS-WCDeveloperEnterprise-IFJR59553

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 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