Wednesday, August 30, 2017

After modifying Workflow Package getting below error ORA-00054: resource busy and acquire with NOWAIT

After modifying Workflow Package getting below error ORA-00054: resource busy and acquire with NOWAIT


After modifying any workflow package, while approving or acting on the notification getting below error.

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 
ORA-06512: at "APPS.WF_NOTIFICATION", line 5137 ORA-06512: at line 1

It is due to the old state of the existing code creating this error.

Resolution:

1. Clear the old session locking up the old objects.

a. Search the session
select s.*
from gv$access a, gv$session s
where object IN ('AP_WORKFLOW_PKG')
and a.inst_id=s.inst_id
and a.sid=s.sid
order by logon_time;
b. Kill the session ( Restart workflow and OPMN, will clear most of them )
2. Bounce the database

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...