Instantiating the OHS Config ERROR

[neldyan14]

Hi Erman,

Are you familiar with this kind of error?

Error encountered during the cloning of patch edition.


Log file located at /u01/TEST/apps/fs1/inst/apps/TEST_test/admin/log/clone/ApplyAppsTier_08151802.log
  -    100% completed
ERROR while running Apply...
Tue Aug 15 18:20:44 2017

Enabling EBS_LOGON Trigger...

 ERROR: Failed to execute /u01/TEST/apps/fs1/EBSapps/comn/clone/bin/adclone.pl

 Please check logfile.



Thanks,
Neljanlogfiles.zip

[neldyan14]

It think it's weird because there is no error in the ohs log


FINE : Aug 15, 2017 6:20:41 PM - [ComponentApplyCloner:doClone] Leaving doClone method where visible sourceid=EBS_web_TEST_OHS1@EBS_web_TEST ...
FINE : Aug 15, 2017 6:20:41 PM - CLONE-22264   Time taken to restore sourceid "EBS_web_TEST_OHS1@EBS_web_TEST" is "9,993" milliseconds.
INFO : Aug 15, 2017 6:20:41 PM - CLONE-21036   Restoring the component finished successfully.
INFO : Aug 15, 2017 6:20:41 PM - CLONE-21216   Performing post operation, if any ...
INFO : Aug 15, 2017 6:20:41 PM - CLONE-21217   Post operation completed.
FINE : Aug 15, 2017 6:20:41 PM - [ApplyCloneRequest:performSecondPostoperation] Performing second round post operation if any.
FINE : Aug 15, 2017 6:20:41 PM - [ApplyCloneRequest:performSecondPostoperation] Performing second round post operation completed.
INFO : Aug 15, 2017 6:20:41 PM - CLONE-21037   Time taken to restore all cloners from archive was "10" seconds.
INFO : Aug 15, 2017 6:20:41 PM - CLONE-21006   Total time taken by T2P process was 10 seconds.

INFO : Aug 15, 2017 6:20:41 PM - CLONE-21007   Cloning operation completed successfully.

Thanks,
Neljan

[ErmanArslansOracleBlog]

The error is in OHSapply.

START: Instantiating the OHS Config.
Running /u01/TEST/apps/fs1/FMW_Home/webtier/perl/bin/perl  -I/u01/TEST/apps/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I/u01/TEST/apps/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I/u01/TEST/apps/fs1/EBSapps/appl/au/12.0.0/perl -I/u01/TEST/apps/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/TEST/apps/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetOHSConfig.pl cfgCloneInstance -ctxfile=/u01/TEST/apps/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -archvloc=/u01/TEST/apps/fs1/EBSapps/comn/clone/FMW/OHS/ohsarchive.jar -mvpln=/u01/TEST/apps/fs1/EBSapps/comn/clone/FMW/OHS/moveplan.xml -t2plogloc=/u01/TEST/apps/fs1/inst/apps/TEST_test/admin/log/clone/ohsT2PApply -logdir=/u01/TEST/apps/fs1/inst/apps/TEST_test/admin/log/clone -console=off -promptmsg=hide
Script Executed in 19123 milliseconds, returning status 255
ERROR: Script failed, exit code 255


The underlying error is ->

#####################################
                Generating apps.conf for cloneohsconfig
                ######################################
apps.conf generation faild. EBS won't work as expected
txkSetOHSConfig.pl is exiting with ERROR

[neldyan14]

Hi Erman,

May I know the cause of this and how to fix this?

Thanks,
Neljan

[ErmanArslansOracleBlog]

Looking in the script txkSetOHSConfig.pl, it seems the apps.conf is generated by txkSetAppsConf.pl.
This script should produce some logs under TXK directory under $APPLRGF.

I mean under $APPLRGF/TXK directory.

Those logs should be checked.

Example log file directory:

/u01/install/APPS/fs2/inst/apps/ORAPROD_erman/logs/appl/rgf/

Example filename:

 txkSetAppsConf_03122125.log

[neldyan14]

*** LOG FILE: /u01/TEST/apps/fs2/inst/apps/TEST_test/logs/appl/rgf/TXK/txkSetAppsConf_08151141.log ***

