9 Replies Latest reply on Apr 20, 2016 4:31 PM by Noname123

    ora-24033 : no recipent for message

    Noname123

      I am using Oracle R12.1 , 11G.

       

      Error I encountered when trying to create or modify a user or responsibility:

      ora-24033 : no recipent for message has been detected in

      FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT

       

       

      My workaround:

      I have followed this metalink doc (Doc ID 358151.1)to fix the error.  Whenever I

      I try to do the first step (droping the existing subscriper), it gives this error:

      ERROR at line 1:

      ORA-04020: deadlock detected while trying to lock object

      30x0C2ABE5980x0C798B3F80x0D9CA49D8

      ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7541

      ORA-06512: at "SYS.DBMS_AQADM", line 441

      ORA-06512: at line 5

       

       

       

       

       

       

      One of the reasons  I know is that ora-024020 occurs because of invalid objects (correct me if I am wrong)

      So what I did next is :

      *Recompiling invalid objects:

      exec dbms_utility.compile_schema('APPS', false);

      exec dbms_utility.compile_schema('APPLSYS', false);

       

       

      Then I tried to drop the existing susbscriper but  the error is persisting to show up.

      Any idea to solve that?

        • 1. Re: ora-24033 : no recipent for message
          Bashar.

          Try bouncing the application and database and then perform the procedure.

           

          If you want to compile the invalid objects then use adadmin or follow the procedure in the following link:

           

          DBA Story: Script to compile APPS schema without running adadmin

           

          Regards,

          Bashar

          • 2. Re: ora-24033 : no recipent for message
            Noname123

            1. I bounced the applications and  database.

            2. I compiled using adadmin.

            3. I did the first step mentioned in  Doc ID 358151.1 to solve  ora-24033.  But I got the

               same error when i went the form to create or modify responsiblity.

            4. I tried to compile without using adadmin by following the link you shared...

               Then I tried to "drop the existing subscriper" but I got the deadlock (same error)

            • 3. Re: ora-24033 : no recipent for message
              Noname123

              This deadlock occured after  applying patch  21271187 Bashar.
              Could re-applying the patch release the deadlock?

              • 4. Re: ora-24033 : no recipent for message
                Bashar.

                When you bounced the application and database, did you apply the solution in Doc ID 358151.1 successfully?

                 

                Regards,

                Bashar

                • 5. Re: ora-24033 : no recipent for message
                  Noname123

                  I bounced the application as well as the database , then I when I came to apply the first step of the solution in Doc ID 358151.1 ,  I got the deadlock error:

                  ORA-04020: deadlock detected while trying to lock object


                  • 6. Re: ora-24033 : no recipent for message
                    Noname123

                    I have bounced the applications and the DB again and applied the solution in  Doc ID 358151.1


                    The following is what I got when doing the first step there Bashar.

                     

                    ERROR at line 1:

                    ORA-04020: deadlock detected while trying to lock object

                    30x0C5D732900x0C5D718780x0D7FD36F0

                    ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7541

                    ORA-06512: at "SYS.DBMS_AQADM", line 441

                    ORA-06512: at line 5

                    • 7. Re: ora-24033 : no recipent for message
                      Noname123

                      Here is my workaround:  Bashar.

                       

                      sql> SELECT

                         c.owner,

                         c.object_name,

                         c.object_type,

                         b.SID,

                         b.serial#,

                         b.status,

                         b.osuser,

                         b.machine

                      FROM

                         v$locked_object a ,

                         v$session b,

                         dba_objects c

                      WHERE

                         b.SID = a.session_id

                      AND

                         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 to find out which session is blocking the other to kill it:

                       

                       

                      sql>SELECT l1.SID  ||' IS BLOCKING '|| l2.SID

                      FROM v$lock l1, v$lock l2

                      WHERE l1.BLOCK =1 AND l2.request > 0

                      AND l1.id1=l2.id1

                      AND l1.id2=l2.id2;

                       

                       

                      But I got no returned rows.

                      • 8. Re: ora-24033 : no recipent for message
                        Noname123

                        I haven't been able to create or modify responsibility in the system since I have done

                        the patch 21271187.  Although , I followed exactly what the README.txt says during the

                        patch and have done compiled the apps schema using adadmin but it seems that I cannot

                        do any update (transaction) in the system via forms because a deadlock occured. 

                        I faced the error deadlock  (ora-04020 :deadlock detected while trying to lock object)

                        when tried to remove a subscriper (following the solution in Doc ID. 358151.1).

                         

                         

                        So, one of the reasons could be because of invalid objects in the database.  Then I thought

                        of recompiling the invalid objects using utlrp.sql...

                        When I checked that script and read it's content before running it, I noticed the below content

                        in utlrp.sql :

                        NOTES

                        Rem      * This script must be run using SQL*PLUS.

                        Rem      * You must be connected AS SYSDBA to run this script.

                        Rem      * There should be no other DDL on the database while running the

                        Rem        script.  Not following this recommendation may lead to deadlocks.

                         

                         

                         

                         

                        If running utlrp.sql is required after applying any patch , then why it is not mentioned in README.txt?

                        Now my database is in deadlock state since the last five days, and I have no idea how to release that lock

                        even though most the suggestions in the internet regarding to the deadlock releasing say : "Oracle manages

                        that.  It will release it by itself.  Explict release not required".

                         

                         

                        To summarize my problem here:

                        1. I am not able to create or modify "let's say" responsibility and I face the following error:

                            ora-24033 : no recipent for message has been detected in FND_USER_RESP_GROUPS.UPDATE_ASSIGNMENT.

                        2. To solve the above error, oracle suggests to do the solution in "Doc ID. 358151.1".

                           When I tried to apply the first step of that solution, I got the following error:

                           ora-04020 :deadlock detected while trying to lock object

                           30x0C58DFD000x0DDA09F000x0D7F7EC20

                           ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7541

                           ORA-06512: at "SYS.DBMS_AQADM", line 441

                           ORA-06512: at line 5

                         

                         

                        3. Then to solve the deadlock error so I can later solve ora-24033, I attempted to run utlrp.sql

                           but that recompiling of invalid objects ended up with the below error:

                            ERROR at line 1:

                            ORA-04063: package body "SYS.UTL_RECOMP" has errors

                            ORA-06508: PL/SQL: could not find program unit being called: "SYS.UTL_RECOMP"

                            ORA-06512: at line 4

                         

                         

                           and this was part of the output also:

                            OBJECTS WITH ERRORS

                            -------------------

                                          1

                        • 9. Re: ora-24033 : no recipent for message
                          Noname123

                          I have solved the problem by recompiling invalid objects using:

                           

                          Exec UTL_RECOMP.RECOMP_SERIAL ();

                           


                          There was no need to raise SR