We are having an issue where our NES is not able to connect to NAC. We already executed the actions described in knowledge base articles:
but still encountering an issue. The error found in active_mq_nac.log are below
2022-04-20 09:17:01,805 [triggerStartAsyncNetworkBridgeCreation: remoteBroker=tcp:///NES-IP:[email protected], localBroker= vm://brokerNacServer#16934] INFO (org.apache.activemq.network.DemandForwardingBridgeSupport:860) - Network connection between vm://brokerNacServer#16934 and tcp:///NES-IP:[email protected] shutdown due to a local error: javax.jms.InvalidClientIDException: Broker: brokerNacServer - Client: Broker : NES-IP:61616_brokerNesServer_inbound_localhost already connected from vm://brokerNacServer#4 2022-04-20 09:17:01,809 [ActiveMQ BrokerService[brokerNacServer] Task-1673] INFO (org.apache.activemq.network.DemandForwardingBridgeSupport:317) - localhost bridge to brokerNesServer stopped 2022-04-20 09:17:31,806 [ActiveMQ Task-1] INFO (org.apache.activemq.network.DiscoveryNetworkConnector:120) - Establishing network connection from vm://brokerNacServer?network=true to tcp://NES-IP:61616 2022-04-20 09:17:31,811 [ActiveMQ VMTransport: vm://brokerNacServer#16939-1] WARN (org.apache.activemq.broker.TransportConnection:770) - Failed to add Connection brokerNacServer->brokerNesServer-42272-1650361482382-3959:1 javax.jms.InvalidClientIDException: Broker: brokerNacServer - Client: Broker : NES-IP:61616_brokerNesServer_inbound_localhost already connected from vm://brokerNacServer#4 at org.apache.activemq.broker.region.RegionBroker.addConnection(RegionBroker.java:246)
The RA DB, table exec_servers maintains a unique entry for each Execution Server (ES) which get added when an ES is added via ASAP/ROC UI. However, during troubleshooting it was identified that there were duplicate entry for a specific execution server having trouble connecting, leading to the issue.
Query to validate execution servers entries in exec_servers table(SQL/ORACLE)
select * from exec_servers where name like '%EXEC_SERVER%';
Release : 6.X
Component : CA RELEASE AUTOMATION EXECUTION SERVER