JR52035: DUPLICATEKEYEXCEPTION BEING LOGGED IN SYSTEMOUT FOR CUSTOMER SEG MENTS

APAR status

• Closed as program error.

Error description

• Following exception is continuously logged in the systemout for
  existing customer segments.
  
  com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException.DB2
  SQL
  Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=1;BECWCS.DMMBRGRPPZN,
  DRIVER=4.14.122
  
  ..
        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
  
  pmiExecuteUpdate(WSJdbcPreparedStatement.java:1152)
  
        at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate
  (WSJdbcPreparedStatement.java:793)
  
        at
  com.ibm.commerce.base.helpers.BaseJDBCHelper.executeUpdate
  (BaseJDBCHelper.java:401)
  
        at com.ibm.commerce.base.objects.ServerJDBCHelperBean.
  
  executeParameterizedUpdate(ServerJDBCHelperBean.java:655)
  
        at com.ibm.commerce.base.objects.
  
  EJSRemoteStatelessServerJDBCHelper_1e86a748.executeParameterized
  Update
  (EJSRemoteStatelessServerJDBCHelper_1e86a748.java:29)
  
        at com.ibm.commerce.base.objects._ServerJDBCHelper_Stub.
  
  executeParameterizedUpdate(_ServerJDBCHelper_Stub.java:1412)
  
        at
  com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean.
  executeParameterizedUpdate(ServerJDBCHelperAccessBean.java:336)
  
        at
  com.ibm.commerce.security.commands.MigrateUserEntriesCmdImpl.
  migratePersonalizationId(MigrateUserEntriesCmdImpl.java:1501)
  
        at
  com.ibm.commerce.security.commands.MigrateUserEntriesCmdImpl.
  migratePersonalization(MigrateUserEntriesCmdImpl.java:422)
  
        at
  com.ibm.commerce.security.commands.MigrateUserEntriesCmdImpl.
  performExecute(MigrateUserEntriesCmdImpl.java:1259)
  
        at com.ibm.commerce.command.ECCommandTarget.executeCommand
  
  (ECCommandTarget.java:157)
  
        at com.ibm.ws.cache.command.CommandCache.executeCommand
  
  (CommandCache.java:332)
  
        at com.ibm.websphere.command.CacheableCommandImpl.execute
  
  (CacheableCommandImpl.java:166)
  
        at
  com.ibm.commerce.command.AbstractECTargetableCommand.execute
  (AbstractECTargetableCommand.java:234)
  
        at com.ibm.commerce.security.commands.LogonCmdImpl.
  
  migrateUserEntries(LogonCmdImpl.java:651)
  
        at
  com.ibm.commerce.security.commands.LogonCmdImpl.performExecute
  (LogonCmdImpl.java:898)
  

Local fix

Problem summary

• DuplicateKeyException may be thrown when a shopper logs on
  

Problem conclusion

• The marketing code was improved so that the
  DuplicateKeyException does not occur when a shopper logs on.
  

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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP