FS_CLONE give error at ADOPValidationUtils

 

When executing fs_Clone, the following error is encountered.

ERROR

[UNEXPECTED]Error occurred running “perl /u01/app/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/app/PROD/fs1/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -patchctxfile=/u01/app/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -phase=fs_clone -logloc=/u01/app/PROD/fs_ne/EBSapps/log/adop/48/20231102_181022/fs_clone/validate/funoracleapps -promptmsg=hide”
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on funoracleapps

Checking log further below error is noticed.

Use of uninitialized value $result in split at /u01/app/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
No such file or directory at /u01/app/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.

SOLUTION

 

1) Execute the following query to check if the patch context file entry exists.

 

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';

no rows selected

2) To resolve this problem, it’s necessary to upload the patch context file.

 

a) Source your PATCH file system

[apps@testebs ~]$ . EBSapps patch

[apps@testebs ~]$ echo $FILE_EDITION

patch

Get the value of your patch context file.

 

[apps@testebs ~]$ echo $CONTEXT_FILE

/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml

b) Source the RUN filesystem and 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 as per step 1'
logfile=/tmp/patchctxupload.log

[apps@testebs ~]$ echo $FILE_EDITION

run

[apps@testebs ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
> action=upload
> contextfile=/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml
> logfile=/tmp/patchctxupload.log
Enter the APPS password:

NOTE: The context file parameter must be directed to the actual location of the patch context file on your system.

 

3) Execute the query below, which should yield a single entry corresponding to the newly 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';

PATH
-----
/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml

4) Execute fs_clone once more, and it should now complete successfully.

 

 

 

• Ratings: 5