11-29-2016 06:57 AM - edited 03-20-2019 09:10 PM
UCCX 11.x: Live Data Streaming Source Offline after 'maxThreads' exhausted on port 9443
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvb67761/?referring_site...
We rely on the Agent State Detail reports and need them back. Any updates on when a ES or patch is going to be released for 11.5?
11-29-2016 03:36 PM
Hello Joey,
The defect has been fixed by adding an additional table and therefore it involves schema changes.
Root cause:
Agent State Log gadget was querying the required data by joining two tables agentstatedetail and agentconnectiondetail. Both the tables have millions of records. agentstatedetail table has data from 5 to 27 millions records and agentconnectiondetail table has data from 3 to 9 millions. These tables are used for historical reporting. Due to humongous data, the sql query takes lot of time.
You can run the below query via UCCX CLI:
run uccx sql db_cra select count(*) from agentstatedetail
run uccx sql db_cra select count(*) from agentconnectiondetail
for example, below show more than 21 millions and 5millions
admin:run uccx sql db_cra select count(*) from agentstatedetail
(COUNT(*))
----------
21124512
Command successful.
admin:run uccx sql db_cra select count(*) from agentconnectiondetail
(COUNT(*))
----------
5254647
Fix for this issue:
For now, the timeline for the both UCCX 11.5(1)SU1 and 11.0(1)SU1 is end of December.
Regards,
Lobsang Phuntsok
12-20-2016 12:24 PM
Thanks Lobsang.
I have the SU in hand from another case and the engineer shared it. Waiting until call volume lowers before applying it.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide