Skip to main content

[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on

Error: During adop prepare phase error occurred on validation


Error log:
 cat txkADOPValidations.error
Use of uninitialized value $result in split at /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
No such file or directory at /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.


Solution:

SQL> 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';
SQL > no rows selected ( here not showing context_file)



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.


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=/u01/applprod/fs1/inst/apps/ETEST_etestapp/appl/admin/ETEST_etestapp.xml \
logfile=/tmp/patchctxupload.log





log shows:

[applprod@etestapp applprod]$ cat /tmp/patchctxupload.log
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=epc-db-88888)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=ETEST)))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.
-------------------ADX Database Utility Finished---------------

---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=epc-db-88888)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=ETEST)))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.
-------------------ADX Database Utility Finished---------------

4. Run the following query and it should return one entry for the recently uploaded context file.



SQL> 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/applprod/fs1/inst/apps/ETEST_etestapp/appl/admin/ETEST_etestapp.xml


5. Re check issue by running adop phase.
adop prepare completed successfully after this  fixing.



Comments

Post a Comment

Popular posts from this blog

EBS R12 “Unable to Authenticate Session”

Oracle E-Business Suite environment with IE8 and higher, When  cloning the EBS envitorment or you are logging out from your DEV Instance and want to login to  PROD-Instance it happens “Unable to authenticate session” Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging (shown below) 1)  Start -> Program Files 2)  Right click on the Internet Explorer icon and select Properties 3)  Add -nomerge to the end of the link in the Target field i.e. “C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging 4)  Click the OK button to close the window 5) Stop all Browser sessions. 6) Start a new Browser session and logon to the Instance
Post a Comment
Read more

19c ORACLE HOME Cloning -Linux/Solaris

  Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone the Oracle home, the new Oracle home has the patch updates which is already applied on oracle home. Steps to clone an Oracle home step 1 : Stop Services Stop all processes related to the Oracle home. Step 2 : Create a ZIP or TAR file with the Oracle home (/u01/app/oracle/product/19.0.0/dbhome_1)    Use ROOT user for ZIP and UNZIP  # zip -r dbhome_1.zip /u01/app/oracle/product/19.0.0/dbhome_1 TAR option: # tar -cvf dbhome_1.tar /u01/app/oracle/product/19.0.0/dbhome_1 Step 3: s cp zip/tar to target s...
Post a Comment
Read more

EBS R12.2.4 AutoConfig could not successfully execute the following scripts followed by error "txkGenADOPWrapper.pl INSTE8_APPLY 1"

issue:txkGenADOPWrapper.pl    INSTE8_APPLY       1 WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:       <filename>  <phase>  <return code where appropriate>   [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /u01/applprod/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/applprod/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/applprod/fs2/inst/apps/PRODDB_epc-apps12-node41v/admin/install       txkGenADOPWrapper.pl    ...
Post a Comment
Read more