SAPREPOST batch is getting failed for SAPURGE with RESOURCE BUSY error
Hi,
SAPREPOST batch for SAPURGE is getting failed regularly in the nightly job run for last 2 week with the error:
alter_constraints~SA_EXPORT_LOG~-54~ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired~ALTER TABLE RMS14DEV.SA_EXPORT_LOG MODIFY CONSTRAINT PK_SA_EXPORT_LOG DISABLE CASCADE KEEP INDEX
From other post of Oracle we have found that this resource busy error occurs while the SAPREPOST batch runs with the ReSA front end screen being kept open for more than 2 hours.
But in this case while we are trying to find out the session lock details ,we are not finding any lock present and this failure is occurring for last 2 week.