12.2 ADOP Prepare Phase Fails with below error message,
Error:
Validating configuration on node: [apps].
Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps
[UNEXPECTED]Error occurred running “perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps -promptmsg=hide”
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on apps
When looking at ADOP logs:
Error in adop logs,
vi /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps/txkADOPValidations.error
Use of uninitialized value $result in split at /u01/install/APPS/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
Solution:
If you run the following query it should return no rows:
select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in (‘TEMPLATE’,’METADATA’,’config.txt’) and CTX_TYPE=’A’ and (status is null or upper(status) in (‘S’,’F’)) and EXTRACTVALUE(XMLType(TEXT),’//file_edition_type’) = ‘patch’;
Before proceeding with below steps, take a backup of your context file,
To fix this issue, follow the below steps to upload the missing PATCH context file to the database:
1. Get the value of your patch context file
1.1. Source your PATCH file system
1.2. Echo the value of $CONTEXT_FILE and take note of it. You will use this value in step #3
2. Source the RUN filesystem
3. Execute the following command on the run filesystem to upload the patch context file to the database
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=<Enter Your Full Patch Context XML File Location> \
logfile=/tmp/patchctxupload.log
For Example:
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml \
logfile=/home/oracle/patchctxupload.log
Note: the context file parameter should point to the physical location of the patch context file in your system
4. Run the following query and it should return one entry for the recently uploaded context file
select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in (‘TEMPLATE’,’METADATA’,’config.txt’) and CTX_TYPE=’A’ and (status is null or upper(status) in (‘S’,’F’)) and EXTRACTVALUE(XMLType(TEXT),’//file_edition_type’) = ‘patch’;
