ISSUE:
12.2.9 adop prepare failed with
the error below despite updated ETCC having been successfully ran:
....................................................................................................................
Validating system setup.
Node registry is valid.
[ERROR] ETCC not run in the
database node data16
The EBS Technology Codelevel
Checker needs to be run on the database node.
It is available as Patch
17537119.
Encountered the above errors
when performing database validations.
Resolve the above errors and restart adop.
....................................................................................................................
CAUSE:
Possible mismatch between
FND_NODES and APPLSYS.TXK_TCC_RESULTS.
Failure occurred in my freshly
cloned environment. In my case, the "domain" had been appended to the
node_name.
SQL> SELECT
NODE_NAME,DATABASE_NAME FROM APPLSYS.TXK_TCC_RESULTS;
NODE_NAME DATABASE_NAME
-------------------- ----------------------------------------------------------------
data16.xyzdomain.com dbproject
app010 dbproject
app010 dbproject
SQL> SELECT
NODE_NAME,NODE_ID,HOST FROM FND_NODES;
NODE_NAME NODE_ID HOST
-------------------- ----------
--------------------
DATA16 12125 data16
APP010 12126 app010
AUTHENTICATION 12127
FIX:
#1: Backup the
APPLSYS.TXK_TCC_RESULTS
create table
APPS.TXK_TCC_RESULTS_backup as select * from APPLSYS.TXK_TCC_RESULTS;
#2: Update the
APPLSYS.TXK_TCC_RESULTS to correct the NODE_NAME value:
update APPLSYS.TXK_TCC_RESULTS
set node_name='DATA16' where node_name ='data16.xyzdomain.com';
commit;
#3: Verify:
SQL> SELECT
NODE_NAME,DATABASE_NAME FROM APPLSYS.TXK_TCC_RESULTS;
NODE_NAME DATABASE_NAME
-------------------- ----------------------------------------------------------------
DATA16 dbproject
app010 dbproject
app010 dbproject
app010 dbproject
app010 dbproject
Proceeded with adop prepare.
