My Oracle Support Banner

PURGE_ITEM Batch Fails with an Error (Doc ID 2232345.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

PURGE_ITEM batch in Retail Store Inventory Management fails with the error below.

 

ERROR
-----------------------
************************************************************************
** ucxjlx6m version 11.1.0+hf.1.build.1018 changelist 6505053 **
** JOB 03782322 (ProcID:0000030057) START AT 12.12.2016 / 06:46:29 **
** UTC TIME 12.12.2016 / 03:46:29 **
** TEXT=" Job started " **
************************************************************************
:../resources:../lib/commons-lang-2.6.jar:../lib/osdt_cert.jar:../lib/log4j-1.2.17.jar:../lib/cryptoj.jar:../lib/identitystore.jar:../lib/jps-api.jar:../lib/jps-internal.jar:../lib/commons-logging-1.1.3.jar:../lib/jps-unsupported-api.jar:../lib/osdt_xmlsec.jar:../lib/wlfullclient.jar:../lib/jps-common.jar:../lib/osdt_core.jar:../lib/wlcipher.jar:../lib/sim-common.jar:../lib/sim-batch.jar:../lib/oraclepki.jar
Java Environment Initialized...
Starting Batch...
java -Doracle.security.jps.config=../resources/conf/jps-config.xml oracle.retail.sim.batch.core.SimBatchRunner oracle.retail.sim.batch.job.PurgeItemJob
2016-12-12 06:46:32,505 ERROR [main][core.SimBatchRunner] Error executing batch: PurgeItemJob
ERROR-26 User: [BATCH_CLIENT] Time: 12/12/16 6:46 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)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
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.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy271.purgeItem(Unknown Source)
at oracle.retail.sim.service.ejb.BatchBean_7tf6f4_BatchInterfaceImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at oracle.retail.sim.service.ejb.BatchBean_7tf6f4_BatchInterfaceImpl.purgeItem(Unknown Source)
at oracle.retail.sim.service.ejb.BatchBean_7tf6f4_BatchInterfaceImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

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.