DE Secondary (standby) server failed to start after configuring the DE High Availability to work with LDAP server but the primary server is up and running.
CA Workload Automation DE (dSries)
In the process of configuring DE High Availability (HA) to work with LDAP server, user copied the server.properties file from one server to another which corrupted the server configuration in the DE Server database.
Error in DE Server tracelog;
Starting up the High Availability Component
**ERROR** More than two Servers are configured with this High Availability environment. Remove the unused server ID(s) from the table ESP_CONFIG_GROUP and restart the server.
com.ca.wa.core.engine.config.ConfigException: **ERROR** More than two Servers are configured with this High Availability environment. Remove the unused server ID(s) from the table ESP_CONFIG_GROUP and restart the server.
Follow the recommendation in the Solution Document RI83557 to remove unused GUID from server configuration in the database.
1. Run the following query to get all the GUIDs available from the table
SELECT * FROM ESP_CONFIG_GROUP where TYPE='CONFIG_INSTANCE';
2. Keep the result of the above query as a backup before modification.
3. Use the utility named "RemoveUnusedGUIDs" available in the “<DE_installdir>/bin” directory.
You can run the utility as "RemoveUnusedGUIDs.bat --help" to get the details about the usage :
"Usage : RemoveUnusedGUIDs.bat GUID_preferred_server_to_keep GUID_secondary_server_to_keep"
For example; RemoveUnusedGUIDs.bat <GUID_preferred_server_to_keep> <GUID_secondary_server_to_keep>
./RemoveUnusedGUIDs.sh <GUID_preferred_server_to_keep> <GUID_secondary_server_to_keep>
4. Run the "RemoveUnusedGUIDs" utility with both of the GUIDs in UPPERCASE as parameter.