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.
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