7 Replies Latest reply on Oct 4, 2018 10:09 AM by Beauty_and_dBest

    RUP 12.2.6 -The index cannot be created as the table has duplicate keys.

    Beauty_and_dBest

      Upgrade EBS 12.0.6  to 12.2.7

       

      Oracle® E-Business Suite

      Upgrade Guide

      Release 12.0 and 12.1 to 12.2

      Part No. E73540-04

      July 2018

       

       

      Hi ALL,

       

      In page 128, section 4-66 Oracle E-Business Suite Upgrade Guide, mentioned below requirement.

       

      I have applied RUP 12.2.6 using command below:

       

      $ adop phase=apply apply_mode=downtime patches=21900901 patchtop=/UPGRADE_PATCH_APP

       

      But I got error:

       

      Applying patch 21900901.

          Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/3/20181003_184021/apply/oraapps-2/21900901/log/u21900901.log

       

      AutoPatch error:

       

      Error running SQL and EXEC commands in parallel

       

       

      You should check the file

      /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/3/20181003_184021/apply/oraapps-2/21900901/log/u21900901.log

      for errors.

       

          [UNEXPECTED]Error occurred executing "adpatch  workers=16   options=hotpatch     console=no interactive=no  defaultsfile=/u01/oracle/PPAPROD/fs1/EBSapps/appl/admin/PPAPROD/adalldefaults.txt patchtop=/UPGRADE_PATCH_APP/21900901 driver=u21900901.drv logfile=u21900901.log"

          [UNEXPECTED]Refer to the log files for more information.

          [UNEXPECTED]Apply phase has failed.

          [UNEXPECTED]Unable to find appltop_id for host oraapps-2 in database

          [UNEXPECTED]Unable to find appltop_id for host oraapps-2 in database

      *******FATAL ERROR*******

      PROGRAM : (/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Wed Oct  3 20:27:17 2018

      FUNCTION: ADOP::CommonUtil::getAppltopId [ Level 1 ]

      ERRORMSG: Unable to find appltop_id for host oraapps-2 in database

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      "adopscanlog -latest=yes"

       

      to get the list of the log files along with snippet of the error message corresponding to each log file.

       

      adop exiting with status = 1 (Fail)

      ================================

       

      Completed: file popo.odf on worker  9 for product po  username PO.

       

      Time is: Wed Oct 03 2018 20:27:01

      ATTENTION: All workers either have failed or are waiting:

       

             FAILED: file apssu.odfon worker  4.

       

      ATTENTION: Please fix the above failed worker(s) so the manager can continue.

      Current time is: Wed Oct 03 2018 20:27:01

       

      Telling workers to quit...

       

      1 worker has quit.  Waiting for 15 more.

      4 workers have quit.  Waiting for 12 more.

      5 workers have quit.  Waiting for 11 more.

      7 workers have quit.  Waiting for 9 more.

      8 workers have quit.  Waiting for 8 more.

      9 workers have quit.  Waiting for 7 more.

      11 workers have quit.  Waiting for 5 more.

      14 workers have quit.  Waiting for 2 more.

      15 workers have quit.  Waiting for 1 more.

       

      All workers have quit.

       

      Connecting to APPS......Connected successfully.

       

      AutoPatch error:

       

      Error running SQL and EXEC commands in parallel

       

      Freeing includes hash table

      Freeing fixes hash table

      Freeing basedons hash table

      Freeing entities hash table

       

       

       

       

      Please help....

       

      Kind regards,

      jc

        • 1. Re: Unable to find appltop_id for host oraapps-2 in database
          Beauty_and_dBest

          Hi Michael, David, & ALL,

           

          I checked below:

           

          SQL> select count(*) from FND_OAM_CONTEXT_FILES;

           

            COUNT(*)

          ----------

                   9

           

          SQL> select node_name from FND_OAM_CONTEXT_FILES;

           

          NODE_NAME

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

          *NULL*

          *NULL*

          *NULL*

          *NULL*

          *NULL*

          *NULL*

          *NULL*

          *NULL*

          *NULL*

           

          9 rows selected.

           

           

          Why is my node_name null

           

           

          I already run autoconfig on DB and APPS tiers.

           

           

          Please help....

           

           

          Kind regards,

          • 2. Re: Unable to find appltop_id for host oraapps-2 in database
            Beauty_and_dBest

            Hi all,

             

            I done solution below:

            ================

            Investigation Done

            Old definition for FND_OAM_CONTEXT_FILES and FND_NODES synonyms in apps schema

            Dont's

            Do NOT run the following since its applicable prior to R12.2 versions only:

            + MOS Doc Id 260887.1 to delete all data from system tables such as FND_NODES, FND_OAM_CONTEXT_FILES through the execution of following SQL:

            SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
            COMMIT;
            EXIT;

            Resolution

            Step 1. Please recreate the synonyms :
            drop synonym apps.fnd_nodes;
            create synonym apps.fnd_nodes for applsys.fnd_nodes;
            drop synonym apps.fnd_oam_context_files;
            create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

            Step 2. Change the worker status to restart using adcrtl utility

            Step 3. Restart the patch:
            adop phase=apply apply_mode=downtime patches=19676458 abandon=no restart=yesBut still the workder failed:

            Telling workers to read 'todo' restart file.

            Done.

            Restarted: file apssu.odf    on worker  4 for product ap  username AP.

             

            Time is: Wed Oct 03 2018 22:06:41

             

               FAILED: file apssu.odf    on worker  4 for product ap  username AP.

             

            Time is: Wed Oct 03 2018 22:06:44

             

             

            ATTENTION: All workers either have failed or are waiting:

             

                       FAILED: file apssu.odf    on worker  4.

             

            ATTENTION: Please fix the above failed worker(s) so the manager can continue.

             

            Current time is: Wed Oct 03 2018 22:06:44

             

            Telling workers to quit...

             

            1 worker has quit.  Waiting for 15 more.

             

            All workers have quit.

             

            *******************************************************

            The table is missing the index AP_AWT_BUCKETS_U1

            or index AP_AWT_BUCKETS_U1 exists on another table.

            Create it with the statement:

             

            Start time for statement below is: Wed Oct 03 2018 22:06:41

             

            CREATE UNIQUE INDEX AP."AP~AWT~BUCKETS~U1" ON AP.AP_AWT_BUCKETS_ALL

            (ORG_ID, VENDOR_ID, TAX_NAME, PERIOD_NAME) LOGGING STORAGE (FREELIST

            GROUPS 4 FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE

            STATISTICS   ONLINE TABLESPACE APPS_TS_TX_IDX

             

            Statement executed.

             

            AD Worker error:

            The index cannot be created as the table has duplicate keys.

             

            Use the following SQL statement to identify the duplicate keys:

             

            SELECT ORG_ID, VENDOR_ID, TAX_NAME, PERIOD_NAME, count(*)

              FROM AP.AP_AWT_BUCKETS_ALL

            GROUP BY ORG_ID, VENDOR_ID, TAX_NAME, PERIOD_NAME

               HAVING count(*)>1

             

            AD Worker error:

            Unable to compare or correct tables or indexes or keys

                    because of the error above

             

            Time when worker failed: Wed Oct 03 2018 22:06:44

             

             

            Is it okay to backup and delete the duplicate rows?

             

            Please help...Kind regards,

            • 3. Re: RUP 12.2.6 -The index cannot be created as the table has duplicate keys.
              mdtaylor

              Hi jc,

               

              The following note has a fix script for this issue at the bottom of the note.

               

              R12: New Functionality Invoice Validation Parallel Processing (Doc ID 1917614.1)

               

              Regards,

              Michael

              • 4. Re: RUP 12.2.6 -The index cannot be created as the table has duplicate keys.
                Beauty_and_dBest

                Thanks Michael,

                 

                Will check it now....brb

                • 5. Re: RUP 12.2.6 -The index cannot be created as the table has duplicate keys.
                  Beauty_and_dBest

                  Hi Michael,

                   

                  I patch is now resumed running,

                  Hoping it will not stumble again.

                   

                   

                  By the way, what is the difference if I apply the patch in "hotpatch=yes"     againts  "apply-mode=downtime"

                  Assuming that the appstier is down?

                   

                   

                  Kind regards,

                  • 6. Re: RUP 12.2.6 -The index cannot be created as the table has duplicate keys.
                    mdtaylor

                    Hi jc,

                     

                    In 12.2, hotpatch=yes is a patching mode with the AdminServer up that directly patches the run filesystem most commonly used in 12.2.0 upgrade scenarios.  Downtime=yes is similar but the AdminServer is down.

                     

                    Both modes should only be used if directed by the patch readme or support.oracle.com note you are following.

                     

                    Regards,

                    Michael

                    • 7. Re: RUP 12.2.6 -The index cannot be created as the table has duplicate keys.
                      Beauty_and_dBest

                      Thanks!

                       

                       

                      Do I need to run   cleanup, and fs_clone   after running  hotpatch or downtime mode?