ADOP prepare fails with "[ERROR] ETCC not run in the database"

 

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.