The following error appears when attempting to start xFlow, and a fault arises with the loss of collaboration microservice, file collabMS.log, location xFlow install dir APPS\logs
ERROR [com.ca.casm.actor.ClusterManager] - Unable to setup xflow cluster
java.util.concurrent.ExecutionException: com.ca.casm.exception.CasmBaseException: Error : NO, AHD04116:A duplicate record was encountered. Insert or Update failed., 7776|domsrvr|XyRVAA
at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)
at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999)
Release: 17.3 or higher
CA Service Desk Manager
Wrong config keys in the l1admin_general_config table. The following config keys appears in the table:
Collaboration_MicroService_akka.cluster.seed-nodes.1
Incident_MicroService_akka.cluster.seed-nodes.1
Search_MicroService_akka.cluster.seed-nodes.1
The keys with nodes.0 don't exists in the table. The entries should read as
Collaboration_MicroService_akka.cluster.seed-nodes.0
Incident_MicroService_akka.cluster.seed-nodes.0
Search_MicroService_akka.cluster.seed-nodes.0
There should not be any other entries for the given config_key.
Example: "Collaboration_MicroService_akka.cluster.seed-nodes.1" should not be present, but "Collaboration_MicroService_akka.cluster.seed-nodes.0" should be present.
1. Stop xFlow Services
2. Run the following to change the keys from nodes.1 to nodes.0
update l1admin_general_config set config_key = 'Collaboration_MicroService_akka.cluster.seed-nodes.0' where config_key = 'Collaboration_MicroService_akka.cluster.seed-nodes.1'
update l1admin_general_config set config_key = 'Incident_MicroService_akka.cluster.seed-nodes.0' where config_key = 'Incident_MicroService_akka.cluster.seed-nodes.1'
update l1admin_general_config set config_key = 'Search_MicroService_akka.cluster.seed-nodes.0' where config_key = 'Search_MicroService_akka.cluster.seed-nodes.1'
3. Start xFlow services
Perform a backup/snapshot of the environment and database before attempting this change.