oracle - ora-24033 : no recipent for message has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT -
i using oracle e-business suite r12.1 , 11g database version.
error encountered when trying create or modify user or responsibility:
ora-24033 : no recipent message has been detected in fnd_user_resp_groups_api.update_assignment
my workaround: have followed oracle metalink doc (doc id 358151.1)to fix error. whenever try first step (dropping existing subscriper), gives error:
error @ line 1:
ora-04020: deadlock detected while trying lock object 30x0c2abe5980x0c798b3f80x0d9ca49d8
ora-06512: @ "sys.dbms_aqadm_sys", line 7541
ora-06512: @ "sys.dbms_aqadm", line 441
ora-06512: @ line 5
so, have fix ora-04020 can later able recreate existing subscriper (by dropping the existing 1 ,then adding new one).
- i tried bounce applications , database.
- i compiled apps schema.
i tried find out lock , schema blocking other can kill session:
sql> select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine v$locked_object , v$session b, dba_objects c b.sid = a.session_id , a.object_id = c.object_id;
owner object_name object_type sid serial# status ----- ------------- ---------- ------ ------- ----------- applsys fnd_concurrent_queues table 152 3 inactive applsys fnd_concurrent_requests table 466 7 inactive
then tried find out session blocking other kill it:
sql>select l1.sid ||' blocking '|| l2.sid v$lock l1, v$lock l2 l1.block =1 , l2.request > 0 , l1.id1=l2.id1 , l1.id2=l2.id2;
but got no returned rows.
some of suggestions in internet state deadlock occurs when there invalid objects in database.
so, did next is: re-compiled invalid objects running $oracle_home/rdbms/admin/utlrp.sql
that script returned output. following part of output:
error @ line 1:
ora-04063: package body "sys.utl_recomp" has errors
ora-06508: pl/sql: not find program unit being called: "sys.utl_recomp"
ora-06512: @ line 4
and part of output also:
objects errors
-------------------
1
note: facing issue after applying patch. , it's been on 5 days since deadlock detected, though of suggestions regarding deadlock says oracle manage release itself. explicit release not required.
any idea on how solve issue? suggestion appreciated.
i write solution here might encounter such error in future.
i solved error re-compiling invalid objects.
Comments
Post a Comment