Sunday 15 October 2017

Node id does not exist for the current application server id

Issue:

After completing cloning procedure, you generally may across the following issue. "Node id does not exist for the current application server id" or

May be we created a disaster database for testing purpose due to this also you will get node id error.

There is a mismatch between server_id in the  fnd_nodes table and appl_server_id in the dbc file and hence are getting this  "node id does not exist" error.

When trying to open Oracle Forms, all forms error out with the below message:

“Node id does not exist for the current application server id”.

Solution:

Do a select on the server_id in the fnd_nodes table.  Here is an example of what it could look like:

server_id=EA99227ED75CFE4EE030149077C4515496138833635529486962342698410274

Do a search on APPL_SERVER_ID in the .dbc file.  It could show something like:

APPL_SERVER_ID=EA99220924EF823FE030149077C450C096138833635529486962342698410274

compare both the id if any mismatch or if both same also you can run the below script it will solve the issue.

Run adgendbc.sh to config the apps tier dbc file with the correct id from the database instance.

cd $INST_TOP/admin/install/
sh adgendbc.sh

Completes with:

Updating Server Security Authentication
AUTHENTICATION SECURE executed
successfully –
/u01/PROD/inst/apps/xxx/appl/fnd/12.0.0/secure/PROD.dbc
adgendbc.sh
exiting with status 0
ERRORCODE = 0 ERRORCODE_END

solution steps:

1.First stop the application.
2.Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance.
3.Start the application and test your issue.

Best Regards.

1 comment:

  1. Unique constraint error (00001) is OK if key already exists

    Creating the DBC file...
    Application server ID already exists for this host - loading..
    ADD executed successfully - /u01/app/oracle/R122/fs1/inst/apps/PROD_prodr122/appl/fnd/12.0.0/secure/PROD.dbc

    Updating Server Security Authentication
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.FND~NODES~U1) violated
    ORA-06512: at "APPS.FND_CONCURRENT", line 1688
    ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 386
    ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 664
    ORA-01403: no data found
    ORA-06512: at line 1
    - Database error performing AUTHENTICATION

    Updating Server Security Authentication failed with exit code 1
    Restoring DBC file from backed up location /u01/app/oracle/R122/fs1/inst/apps/PROD_prodr122/appltmp/TXK/PROD_Fri_Jul_16_12_38_2021.dbc

    adgendbc.sh ended at Fri Jul 16 12:38:33 BST 2021

    adgendbc.sh exiting with status 1
    ERRORCODE = 1 ERRORCODE_END

    ReplyDelete