Cleanup Items Batch Job Fails With Error 'ORA-02292: integrity constraint (SIM01.RELATED_ITEM_FK1) violated' (Doc ID 2952806.1)

Last updated on JUNE 13, 2023

Applies to:

Symptoms

When attempting to clean up items in status D via the scheduled Cleanup Items batch job. job fails and the following error occurs.

ERROR
----------------------
BATCH_EXECUTION table

[Error]oracle.retail.sim.common.core.SimServerException
at oracle.retail.sim.server.dataaccess.daoimpl.PurgeOracleDao.purgeItem(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.PurgeOracleDao$Proxy$_$$_WeldClientProxy.purgeItem(Unknown Source)
at oracle.retail.sim.service.purge.PurgeServiceImpl.purgeItem(Unknown Source)
at oracle.retail.sim.service.purge.PurgeServiceImpl$Proxy$_$$_WeldClientProxy.purgeItem(Unknown Source)
at oracle.retail.sim.service.ejb.PurgeServiceBean.purgeItem(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
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.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
at sun.reflect.GeneratedMethodAccessor456.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessot oracle.retail.sim.service.ejb.PurgeServiceBean_rdzwms_PurgeServiceImpl.purgeItem(Unknown Source)
at oracle.retail.sim.service.batch.purge.PurgeItemBatchlet.doProcess(Unknown Source)
at oracle.retail.sim.service.batch.BaseBatchlet.process(Unknown Source)
at com.ibm.jbatch.container.artifact.proxy.BatchletProxy.process(BatchletProxy.java:33)
at com.ibm.jbatch.container.impl.BatchletStepControllerImpl.invokeBatchlet(BatchletStepControllerImpl.java:80)
at com.ibm.jbatch.container.impl.BatchletStepControllerImpl.invokeCoreStep(BatchletStepControllerImpl.java:108)
at com.ibm.jbatch.container.impl.BaseStepControllerImpl.execute(BaseStepControllerImpl.java:149)
at com.ibm.jbatch.container.impl.ExecutionTransitioner.doExecutionLoop(ExecutionTransitioner.java:112)
at com.ibm.jbatch.container.impl.JobThreadRootControllerImpl.originateExecutionOnThread(JobThreadRootControllerImpl.java:110)
at com.ibm.jbatch.container.util.BatchWorkUnit.run(BatchWorkUnit.java:80)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at weblogic.work.concurrent.TaskWrapper.call(TaskWrapper.java:151)
at weblogic.work.concurrent.future.AbstractFutureImpl.runTask(AbstractFutureImpl.java:391)
at weblogic.work.concurrent.future.AbstractFutureImpl.doRun(AbstractFutureImpl.java:436)
at weblogic.work.concurrent.future.ManagedFutureImpl.run(ManagedFutureImpl.java:28)
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)

BATCH_DATA_ERROR

ORA-02292: integrity constraint (SIM01.RELATED_ITEM_FK1) violated - child record found[item id] C1701


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Data Setup:

Item C1701 in STATUS D

RELATED_ITEM table has a record with Item X linked to C1701 in RELATED_ITEM_ID column.

1. Run the Cleanup Items batch job.

Batch fails with error.


ORA-02292: integrity constraint (SIM01.RELATED_ITEM_FK1) violated - child record found[item id] C1701


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the items in status D to purge via the scheduled nightly batch job.

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.