My Oracle Support Banner

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

Last updated on OCTOBER 07, 2021

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

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

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.