UCCX 8.5 - db_cra tables do not update simultaneously

[ischilling]

We use a third party to pull reports from UCCX 8.5.  They mention having wrong data from the tables they pull from UCCX db_cra because some tables do not update normally.  In particular the ContactQueueDetail table and the AgentConnectionDetail will lag behind, sometimes for several hours.

I suspect this is a known issue... Any idea?

[Aaron Harrison · Accepted solution]

Hi

The main problem is that the system only guarantees that the two tables prefixed 'rt' will be updated in near real time.

The others are for historical reporting, so if they get updated late... that's apparently fine, and it's not something TAC will fix.

However, I would suggest:

- If you have HA, check the other server to see if that is being updated quicker (typically the 'primary' server will get the DB updates then replicate to the secondary)

- See if it speeds up after a restart. Way back I had the same issue with a 4.x system, and sometimes it would get so slow we didn't have much choice and just reboooted it, which normally sped things up for a while.

Aaron