My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.