ORA-04030: Out of Process Memory Error While Executing the Batch ActivatePriceChanges.sh (Doc ID 1419815.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 13.0 to 13.0.5.2 [Release 13.0]
Information in this document applies to any platform.

Symptoms

When executing the batch ActivatePriceChanges.sh, the batch fails with the following error:

[main][batchjob.ActivatePriceChangeJob] ActivatePriceChangeJob Failed: 0 <
ERROR-326 User: BATCH Time: 11/11/11 2:50 AM Type: SimServerException Message: Error from procedure: activatepricechanges - ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pl/sql vc2)>
oracle.retail.sim.closed.common.SimServerException: Error from procedure: activatepricechanges - ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pl/sql vc2)
at com.evermind.server.rmi.RMICall.EXCEPTION_ORIGINATES_FROM_THE_REMOTE_SERVER(RMICall.java:110)
at com.evermind.server.rmi.RMICall.throwRecordedException(RMICall.java:128)
at com.evermind.server.rmi.RMIClientConnection.obtainRemoteMethodResponse(RMIClientConnection.java:472)
at com.evermind.server.rmi.RMIClientConnection.invokeMethod(RMIClientConnection.java:416)
at com.evermind.server.rmi.RemoteInvocationHandler.invoke(RemoteInvocationHandler.java:63)
at com.evermind.server.rmi.RecoverableRemoteInvocationHandler.invoke(RecoverableRemoteInvocationHandler.java:28)
at com.evermind.server.ejb.StatelessSessionRemoteInvocationHandler.invoke(StatelessSessionRemoteInvocationHandler.java:43)
at __Proxy1.activatePriceChangeByDateStr(Unknown Source)
at oracle.retail.sim.closed.batch.BatchEJBServices.activatePriceChangeByDateStr(BatchEJBServices.java:100)
at oracle.retail.sim.closed.batch.BatchHelper.activatePriceChangeByDateStr(BatchHelper.java:35)
at oracle.retail.sim.closed.batchjob.ActivatePriceChangeJob.activate(ActivatePriceChangeJob.java:57)
at oracle.retail.sim.closed.batchjob.ActivatePriceChangeJob.run(ActivatePriceChangeJob.java:38)
at oracle.retail.sim.closed.batch.SimBatchRunner.run(SimBatchRunner.java:39)
at oracle.retail.sim.closed.batchjob.ActivatePriceChangeJob.main(ActivatePriceChangeJob.java:97)




Steps to Reproduce:

  1. Execute ActivatePriceChanges.sh with a large volume of data
  2. Notice that the batch fails with "out of process memory" 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