Temporary out file: /u01/TEST/apps/fs2/inst/apps/TEST_test/logs/appl/rgf/TXK/appsconf.out ***
Config Option : cloneohsconfig
apps.conf generated successfully

txkSetAppsConf_08151141.log
txkSetAppsConf_08151128.log
applCSFLogManager_227082017_112957.log

[ErmanArslansOracleBlog]

You have the following error in  txkSetAppsConf_08151128.log
Error in getting Context Value for s_ohs_instance_loc
Config Option : standaloneohsconfig

However; there are no errors in  txkSetAppsConf_08151141.log, it is clean.

So, which one is correct? How many times did you try this?

11:28  or 11:41 , which time?

Because in 11:41, your apps.conf related things seem to be done successfully.

[neldyan14]

Good Day Erman!

I am actually confused on these two logs. When I am trying to startup my RUN BASE there are no problems.

How to fix the Error in getting Context Value for s_ohs_instance_loc Config Option : standaloneohsconfig in txkSetAppsConf_08151128?

Thanks.

[ErmanArslansOracleBlog]

It says, I can't get the value of ohs_instance_loc .
Is it written in related fs's context file?

[neldyan14]

FS2

[appltest@test ~]$ vi $CONTEXT_FILE
         <forms-c4ws_nodes oa_var="s_forms-c4ws_nodes">test.maxsgroupinc.com:7851,test.maxsgroupinc.com:7853</forms-c4ws_nodes>
         <oaea_nodes oa_var="s_oaea_nodes">test.maxsgroupinc.com:6851</oaea_nodes>
         <ohs_instance_loc oa_var="s_ohs_instance_loc">/u01/TEST/apps/fs2/FMW_Home/webtier/instances/EBS_web_TEST_OHS1</ohs_instance_loc>
         <ohs_instance oa_var="s_ohs_instance">EBS_web_TEST_OHS1</ohs_instance>
         <ohs_component oa_var="s_ohs_component">EBS_web_TEST</ohs_component>

===================================================================

FS1
      <forms-c4ws_nodes oa_var="s_forms-c4ws_nodes">test.maxsgroupinc.com:7852,test.maxsgroupinc.com:7854</forms-c4ws_nodes>
         <oaea_nodes oa_var="s_oaea_nodes">test.maxsgroupinc.com:6852</oaea_nodes>
         <ohs_instance_loc oa_var="s_ohs_instance_loc">/u01/TEST/apps/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1</ohs_instance_loc>
         <ohs_instance oa_var="s_ohs_instance">EBS_web_TEST_OHS1</ohs_instance>
         <ohs_component oa_var="s_ohs_component">EBS_web_TEST</ohs_component>

[ErmanArslansOracleBlog]

Are these directories present?

/u01/TEST/apps/fs2/FMW_Home/webtier/instances/EBS_web_TEST_OHS1
/u01/TEST/apps/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1

[neldyan14]

[root@test EBS_web_TEST_OHS1]# cd -
/u01/TEST/apps/fs2/FMW_Home/webtier/instances/EBS_web_TEST_OHS1
[root@test EBS_web_TEST_OHS1]# cd /u01/TEST/apps/fs1/FMW_Home/webtier/instances/                                                                                        EBS_web_TEST_OHS1
[root@test EBS_web_TEST_OHS1]# pwd
/u01/TEST/apps/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1
[root@test EBS_web_TEST_OHS1]#

[ErmanArslansOracleBlog]

It s_ohs_instance_loc is present in the context files and it seems the relevant directories are already there.

Can you retry the operation and send me the relevant logs accordingly? ( to be sure about the issue)

Also can you check the s_ohs_instance_loc  value in the relevant context file that is present in FND_OAM_CONTEXT_FILES table?

[neldyan14]

SQL> select NAME, PATH from FND_OAM_CONTEXT_FILES where name like '%TEST%';

NAME
--------------------------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
TEST_test
/u01/TEST/apps/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml

TEST_test
/u01/TEST/db/11.2.0/appsutil/TEST_test.xml

TEST_test
/u01/TEST/apps/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml


SQL>

[neldyan14]

i can't do it again right. I am applying a patch for the testing of our functional team.

[ErmanArslansOracleBlog]

