1 2 Previous Next 21 Replies Latest reply on Jul 24, 2017 8:17 PM by 2611206

    Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52

    2611206

      Folks,

       

      Running EBS 12.2.3, against DB 11.2.0.4.

       

      I started a adop phase=prepare and had an error, say that autoconfig run errored out.

       

      I tried running autoconfig on the Run File System.-- 

      Got this error message

       

      Enter value for 1: Enter value for 2: Enter value for 3: Connected.

      2120 begin

      2121 *

      2122 ERROR at line 1:

      2123 ORA-01422: exact fetch returns more than requested number of rows

      2124 ORA-06512: at "APPS.ADX_PRF_PKG", line 52

      2125 ORA-06512: at line 6

       

      In the autoconfig log file.

       

      The table FND_PROFILE_OPTIONS_VALUE returns 2 rows for this query

       

      select * from FND_PROFILE_OPTION_VALUES

      where APPLICATION_ID=0

      and PROFILE_OPTION_VALUE='noprint'

      and LEVEL_ID=10001;

       

       

            

      010910001010/3/2000 17:23110/3/2000 17:231-1noprint0V_20160624_1030
      010910001010/3/2000 17:23110/3/2000 17:231-1noprint0V_20170711_2202

       

       

      So which row should I delete ?

       

      Thanks

       

      Ashish

        • 1. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
          2611206

          Folks,

           

          I deleted the 2nd row from FND_PROFILE_OPTIONS_VALUE table,

           

          2","0","109","10001","0","10/3/2000 5:23:33 PM","1","10/3/2000 5:23:33 PM","1","-1","noprint","0","","V_20170711_2202"

           

          -----------

           

           

           

          Still getting the same error again, when I run the autoconfig on the Run File System.

           

          I had committed after the delete.

           

          Thanks

           

           

          SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 12 14:02:23 2017

           

           

          Copyright (c) 1982, 2005, Oracle.  All rights reserved.

           

           

          Enter value for 1: Enter value for 2: Enter value for 3: Connected.

          begin

          *

          ERROR at line 1:

          ORA-01422: exact fetch returns more than requested number of rows

          ORA-06512: at "APPS.ADX_PRF_PKG", line 52

          ORA-06512: at line 6

          • 2. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
            Prashant Umap

            Hello,

             

            Can you check this note -

            AutoConfig Fails On Applications Tier In R12.2.0 EBS (Doc ID 1912332.1)

             

            Prashant Umap

            • 3. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
              2611206

              Hello Prashant,

               

              Thanks for your reply.

               

              I had reviewed the Doc id 1912332.1, but it does not apply in my case, as that column  LEVEL_VALUE2 is already there in the ADX_PRE_AUTOCONFIG  table.

               

              I think I know what the issue is,  i believe i have extra row in FND_PROFILE_OPTION_VALUES and ADOP_VALID_NODES table.

              Here is what i believe the issue is:

               

              SQL> select * from dba_editions;

               

               

              EDITION_NAME                   PARENT_EDITION_NAME            USA

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

              ORA$BASE                                                      YES

              V_20170711_2202                ORA$BASE                       YES

               

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

               

              But in the FND_PROFILE_OPTION_VALUES table and ADOP_VALID_NODES table, i have this row

               

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

              0 109 10001 0 03-OCT-00 1 03-OCT-00 1 -1 noprint 0 V_20160624_1030

               

              and in ADOP_VALID_NODES

               

              NODE_NAME                      CONTEXT_NAME                                       ZD_EDITION_NAME

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

              dvcpap01                       VCPD1_dvcpap01                                     V_20170711_2202

              dvcpap01                       VCPD1_dvcpap01                                    V_20160614_1259

               

               

              I believe the row containing V_20160614_1259 and V_20160624_1030 , needs to be deleted.

               

              Any input etc ?

               

              Thanks

              • 4. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                Prashant Umap

                Can you upload full log of adautocfg.

                 

                Prashant Umap

                • 5. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                  Prashant Umap

                  Also check this MOS -

                  Autoconfig Error: ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2212698.1)

                   

                  Prashant Umap

                  • 6. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                    2611206

                    Hello Prashant,

                     

                    Thanks for the reply.

                     

                    I deleted the rows in FND_PROFILE_OPTION_VALUES table , that had entry for the ZD_EDITION = V_20160624_1030

                     

                    AND also 1 row from AD_VALID_NODES that entry pertaining to ZD_EDITION=V_20160614_1259.

                     

                    As these DB editions are no longer there:

                    SQL> select * from dba_editions;

                     

                     

                    EDITION_NAME                   PARENT_EDITION_NAME            USA

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

                    ORA$BASE                                                      YES

                    V_20170711_2202                ORA$BASE                       YES

                     

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

                     

                    As you can see, there are no entries for V_20160624_1030 nor for V_20160614_1259 in DBA_EDITIONS.

                     

                    ----

                     

                    Ran the autoconfig again in Run FS and now I get this error.

                     

                     

                    Enter value for 1: Enter value for 2: Enter value for 3: Connected.

                    begin

                    *

                    ERROR at line 1:

                    ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error

                    ORA-06512: at "APPS.WF_EVENT", line 3698

                    ORA-06512: at "APPS.FND_WF_ENGINE", line 1025

                    ORA-06512: at "APPS.FND_PROFILE", line 1001

                    ORA-06512: at "APPS.FND_PROFILE", line 2252

                    ORA-06512: at "APPS.ADX_PRF_PKG", line 192

                    ORA-06512: at line 6

                     

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

                     

                    I looked at the WF_RESOURCES table and it has entries for ZD_EDITIONS = V_20160624_1030  .

                     

                    I think I should delete those rows from WF_RESOURCES, that has entries of ZD_EDITIONS = V_20160624_1030, which is no longer relevant ?

                     

                    I can post the autoconfig log , if you want.

                     

                    Thanks

                    Ashish

                     

                     

                    • 7. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                      mdtaylor

                      Please run adop -status from the command line.  Are you in the middle of an adop patching cycle?

                      • 8. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                        Prashant Umap

                        Yes please also check the above MOS and adop -status as suggested by mdtaylor.

                         

                        Prashant

                        • 9. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                          2611206

                          Hello Prasant & MDTAYLOR,

                           

                          Yes, I was trying to apply an adop patch, i was in the prepare phase, then this error occurred and the system went down.

                           

                          applmgr@dvcpap01:/u02/mclvcp/VCPD1/fs_ne/EBSapps/log/adop/25> adop -status

                          Enter the APPS password:

                          Current Patching Session ID: 27

                           

                           

                          Node Name       Node Type       Phase           Status          Started                        Finished                       Elapsed

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

                          dvcpap01        master          PREPARE         FAILED          11-JUL-17 22:00:26 -05:00      11-JUL-17 22:39:47 -05:00      0:39:21

                                                          APPLY           NOT STARTED

                                                          FINALIZE        NOT STARTED

                                                          CUTOVER         NOT STARTED

                                                          CLEANUP         NOT STARTED

                           

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

                           

                          I can run autoconfig from Run FS, while doing adop phase=prepare (which ended in the failure, do you autoconfig error)

                           

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

                           

                          Is it okay to run autoconfig in Run FS, while adop phase=prepare is in failed status or should I first do

                           

                          adop phase=abort and then try to run Autoconfig in Run FS.

                           

                          Also that MOS, 2212698.1 is not relevant for me, as I am 12.2.3 and that procedure is not there

                           

                          SQL> sELECT ad_zd_adop.get_node_type('DVCPAP01') from dual;

                          sELECT ad_zd_adop.get_node_type('DVCPAP01') from dual

                                 *

                          ERROR at line 1:

                          ORA-00904: "AD_ZD_ADOP"."GET_NODE_TYPE": invalid identifier

                           

                          -------

                           

                          Thanks Folks

                          • 10. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                            Prashant Umap

                            Please do this now -

                            1. Shutdown the application if its running.

                            2. Abort the patching cycle phase

                            $ adop phase=abort

                            $ adop phase=cleanup cleanup_mode=full

                            3. Run adadutoconfig

                            - If any error in adautocfg will take it from there.

                             

                            Prashant Umap

                            • 11. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                              2611206

                              Hello Prashant,

                              I appreciate all your help.

                               

                              You mentioned

                               

                              1. Shutdown the application if its running.

                              2. Abort the patching cycle phase

                              $ adop phase=abort

                              $ adop phase=cleanup cleanup_mode=full

                               

                              -----------

                               

                              My application is already down.

                               

                               

                              Please don't mind my asking this question, can I do this directly , after step 3, phase=abort,

                               

                              run adop phase=cleanup cleanup_mode=full  

                               

                              No another step before it ??

                               

                              Thanks

                              • 13. Re: Getting an error while running autoconfig -- ORA-06512: at "APPS.ADX_PRF_PKG", line 52
                                2611206

                                Basically , run this steps with these parameters

                                 

                                2. Abort the patching cycle phase

                                $ adop phase=abort

                                $ adop phase=cleanup cleanup_mode=full

                                 

                                 

                                Right ?

                                 

                                Thanks

                                1 2 Previous Next