Retail Merchandising System (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center