Hi All!
We're deploying a custom real time report in a UCCX 9.0.2. The problem we're facing is the following:
Sometimes when our Select is executed, the table rtcsqssummary makes a locked and the CUIC returns a exception.
Follow below the query that is executed each 15 seconds:
SELECT
SUBSTR(rtc.csqname,1,LENGTH(rtc.csqname)-3) AS nome, SUM(rtc.totalcalls) AS call_total, SUM(rtc.callsabandoned )AS abandoned_total, SUM(rtc.callswaiting) AS queue, MAX(rtc.oldestcontact) AS tme FROM rtcsqssummary rtc
WHERE
(MDY(MONTH(enddatetime),DAY(enddatetime),YEAR(enddatetime))-MDY(MONTH(startdatetime),DAY(startdatetime),YEAR(startdatetime)) < 5 )
AND
(rtc.csqname LIKE 'CSQ_CONEC%' OR rtc.csqname LIKE 'CSQ_MICRO%' OR rtc.csqname LIKE 'CSQ_MONIT%' OR rtc.csqname LIKE 'CSQ_TELEC%' OR rtc.csqname LIKE 'CSQ_WINDOWS%')
AND (rtc.csqname NOT LIKE 'CSQ_MICROINFORMATICA%' )
GROUP BY 1
FOR READ ONLY;
You guys have any ideia what can be? Tks
Regards,
Arnaldo Junior
