Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX 8.5 - db_cra tables do not update simultaneously

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?

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

UCCX 8.5 - db_cra tables do not update simultaneously

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
1 REPLY
Super Bronze

UCCX 8.5 - db_cra tables do not update simultaneously

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
361
Views
0
Helpful
1
Replies