UCCX: Fix DB Replication by Dropping Syscdr

This post describes the steps to repair a broken DB Replication between primary and secondary nodes on a Cisco UCCX system. This will work for both virtual and physical UCCX installs.

 

Fix DB replication by dropping Syscdr

1) Perform on Secondary Node(s) and wait for it to complete.
	>> utils dbreplication stop

2) Perform on Primary Node and wait for it to complete.
	>> utils dbreplication stop

3) Perform on Primary Node and wait for it to complete.
	>> utils dbreplication dropadmindb

4) Perform on Secondary Node(s) and wait for it to complete.
	>> utils dbreplication dropadmindb

5) Perform on Primary Node and wait for it to complete. May take 1-2 hours.
	>> utils dbreplication reset all

6) Login to the Primary Node and verify state by running:
	>> utils dbreplication runtimestate

 

Optional steps if the above fails to work

1) Login to Primary Node and issue command:
	>> utils system restart

2) Wait for the server to come up, if you can open Web interface, service is fully functional.

3) Login to Secondary Node(s) and issue command:
	>> utils system restart

4) Wait for Secondary Node server(s) to come up.

5) Login to the Primary Node and verify state by running:
	>> utils dbreplication runtimestate