UCCX Database is incorrect

[Robert Dawson]

Hi

UCCX System version: 8.0.2.11005-20 (HA)

CM System version: 8.6.2.20000-2 (HA)

From the 21st of December, Our historical reports database has stopped gathering data correctly, much of the data is incorrect or missing altogether and I cannot see a pattern to the errors. There have been no changes to scripting or to the database to trigger this.

We have attempted restarting the following on both nodes:

• Cisco Unified CCX Engine
  
• Cisco Unified CCX Database
  
• Cisco Desktop Recording and Statistics Service.
  

Does anyone know how this can be resolved?

Many thanks

[Aaron Harrison]

Hi Robert

Try these:

1) Go into CCX Serviceability, and check the status of the Tools/Datastore/Relication Servers menu.

2) In CCX Serviceability, check the Tools/Datastore/Datastores menu, and select the Historical Datastore in the dropdown.

3) From the CLI, run these:

utils uccx dbreplication status

utils dbreplication runtime state

That should give you some clues - if not, post up the screen grabs and cli output.

Regards

Aaron

[Robert Dawson]

Hi

Screengrabs attached.

Many thanks

Rob

[Aaron Harrison]

Hi Rob

Your dbreplication runtimestate shows the sub is not replicating properly.

I would do this:

1) Run utils dbreplication stop on the sub, and on the pub. Wait for both command to return, do not CTRL+C or anything else... it can take 10-15 minutes on a bad day.

2) Then run utils dbreplication reset all on the publisher. again, let it return, do not CTRL+C or otherwise exit

3) Monitor the replication setup with 'utils dbreplication runtimestate'. If needed, set up another putty session to the server to run this rather than killing any other running command!

Regards

Aaron