×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

UCCX 8.5 Data lag with ContactCallDetail

Answered Question
Jul 17th, 2012
User Badges:

Hi there,


We are experiencing some strange issues with the ContactCallDetail table. It does not seem to update in real time, seems to update in batches, and 2 hours later. So you will get an update to the table say every 15/30 seconds, with a bunch of calls from about 2 hours ago.


Has anyone else had these issues or know how to fix it?


Many thanks,

Justin

Correct Answer by Aaron Harrison about 5 years 1 month ago

Hi Justin


I can't say I'd ever paid attention to the date fields in rtcsqssummary as they're not massively significant and I tend to look at the DB for historical reporting mainly.


I have checked my system here and I see the same thing - rtcsqssummary shows the local server time stamp, but the records in the historical tables are in UTC.


Aaron

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Aaron Harrison Tue, 07/17/2012 - 05:21
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi Justin


Firstly, only the two rtxxxxxxx tables update in realtime (or every 5 seconds anyway). The other tables typically update fast, but not necessarily near real time and if you speak to TAC that is apparently not an issue.


Secondly - what time zone are you in? The dates in the DB should be in UTC, so if you are two hours offset from UTC that might explain it.


Aaron

Tankfish12 Tue, 07/17/2012 - 05:31
User Badges:

Hi,


Thanks for the info.


So if I understand you correctly, the system only works in UCT time and not local time? But I have noticed that the enddatetime and startdatetime columns in the RtCSQsSummary do have the correct time. So current local time.


Thanks once again

Correct Answer
Aaron Harrison Tue, 07/17/2012 - 05:41
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi Justin


I can't say I'd ever paid attention to the date fields in rtcsqssummary as they're not massively significant and I tend to look at the DB for historical reporting mainly.


I have checked my system here and I see the same thing - rtcsqssummary shows the local server time stamp, but the records in the historical tables are in UTC.


Aaron

Tankfish12 Tue, 07/17/2012 - 06:10
User Badges:

Ok great. That helps a lot.


Thanks for the assistance.


Regards,

Justin

Actions

This Discussion

Related Content