Adop phaseprepare failing with error UNEXPECTEDError 1 occurred while Executing txkADOPValidation script on ebs1

by

Adop phaseprepare failing with error UNEXPECTEDError 1 occurred while executing txkADOPValidation.pl script on ebs1|

Adop phaseprepare failing with error UNEXPECTEDError fixing in best way.

Below error adop phase=prepare failed at txkADOPValidation.pl occurring while preparing oracle apps for patching using adop.

 
 
Validating configuration on node: [xxxxx].
    Log:
 
/data03/1225_data/1225apps/fs_ne/EBSapps/log/adop/11/20180907_171515/prepare/validate/test
 
        [WARNING]: There could be issues while validating the ports used for E-Business Suite instance
 
against ports used in /etc/services. Refer the log file for more details.
 
        [ERROR]: Some of the ports specified for the patch file system are not available.
 
    [UNEXPECTED]Error occurred running “perl
 
/data03/1225_data/1225apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  –
 
contextfile=/data03/1225_data/1225apps/fs2/inst/apps/PHASE1_test/appl/admin/PHASE1_test.xml –
 
patchctxfile=/data03/1225_data/1225apps/fs1/inst/apps/PHASE1_test/appl/admin/PHASE1_test.xml –
 
phase=prepare –
 
logloc=/data03/1225_data/1225apps/fs_ne/EBSapps/log/adop/11/20180907_171515/prepare/validate/te
 
st -promptmsg=hide”
 
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on test
 
 
[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.
 
 
[applmgr@dcetest dcetest]$ cat txkADOPValidations.error
 
Use of uninitialized value $result in split at
 
/data03/1225_data/1225apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
 
No such file or directory at
 
/data03/1225_data/1225apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.
 
 

 

Check it as below to verify the patch context file entry.

 
 
SQL>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’;
 
SQL>No rows returned.

 

 
 
It means patch filesystem context entry does not exist in database.
 
echo $FILE_EDITION
patch
 
Now we need to upload the patch context file in database.
 

 

Solution:-

 
 
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
action=upload
contextfile=/data03/1225_data/1225apps/fs2/inst/apps/PHASE1_test/appl/admin/PHASE1_test.xml 
logfile=/tmp/patchctxuploads.log



Run the below query again to validate

 
$adop -validate
 
 

Read Further: –

Leave a Comment