Purge Item Price Batch Fails in SIM with Concurrent Execution Exception (Doc ID 2114910.1)

Last updated on MARCH 15, 2016

Applies to:

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

Symptoms

In Store Inventory Management (SIM) application, we find that PurgeItemPrice.sh bath fails with the following error:

ERROR [main][job.PurgeItemPriceJob] Exception: java.util.concurrent.ExecutionException: oracle.retail.sim.common.core.SimServerException: Error processing concurrent batch record: PurgeItemPriceJob(storeId: XXXX)
java.util.concurrent.ExecutionException: oracle.retail.sim.common.core.SimServerException: Error processing concurrent batch record: PurgeItemPriceJob(storeId: XXXX)
  at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
  at java.util.concurrent.FutureTask.get(FutureTask.java:XXXX)
  at oracle.retail.sim.batch.core.SimBatch.executeConcurrentBatch(Unknown Source)
  at oracle.retail.sim.batch.core.SimBatch.executeConcurrentBatch(Unknown Source)
  at oracle.retail.sim.batch.job.PurgeItemPriceJob.processConcurrently(Unknown Source)
  at oracle.retail.sim.batch.job.PurgeItemPriceJob.doExecute(Unknown Source)
  at oracle.retail.sim.batch.core.SimBatch.execute(Unknown Source)
  at oracle.retail.sim.batch.core.SimBatchRunner.main(Unknown Source)
Caused by: oracle.retail.sim.common.core.SimServerException: Error processing concurrent batch record: PurgeItemPriceJob(storeId: XXXX)
  at oracle.retail.sim.batch.core.BatchCallable.call(Unknown Source)
  at oracle.retail.sim.batch.core.BatchCallable.call(Unknown Source)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:724)
Caused by: oracle.retail.sim.common.core.SimServerException: Error querying stored procedure.
  at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
...
...
...

where XXXX is the store id.


Steps to recreate:

1. Ensure the following system admin parameter values are set:
    DAYS_TO_HOLD_PRICE_CHANGE_WORKSHEET
    DAYS_TO_HOLD_PRICE_HISTORY
    DAYS_TO_HOLD_EXPIRED_PRICE
2. Run the "PurgeItemPrice.sh" batch from SIM server batch location and observe the batch failing with the above error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms