This issue can be solved by applying the below patches, apply them both in base language and arabic.
24839804
20135590
Hope this helps.
Thank you.
Monday, October 31, 2016
FRM-40733 PL/SQL SET_GROUP_CHAR_CELL , FRM-41084
This week was installing Arabic NLS on 12.2.4 and after the regular steps i faced a strange issue while opening arabic forms they error out in FRM-40733 and FRM-41084 and this happens across the board.
This issue can be solved by applying the below patches, apply them both in base language and arabic.
24839804
20135590
Hope this helps.
Thank you.
This issue can be solved by applying the below patches, apply them both in base language and arabic.
24839804
20135590
Hope this helps.
Thank you.
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]
***
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]
Subscribe to:
Posts (Atom)