4 Replies Latest reply on Apr 22, 2019 4:01 AM by Beauty_and_dBest

    adop phase=apply apply_mode=downtime patches=21900901

    Beauty_and_dBest

      Upgrading EBS 12.0.6 to 12.2.6

      12c

      OL6

       

       

       

      Hi  ALL,

       

      We  are now in the final stage of the upgrade in our PROD instance, installing RUP 12.2.6

       

      $ adop phase=apply apply_mode=downtime patches=21900901

       

      But we hit this error:

       

      FAILED: file apssu.odf

      on worker  2 for product ap  username AP.

       

      Evaluating symbolic arguments for worker 2

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

       

      Time is: Thu Apr 18 2019 12:03:00

       

       

      Done reading jobs from FND_INSTALL_PROCESSES table ...

       

      Telling workers to read 'todo' restart file.

      Done.

       

      ATTENTION: All workers either have failed or are waiting:

       

                 FAILED: file apssu.odf    on worker  2.

       

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

       

      Current time is: Thu Apr 18 2019 12:03:00

       

       

      Telling workers to quit...

       

      1 worker has quit.  Waiting for 63 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

       

       

       

       

       

      We also hit this before in our CRP upgrade instance , but we were able to resolve the issue using

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

       

      Run > ap_awt_buckets_duplicate_fix.sql

       

      And create index:

       

      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;

       

       

      But this time it did not work.


      Please help...

       

       

       

      Kind regards,