CSCvb67761 - UCCX 11.x Live Data Streaming Source Offline after and maxThreads exhausted on port 9443

[Joey Gore]

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?

[lphuntso]

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

[Joey Gore]

Thanks Lobsang.

I have the SU in hand from another case and the engineer shared it. Waiting until call volume lowers before applying it.