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:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.2 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |