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 number
JR52035
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-12-11
Closed date
2015-02-23
Last modified date
2015-02-23
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
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
12 December 2021