Third Party Stock Count Import Batch Job Fails During Authorization With Large Data Volumes (Doc ID 2808194.1)

Last updated on JUNE 30, 2023

Applies to:

Symptoms

When attempting to run the Third Party Stock Count Import job with product group created for all departments in the stores and auto auto-authorization turned on, the job fails and the following error occurs.

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

oracle.retail.sim.common.core.SimServerException: Error executing statement. SQLSyntaxErrorException(2051): ORA-02051: another session or branch in same transaction failed or finalized

at oracle.retail.sim.server.dataaccess.BaseOracleDao.execute(Unknown Source)
at oracle.retail.sim.server.dataaccess.BaseOracleDao.execute(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.StockCountChildOracleDao.clearUinProblemLineIndicator(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.StockCountChildOracleDao$Proxy$_$$_WeldClientProxy.clearUinProblemLineIndicator(Unknown Source)
at oracle.retail.sim.service.stockcount.MarkStockCountChildAsApprovedCommand.doExecute(Unknown Source)
at oracle.retail.sim.service.core.ServerCommand.execute(Unknown Source)
at oracle.retail.sim.service.stockcount.MarkStockCountChildAsApprovedHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.stockcount.MarkStockCountChildAsApprovedHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.core.BaseServiceHandler.execute(Unknown Source)
at oracle.retail.sim.service.stockcount.StockCountChildServiceImpl.markStockCountChildApproved(Unknown Source)
at oracle.retail.sim.service.stockcount.StockCountChildServiceImpl$Proxy$_$$_WeldClientProxy.markStockCountChildApproved(Unknown Source)
at oracle.retail.sim.service.stockcount.ThirdPartyProcessLoadedCountHandler.handleAutoAuthorize(Unknown Source)
at oracle.retail.sim.service.stockcount.ThirdPartyProcessLoadedCountHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.stockcount.ThirdPartyProcessLoadedCountHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.core.BaseServiceHandler.execute(Unknown Source)
at oracle.retail.sim.service.batch.OperationalBatchServiceImpl.processLoadedThirdPartyStockCount(Unknown Source)
at oracle.retail.sim.service.batch.OperationalBatchServiceImpl$Proxy$_$$_WeldClientProxy.processLoadedThirdPartyStockCount(Unknown Source)
at oracOperationalBatchServiceImpl.processLoadedThirdPartyStockCount(Unknown Source)
at oracle.retail.sim.service.batch.stockcount.StockCountImportProcessorBatchlet.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(ComponentInvo

Steps to Reproduce:

1. Log into EICS SFTP server.
2. Place the 3rd Party Stock Count files in the from_thirdparty directory.
3. Once consumed into EICS from the SFTP, log into EICS.
4. Navigate to Admin/Technical Maintenance/Job Admin
5. Select Ad Hoc job.
6. Select Third Party Stock Count Import from Job Name list.
7. Enter the Store ID.
8. Select Start Job.
9. Job errors after about 30 min.

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.