ItemLocMod Messages Stuck In MPS_STAGED_MESSAGE Due To Unique Constraint (SIM01.STORE_ITEM_CFA_PK) (Doc ID 3011185.1)

Last updated on MARCH 27, 2024

Applies to:

Symptoms

When attempting to process an ItemLocMod message from Retail Merchandising Foundation Cloud Service the following error occurs and the message remains in MPS_STAGED_MESSAGE.

ERROR
-----------------------


oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: ItemLocMod, BusinessId: 681224]
at oracle.retail.sim.service.mps.BaseSimMessageServiceHandler.buildException(Unknown Source)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.core.BaseServiceHandler.execute(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.ejb.MpsServiceBean.processStagedMessage(Unknown Source)
at sun.reflect.GeneratedMethodAccessor875.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:101)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aro301)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: oracle.retail.sim.common.core.SimServerException: Error executing batch statement. BatchUpdateException(1): ORA-00001: unique constraint (SIM01.STORE_ITEM_CFA_PK) violated

at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(Unknown Source)
at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.FlexibleAttributeConsumerOracleDao.insertStoreItemCfa(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.FlexibleAttributeConsumerOracleDao$Proxy$_$$_WeldClientProxy.insertStoreItemCfa(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.saveFlexibleAttributes(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.processItemStoreDeos(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.processItemLocDeo(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocModifyConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocModifyConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source)
... 62 more

Steps to Reproduce:

1. SIOCS contains the following combination in the STORE_ITEM_CFA table

  ITEM_ID, STORE_ID and Name for all locations.

2. An ItemLocMod message is published from MFCS via RICS (RIB)
3. Message fails in MPS_STAGED_MESSAGE table.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.