Error:
[UNEXPECTED]Error occurred running "perl /eigcprod/install/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/eigcprod/install/fs1/inst/apps/PROD_airtecapps/appl/admin/PROD_airtecapps.xml -patchctxfile=/eigcprod/install/fs2/inst/apps/PROD_airtecapps/appl/admin/PROD_airtecapps.xml -phase=fs_clone -logloc=/eigcprod/install/fs_ne/EBSapps/log/adop/16/20200921_161649/fs_clone/validate/airtecapps -promptmsg=hide"
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on airtecapps
[PROCEDURE] [START 2020/09/21 16:17:43] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for airtecapps with wait interval of 60 seconds and number of tries 2
Cause:
Patch filesystem context file doesn't exists in FND_OAM_CONTEXT_FILES Table.
Solution:
To fix this issue 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 note down it ( it will be used in step3 )
2. Source the RUN filesystem
3. Execute the following command on the run filesystem to upload the patch context file ( taken in step 1.2 ) to the database.
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/eigcprod/install/fs2/inst/apps/PROD_airtecapps/appl/admin/PROD_airtecapps.xml \
logfile=/tmp/patchctxupload.log
Note:
ADJVAPRG is a environment variable , so use along with the $ sign - $ADJVAPRG
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';
output should return patch fs context file..
Thats it. Always enjoy in solving issue :)
