NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Running FS_CLONE give error at ADOPValidationUtils.pm

No comments
 When we are running fs_Clone below error is seen.

ERROR:

[UNEXPECTED]Error occurred running "perl /u01/app/applmgr/SAI/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/app/applmgr/SAI/fs1/inst/apps/SAI_funoracleapps/appl/admin/SAI_funoracleapps.xml -patchctxfile=/u01/app/applmgr/SAI/fs2/inst/apps/SAI_funoracleapps/appl/admin/SAI_funoracleapps.xml -phase=fs_clone -logloc=/u01/app/applmgr/SAI/fs_ne/EBSapps/log/adop/51/20190502_132432/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/applmgr/SAI/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
No such file or directory at /u01/app/applmgr/SAI/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.






Solution:

1) Run below query to verify the patch context file entry is present or not.

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 fix this issue we need to upload the patch context file


a) Source your PATCH file system
. EBSapps patch

[applmgr@funoracleapps ~]$ echo $FILE_EDITION
patch

Get the value of your patch context file.


[applmgr@funoracleapps ~]$ echo $CONTEXT_FILE
/u01/oracle/SAI/fs2/inst/apps/SAI_funoracleapps/appl/admin/SAI_funoracleapps.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


[applmgr@funoracleapps ~]$ echo $FILE_EDITION
run

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


Note: the context file parameter should point to the physical location of the patch context file in your system.

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

PATH
-----
/u01/oracle/SAI/fs2/inst/apps/SAI_funoracleapps/appl/admin/SAI_funoracleapps.xml


4) Run the fs_clone again and it should complete successfully.

No comments :

Post a Comment