My Oracle Support Banner

PurgeItem.sh Fails with Error ORA-02292: Integrity Constraint (WAREHOUSE_ITEM_FK1) (Doc ID 2018933.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Store Inventory Management (SIM), the PurgeItem.sh batch fails with error "ORA-02292: integrity constraint (WAREHOUSE_ITEM_FK1) violated."  The following additional information appears in the sim.log file: 

ERROR-65 User: [BATCH_CLIENT] Time: 6/1/15 11:09 AM Type: SimServerException Message: Error querying stored procedure. Root Cause: Error querying stored procedure.

oracle.retail.sim.common.core.SimServerException: Error querying stored procedure.

at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeReadStoredProcedure(Unknown Source)

at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeReadStoredProcedure(Unknown Source)

at oracle.retail.sim.server.dataaccess.daoimpl.PurgeOracleDao.purgeItem(Unknown Source)

at oracle.retail.sim.service.batch.BatchServerServices.purgeItem(Unknown Source)

at oracle.retail.sim.service.ejb.BatchBean.purgeItem(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)

at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)

at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)

 

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
References


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