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 laterInformation 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)"
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:
- Run batch ItemPriceToHistory.sh
- 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 |