The NewItemLocBatch (NIL) Fails with ORA-00054 Error When Processing About 8 Million Records

(Doc ID 2322150.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle Retail Price Management - Version 16.0.1 and later
Information in this document applies to any platform.


There are around 7.7 million records present in RPM_STAGE_ITEM_LOC that needs to be processed. The New Item Loc Batch (NIL) fails with below error


  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  at java.lang.reflect.Method.invoke(
  at org.apache.commons.beanutils.MethodUtils.invokeMethod(
  at com.retek.platform.service.ServiceAccessor.callRemoteMethod(
  at com.retek.platform.service.ServiceAccessor.directRemoteTransaction(
  at com.retek.platform.service.ServiceAccessorProxy.invoke(
  at com.sun.proxy.$Proxy1.initializeNewItemLocProcess(Unknown Source)
  at com.retek.rpm.batch.NewItemLocBatch$2.getBatchProcessUnitsOfWork(
  at com.retek.rpm.batch.MultistepMultithreadBatch$AThreadedBatchProcess.perform(MultistepMultithreadBatc
  at com.retek.rpm.batch.MultistepMultithreadBatch.process(
  at com.retek.rpm.batch.RpmBatch.process(
  at com.retek.rpm.batch.RpmBatch.execute(
  at com.retek.rpm.batch.NewItemLocBatch.main(
Caused by:

  No cause associated

[null, null, Error ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired retur ned by program unit RPM_NEW_ITEM_LOC_SQL.INITIALIZE_PROCESS.]

  No cause associated

[null, null,

  No cause associated"

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Run the NIL with about 8 million records.
2. Notice the error.




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