Error “Use of uninitialized value $result in split” In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

0

Error “Use of uninitialized value $result in split” In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

SYMPTOMS

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’;
Having no rows returned to the query is a SYMPTOM, not a CAUSE of the issue. The symptom is there are no rows returned when running the query.
*Warning*: Do not proceed with this Note instructions if there are any rows returned by this query. If a row is returned by this query, running this command will corrupt ADOP. Instead open an SR with Oracle Support for more assistance.
Fs_clone fails with the following error:
Validating configuration on node: [node303].
Log: /u01/oracle/DEVTEST/fs_ne/EBSapps/log/adop/3/fs_clone_20151217_083945/DEVTEST_node303
[UNEXPECTED]Error occurred running “perl /u01/oracle/DEVTEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/oracle/DEVTEST/fs1/inst/apps/DEVTEST_node303/appl/admin/DEVTEST_node303.xml -patchctxfile=/u01/oracle/DEVTEST/fs2/inst/apps/DEVTEST_node303/appl/admin/DEVTEST_node303.xml -phase=fs_clone -logloc=/u01/oracle/DEVTEST/fs_ne/EBSapps/log/adop/3/fs_clone_20151217_083945/DEVTEST_node303 -promptmsg=hide”
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on node303
adopscanlog utility shows error similar to this:
Lines #(67-71):
[PROCEDURE] Calling: /u01/oracle/DEVTEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
[EVENT] Log: /u01/oracle/DEVTEST/fs_ne/EBSapps/log/adop/3/fs_clone_20151217_083945/DEVTEST_node303
 [UNEXPECTED]Error occurred running “perl /u01/oracle/DEVTEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/oracle/DEVTEST/fs1/inst/apps/DEVTEST_node303/appl/admin/DEVTEST_node303.xml -patchctxfile=/u01/oracle/DEVTEST/fs2/inst/apps/DEVTEST_node303/appl/admin/DEVTEST_node303.xml -phase=fs_clone -logloc=/u01/oracle/DEVTEST/fs_ne/EBSapps/log/adop/3/fs_clone_20151217_083945/DEVTEST_node303 -promptmsg=hide”
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on node303
[PROCEDURE] [START 2015/12/17 08:41:07] Unlocking sessions table
The file txkADOPValidations.error for the failing adop session shows the following:
Use of uninitialized value $result in split at /u01/oracle/DEVTEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/oracle/DEVTEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.

CAUSE

Patch context file is missing in the FND_OAM_CONTEXT_FILES table. Line 1291 of ADOPValidationUtils.pm line (see error below) is expecting the full path of CONTEXT_FILE name from the patch file system. However, the command returns no results.

SOLUTION

To fix this issue test the following 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= \
logfile=/tmp/patchctxupload.log
For Example:
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/data1/oracle/EBSDEV/fs2/inst/apps/EBSDEV_ebsapp01/appl/admin/EBSDEV_ebsapp01.xml \
logfile=/tmp/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’;

https://tobeimpact.blogspot.in/2017/01/error-use-of-uninitialized-value-result.html

Share.

About Author

Leave A Reply

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.