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 MAY 30, 2019

Applies to:

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

Symptoms


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

Error
-----------------------

"java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:278)
  at com.retek.platform.service.ServiceAccessor.callRemoteMethod(ServiceAccessor.java:273)
  at com.retek.platform.service.ServiceAccessor.directRemoteTransaction(ServiceAccessor.java:504)
  at com.retek.platform.service.ServiceAccessorProxy.invoke(ServiceAccessorProxy.java:45)
  at com.sun.proxy.$Proxy1.initializeNewItemLocProcess(Unknown Source)
  at com.retek.rpm.batch.NewItemLocBatch$2.getBatchProcessUnitsOfWork(NewItemLocBatch.java:188)
  at com.retek.rpm.batch.MultistepMultithreadBatch$AThreadedBatchProcess.perform(MultistepMultithreadBatc h.java:179)
  at com.retek.rpm.batch.MultistepMultithreadBatch.process(MultistepMultithreadBatch.java:442)
  at com.retek.rpm.batch.RpmBatch.process(RpmBatch.java:76)
  at com.retek.rpm.batch.RpmBatch.execute(RpmBatch.java:45)
  at com.retek.rpm.batch.NewItemLocBatch.main(NewItemLocBatch.java:36)
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.


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


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