Tuesday, October 25, 2016

R12 ADOP patch session failing for form / report compilation

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

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

While looking at the log file i could see lot of forms that were not compiled, to avoid this situation use restart=yes flags=autoskip in adop
==========================================================
Patch session with error:

appltest@tstsrv:/u25/TEST/fs_ne/EBSapps/patch$ adop phase=apply patches=24944395_AR:u24944395.drv restart=yes prompt=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u25/TEST/fs2/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
    Patch edition context: /u25/TEST/fs1/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
Reading driver file (up to 50000000 bytes).
    Patch file system free space: 120.47 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node tstsrv:
                  19791273
                  20588502
                  20825533
                  20936905
                  21091431
                  21153266
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
    Continuing with existing session [Session ID: 28].
        Session Id            :   28
        Prepare phase status  :   COMPLETED
        Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED
        Cutover  phase status :   NOT COMPLETED
        Abort phase status    :   NOT COMPLETED
        Session status        :   FAILED

===========================================================================
ADOP (C.Delta.7)
Session ID: 28
Node: tstsrv
Phase: apply
Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/adop_20161025_081029.log
===========================================================================

Applying patch 24944395_AR:u24944395.drv.
    Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100413/TEST_tstsrv/24944395_AR/log/u24944395.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
/u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100413/TEST_tstsrv/24944395_AR/log/u24944395.log

for errors.

    [UNEXPECTED]Error occurred executing "adpatch  abandon=no restart=yes workers=24      console=no interactive=no  defaultsfile=/u25/TEST/fs1/EBSapps/appl/admin/TEST_patch/adalldefaults.txt patchtop=/u25/TEST/fs_ne/EBSapps/patch/24944395_AR driver=u24944395.drv logfile=u24944395.log"
    [UNEXPECTED]Refer to the log files for more information.
    [UNEXPECTED]Apply phase has failed.


[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)

===================================================================
Patch session post autoskip without erorrs :

applTEST@tstsrv:/u25/TEST/fs_ne/EBSapps/patch$ adop phase=apply patches=24944395_AR:u24944395.drv restart=yes flags=autoskip

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u25/TEST/fs2/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
    Patch edition context: /u25/TEST/fs1/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
Reading driver file (up to 50000000 bytes).
    Patch file system free space: 120.47 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node tstsrv:
                  19791273
                  20588502
                  20825533
                  20936905
                  21091431
                  21153266
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
    Continuing with existing session [Session ID: 28].
        Session Id            :   28
        Prepare phase status  :   COMPLETED
        Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED
        Cutover  phase status :   NOT COMPLETED
        Abort phase status    :   NOT COMPLETED
        Session status        :   FAILED

===========================================================================
ADOP (C.Delta.7)
Session ID: 28
Node: tstsrv
Phase: apply
Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/adop_20161025_081029.log
===========================================================================

Applying patch 24944395_AR:u24944395.drv.
    Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log/u24944395.log
    [WARNING]   Some patching actions failed and were skipped
    [WARNING]   Refer to the autoskip logfile for the list of skipped jobs
    [WARNING]   Logfile: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log/autoskip.log

Generating post apply reports.

Generating log report.
    Output: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/adzdshowlog.out

The apply phase completed successfully.


adop exiting with status = 0 (Success)

In addition to the above autoskip option creates a new logfile called asautoskip.log unfortunately it didnt catch any info on the missed file I had to go back to the log and lgi file to trace out the missing files.


applTEST@tstsrv:/u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log$ cat autoskip.log

************* Start of AutoPatch session *************

AutoPatch started at: Tue Oct 25 2016 10:10:01


Autoskipped at Tue Oct 25 2016 10:11:24
[Session : 186984, Error while generating Oracle Forms files]



Autoskipped at Tue Oct 25 2016 10:15:16
[Session : 186984, Error while generating Oracle Reports files]


No comments: