rtcsqssummary table only showing last 25 created CSQ entries

Unanswered Question
Sep 2nd, 2014
User Badges:

We have a wallboard that is pulling CSQ stats from the rtcsqssummary table.

Its currently only showing the last 25 created CSQs on the wallboard. We have approximately 101 configured. Is there a limit to this table or is it configurable? We are running CCX version 9.0.2.10000-71.

 

Running this command and only 25 entries appear.

admin:run uccx sql db_cra select count (*) from rtcsqssummary
(COUNT(*))
----------
25

However its showing 101 configured and active.

admin:run uccx sql db_cra select distinct count(*) from contactservicequeue where active='t'
(COUNT(*))
----------
101

 

Thanks in advance.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Aaron Harrison Wed, 09/03/2014 - 06:53
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi

That table only updates on the current 'active' node. If you have HA, maybe check the table on the other node, you may be looking at stale data on the secondary from last time it was active.

Otherwise... something odd is going on. There's no max, and no config, it may be reboot time ;-)

Aaron

Actions

This Discussion