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.

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.


Changes

 

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