My Oracle Support Banner

ItemPriceToHistory.sh Batch Aborts with Error "oracle.retail.sim.common.core.SimServerException" (Doc ID 2055699.1)

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

In Oracle Retail Store Inventory Management (SIM) 14.0.x, when attempting to run batch ItemPriceToHistory.sh, the following error occurs:

ORA-01438: value larger than specified precision allows for this column


The SIM log shows the following error:

"2015-07-15 19:07:32,907 ERROR [main][job.ItemPriceToHistoryJob] Exception: java.util.concurrent.ExecutionException: oracle.retail.sim.common.core.SimServerException: Error processing concurrent batch record: ItemPriceToHistoryJob(storeId: 41)
java.util.concurrent.ExecutionException: oracle.retail.sim.common.core.SimServerException: Error processing concurrent batch record: ItemPriceToHistoryJob(storeId: 41)
at java.util.concurrent.FutureTask.report(FutureTask.java:133)
at java.util.concurrent.FutureTask.get(FutureTask.java:199)
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.ItemPriceToHistoryJob.processConcurrently(Unknown Source)
at oracle.retail.sim.batch.job.ItemPriceToHistoryJob.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: ItemPriceToHistoryJob(storeId: 41)
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.run(FutureTask.java:273)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1176)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:853)
Caused by: oracle.retail.sim.common.core.SimServerException: Error executing stored procedure.
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
at oracle.retail.sim.service.ejb.BatchBean_7tf6f4_BatchInterfaceImpl_1036_WLStub.itemPriceToHistory(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
at com.sun.proxy.$Proxy5.itemPriceToHistory(Unknown Source)
at oracle.retail.sim.service.batch.BatchEJBServices.itemPriceToHistory(Unknown Source)
at oracle.retail.sim.batch.job.ItemPriceToHistoryJob$1.doUnitOfWork(Unknown Source)
... 6 more
Caused by: oracle.retail.sim.common.core.SimServerException: Error executing stored procedure.
at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeStoredProcedure(Unknown Source)
at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeStoredProcedure(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.ItemPriceOracleDao.itemPriceToHistory(Unknown Source)
at oracle.retail.sim.service.batch.BatchServerServices.itemPriceToHistory(Unknown Source)
at oracle.retail.sim.service.ejb.BatchBean.itemPriceToHistory(Unknown Source)"


Steps to Reproduce:

  1. Run batch ItemPriceToHistory.sh
  2. Observe the above error

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
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.