4 Replies Latest reply on Aug 15, 2015 1:30 AM by Chiranjeevi M A

    adop prepare phase failed

    2893577

      bash-4.1$ adopscanlog -latest=yes

       

      Scanning /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/ directory ...

       

      /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/adop_20150814_001540.log:

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

       

      Lines #(144-148):

       

        Executing "adop" action in all nodes

        [ERROR]     Node: "myserver"  Status: "failed"

        [ERROR]     Node: "myserver2"  Status: "failed"

        [ERROR]     Remote execution failed on Node: "myserver".

       

      Lines #(145-149):

        Executing "adop" action in all nodes

        [ERROR]     Node: "myserver"  Status: "failed"

        [ERROR]     Node: "myserver2"  Status: "failed"

        [ERROR]     Remote execution failed on Node: "myserver".

        [ERROR]     Remote execution failed on Node: "myserver2".

       

      Lines #(146-150):

        [ERROR]     Node: "myserver"  Status: "failed"

        [ERROR]     Node: "myserver2"  Status: "failed"

        [ERROR]     Remote execution failed on Node: "myserver".

        [ERROR]     Remote execution failed on Node: "myserver2".

        [UNEXPECTED]Remote execution on all the nodes returned failure.

       

      Lines #(147-151):

        [ERROR]     Node: "myserver2"  Status: "failed"

        [ERROR]     Remote execution failed on Node: "myserver".

        [ERROR]     Remote execution failed on Node: "myserver2".

        [UNEXPECTED]Remote execution on all the nodes returned failure.

        [UNEXPECTED]So, Unable to continue.

       

      Lines #(148-152):

        [ERROR]     Remote execution failed on Node: "myserver".

        [ERROR]     Remote execution failed on Node: "myserver2".

        [UNEXPECTED]Remote execution on all the nodes returned failure.

        [UNEXPECTED]So, Unable to continue.

        [UNEXPECTED]Error: While executing "adop" on all other nodes.

       

      Lines #(149-153):

        [ERROR]     Remote execution failed on Node: "myserver2".

        [UNEXPECTED]Remote execution on all the nodes returned failure.

        [UNEXPECTED]So, Unable to continue.

        [UNEXPECTED]Error: While executing "adop" on all other nodes.

        [UNEXPECTED]Execution failed when performing remote action.

       

      Lines #(150-154):

        [UNEXPECTED]Remote execution on all the nodes returned failure.

        [UNEXPECTED]So, Unable to continue.

        [UNEXPECTED]Error: While executing "adop" on all other nodes.

        [UNEXPECTED]Execution failed when performing remote action.

        [PROCEDURE] [START 2015/08/14 00:25:47] Check and Stop patch Admin Server

       

      Lines #(151-155):

        [UNEXPECTED]So, Unable to continue.

        [UNEXPECTED]Error: While executing "adop" on all other nodes.

        [UNEXPECTED]Execution failed when performing remote action.

        [PROCEDURE] [START 2015/08/14 00:25:47] Check and Stop patch Admin Server

          [EVENT]     [START 2015/08/14 00:25:48] Check and Stop patch FS Admin Server

       

      /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_001540/myinstance_myserver/remote_execution_result_20150814_001629.xml:

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

       

      /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_001540/myinstance_myserver/remote_execution_result_20150814_001815.xml:

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

       

      /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_001540/myinstance_myserver/remote_execution_result_20150814_002026.xml:

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

      Status of remote command on Node myserver is failed.

      Error string was found in the above file.

      Please check the adoplog files created in myserver for more details.

       

      Status of remote command on Node myserver is failed.

      Unexpected string was found in the above file.

      Please check the adoplog files created in myserver for more details.

       

      Status of remote command on Node myserver is failed.

      Error string was found in the above file.

      Please check the adoplog files created in myserver for more details.

       

      Status of remote command on Node myserver2 is failed.

      Error string was found in the above file.

      Please check the adoplog files created in myserver2 for more details.

       

      Status of remote command on Node myserver2 is failed.

      Unexpected string was found in the above file.

      Please check the adoplog files created in myserver2 for more details.

       

       

       

       

      Following are the error messages in XML file(/myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_001540/myinstance_myserver/remote_execution_result_20150814_002026.xml):

      vi remote_execution_result_20150814_002026.xml

       

      Oracle E-Business Suite Online Patching

      PATCH edition environment variables have been set.

       

      LOGPATH is set to /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log

       

      ***

      Continue as if it were successful :

      ***

       

      AutoPatch could not find a response to the above prompt

      in the defaults file.

       

      The patch has FAILED,

      Please check the adpatch logs for more details.

       

      You should check the file

      /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log/u_NONADFriAug140021492015.log

       

      for errors.

       

      Oracle E-Business Suite Online Patching

      RUN edition environment variables have been set.

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

      PROGRAM : (/thdr2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

      TIME    : Fri Aug 14 00:25:16 2015

      FUNCTION: main::execADPATCH [ Level 1 ]

      ERRORMSG: Application of patch did not go through successfully.

       

                    [UNEXPECTED]Error occurred while executing "perl /thdr2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/thdr2i/inst/fs1/inst/apps/THDR2I_vmohshdrc023/appl/admin/THDR2I_vmohshdrc023.xml -patchcontextfile=/thdr2i/inst/fs2/inst/apps/THDR2I_vmohshdrc023/appl/admin/THDR2I_vmohshdrc023.xml -promptmsg=hide -console=off -patchtop=/thdr2i/applmgr/fs_ne/EBSapps/patch -mode=update -sessionid=75 -timestamp=20150814_002028 -workercount=16 -outdir=/thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023 -autoskip=No"

                    [UNEXPECTED]Error while runSyncFS sub-routine is called

                    [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.

                    Log file: /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/adop_vmohshdrc023_20150814_002028.log

       

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

       

       

       

      There is warning message in another remote execution xml file:

       

      Validating entries in /etc/hosts

      WARNING: /etc/hosts file does not contain correct entry for localhost.

      Add the following entry to the /etc/hosts file:

      127.0.0.1 localhost.localdomain localhost

       

      Completed execution : ADOPValidations.java

       

       

       

      Current entry in /etc/hosts:

      bash-4.1$ cat /etc/hosts

      127.0.0.1       localhost

      129.155.128.225 myinstance.myserver.com      myinstance

       

       

      Have updated unix team to correct above error entries. This is a 2 node Apps tier. but I have concern on the autopatch error in xml file.

       

       

      Regards,

      Purnima Johari

        • 1. Re: adop prepare phase failed
          Chiranjeevi M A

          Adop Phase=prepare Failed While Synchronizing Snapshots (Doc ID 2022760.1)

          • 2. Re: adop prepare phase failed
            2893577

            Hi Chiranjeevi,

             

            As per MOS note Adop Phase=prepare Failed While Synchronizing Snapshots (Doc ID 2022760.1), The remote_execution_result_20150619_122924.xml file shows following error.

            Synchronizing Snapshots...
              [ERROR] Failed to execute SQL statement :
              begin
              ad_zd_adop.sync_snapshots(342);
            exception
              when others then
              update ad_adop_sessions set status='F'
              where adop_session_id=8;
              commit;
              raise_application_error(-20001,'Error while calling ad_zd_adop.sync_snapshots.' || sqlerrm);
            end;

             

             

             

            But in my case it is showing autopatch error during synchronizing patches:

             

            Following are the error messages in XML file(/myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_001540/myinstance_myserver/remote_execution_result_20150814_002026.xml):

            vi remote_execution_result_20150814_002026.xml

             

            Oracle E-Business Suite Online Patching

            PATCH edition environment variables have been set.

             

            LOGPATH is set to /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log

             

            ***

            Continue as if it were successful :

            ***

             

            AutoPatch could not find a response to the above prompt

            in the defaults file.

             

            The patch has FAILED,

            Please check the adpatch logs for more details.

             

            You should check the file

            /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log/u_NONADFriAug140021492015.log

             

            for errors.

             

            Oracle E-Business Suite Online Patching

            RUN edition environment variables have been set.

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

            PROGRAM : (/thdr2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

            TIME    : Fri Aug 14 00:25:16 2015

            FUNCTION: main::execADPATCH [ Level 1 ]

            ERRORMSG: Application of patch did not go through successfully.

             

                          [UNEXPECTED]Error occurred while executing "perl /thdr2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/thdr2i/inst/fs1/inst/apps/THDR2I_vmohshdrc023/appl/admin/THDR2I_vmohshdrc023.xml -patchcontextfile=/thdr2i/inst/fs2/inst/apps/THDR2I_vmohshdrc023/appl/admin/THDR2I_vmohshdrc023.xml -promptmsg=hide -console=off -patchtop=/thdr2i/applmgr/fs_ne/EBSapps/patch -mode=update -sessionid=75 -timestamp=20150814_002028 -workercount=16 -outdir=/thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023 -autoskip=No"

                          [UNEXPECTED]Error while runSyncFS sub-routine is called

                          [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.

                          Log file: /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/adop_vmohshdrc023_20150814_002028.log

             

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

            • 3. Re: adop prepare phase failed
              2893577

              Hi Chiranjeevi,

               

              Issue is resolved now.adop prepare phase was synchnorization filesysten ad as a part of it was applying patches to patch filesystem. Failed patch logfile

              /myinstance/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/myinstance_myserver/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log/u_NONADFriAug140021492015.log

               

              was showing below error messages:

               

              ********************************************************************************************************************************************************************************************************************
              The following Oracle Forms objects did not generate successfully:

              au resource POXPOPOL.pll
              au resource POXOPROC.pll


              An error occurred while generating Oracle Forms library files.

              ***
              Continue as if it were successful :
              ***

              AutoPatch could not find a response to the above prompt
              in the defaults file.

              The patch has FAILED,
              Please check the adpatch logs for more details.

              You should check the file
              /thdr2i/applmgr/fs_ne/EBSapps/log/adop/75/prepare_20150814_002028/THDR2I_vmohshdrc023/TXK_SYNC_update_Fri_Aug_14_00_20_55_2015/log/u_NONADFriAug140021492015.log

              for errors.

               

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

               

              we recompiled pll on which the patch failed manually in run fs to make sure that .pll are getting compiled:

               

              au resource POXPOPOL.pll

              au resource POXOPROC.pll

               

              After this we copied .pll to patch fs and re ran adop prepare. It completed successfully.

               

               

               

              Regards,

              Purnima Johari

              • 4. Re: adop prepare phase failed
                Chiranjeevi M A

                Hello Purnima,

                 

                Good to hear that the issue got resolved.

                please mark this thread as Helpful/Answered and close the thread.

                 

                -Chiranjeevi