1)As for FND_OAM_CONTEXT_FILES, I'm not asking the path names..Check the contents of them. You can view it using TOAD.

2) You can retry aha.. ok .. Are you sure that we are reviewing the relevant logs then?

[neldyan14]

I am sorry. I am saying that for now I can't retry sa post clone of my patch edition since I am now applying a patch for a different error (FUNCTIONAL).

I will upload the context file here. But as I reviewed them a while ago, the values are correct.
Patch_Edition_TEST_test.xml
RUN_Edition_TEST_test.xml

[ErmanArslansOracleBlog]

it is written correctly in these context files too..
However, it can not be read by the perl.

looking at the relevant script,

it fails in $gConfig{$ohs_instance_loc}   = getCtxValue($s_ohs_instance_loc, 'd', 1);

So it fails in getCtxValue.

So it fails internally in gUtil->getCtxValue

gutil comes from the following java ->

ADX::util::Java($gConfig{$ctxFile});



But just above these line , it reads the applgrf value and it doesn't report any errors for that.

($gConfig{$s_applrgf} = getCtxValue($s_applrgf, 'd', 1);)

gutil.getCtxValue comes from the ADOPValidationUtils.pm


So it is weird.
However, I don't think the cause is this kind of internal. I don't think we need to jump into the perl modules or perl code..

I think , this error may be encountered only for one time.
That's why, I wanted you to ensure that we are reviewing the relevant logs..

Please, take a time and retry your operation. Note the time of your execution and send me the relevant logs for the analysis.

[rizwan]

I have encountered same error while executing dualfs cloning of appstier
do not find any exact error message anywhere in the logfiles.

here it failed

START: Instantiating the OHS Config.
Running /u01/R12/appluat/fs2/FMW_Home/webtier/perl/bin/perl  -I/u01/R12/appluat/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I/u01/R12/appluat/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I/u01/R12/appluat/fs2/EBSapps/appl/au/12.0.0/perl -I/u01/R12/appluat/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/R12/appluat/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetOHSConfig.pl cfgCloneInstance -ctxfile=/u01/R12/appluat/fs2/inst/apps/UATDB_erp/appl/admin/UATDB_erp.xml -archvloc=/u01/R12/appluat/fs1/EBSapps/comn/clone/FMW/OHS/ohsarchive.jar -mvpln=/u01/R12/appluat/fs1/EBSapps/comn/clone/FMW/OHS/moveplan.xml -t2plogloc=/u01/R12/appluat/fs1/inst/apps/UATdb_erp/admin/log/clone/patch/ohsT2PApply -logdir=/u01/R12/appluat/fs1/inst/apps/UATdb_erp/admin/log/clone/patch -console=off -promptmsg=hide
Script Executed in 36208 milliseconds, returning status 1
ERROR: Script failed, exit code 1

apart from above on fs1 operation completed successfully but autoconfig post step of adpreclone failed with error

RROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (txkGenADOPWrapper.pl)
TIME    : Tue Oct  8 16:26:49 2019
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 8 16:26:49 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('erp') FROM DUAL
       *
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.AD_ZD_ADOP", line 3049


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



STACK TRACE
 at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
        TXK::Error::abort('TXK::Error', 'HASH(0x28bbd40)') called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
        TXK::Common::doError('TXK::SQLPLUS=HASH(0x301f358)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
        TXK::Common::setError('TXK::SQLPLUS=HASH(0x301f358)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
        TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x301f358)', 0) called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
        TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x301f358)', 'HASH(0x30b2ab8)') called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
        TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x2fd6020)', 'SELECT ad_zd_adop.get_node_type(\'erp\') FROM DUAL') called at /u01/R12/appluat/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
        TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x2fd6020)', 'SELECT ad_zd_adop.get_node_type(\'erp\') FROM DUAL') called at txkGenADOPWrapper.pl line 506
        main::getNodeType() called at txkGenADOPWrapper.pl line 202
        eval {...} called at txkGenADOPWrapper.pl line 143
)
ERRORCODE = 1 ERRORCODE_END

[ErmanArslansOracleBlog]

Hi Rizwan,

Did you check this note ? -> E-Business Suite 12.2 Autoconfig Errors with 'txkGenADOPWrapper.pl ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.AD_ZD_ADOP" (Doc ID 2155106.1)