<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
What version of UCM are you on? If it’s 11.5 SU3 check informix ccm.log for something like this:
<div class="">
<blockquote type="cite" class="">23:13:59 SCHAPI: last statement aus_refresh_stats(integer,integer)</blockquote>
<blockquote type="cite" class="">23:13:59 SCHAPI: [Auto Update Statistics Refresh 43-2] Error -217 Column (aus_cmd_dbs_priority) not found in any table in the query (or SLV is undefined). </blockquote>
<div class=""><br class="">
</div>
<div class="">This is CSCva78144.</div>
<div class="">
<div class=""><br class="webkit-block-placeholder">
</div>
<div class="">I ask because I’m pretty sure one of those last two numbers is the time taken to process the request, and neither of those are a good number.</div>
<div class=""><br class="">
</div>
<div class="">-Ryan </div>
<div><br class="">
<div class="">On Apr 13, 2018, at 2:22 PM, ROZA, Ariel <<a href="mailto:Ariel.ROZA@la.logicalis.com" class="">Ariel.ROZA@la.logicalis.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Hi, guys and gals.<o:p class=""></o:p></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<o:p class=""> </o:p></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class="">I am trying to troubleshoot a High CPU Alarm on a CUCM Subscriber:<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class="">I ran the “utils diagnose test” command and got warnings on the tomcat_sessions module. gathered all the tomcats logs around the time of the event and found lots of <b class="">GET /cucm-uds/users HTTP/1.1 200 1383 1611</b><span class="Apple-converted-space"> </span>queries.<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class="">In the Bug Search tool I found several bugs for old jabber versions regarding this, one enhancement request but no fixes.<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class="">I was wondering if it is possible to load balance the UDS queries around the cluster using several DNS SRV records for _<i class="">cisco-uds.</i>_tcp<domain> with the same priority /weight to load balance the queries, or if this
breaks functionality, somehow. The only examples I found are ones with different weight/priority.<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" class="">Regards,<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<b class=""><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(228, 30, 38);" class=""><o:p class=""> </o:p></span></b></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<b class=""><span lang="EN-US" style="font-family: Arial, sans-serif; color: rgb(228, 30, 38);" class="">Ariel Roza</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class=""><span class="Apple-converted-space"> </span><br class="">
</span><b class=""><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">Collaboration Support Engineer</span></b><span lang="EN-US" style="font-size: 12pt; font-family: "Times New Roman", serif; color: rgb(63, 66, 67);" class=""><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">t: +54 11 5282-0458<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">c: +54 9 11 5017-4417 webex:<span class="Apple-converted-space"> </span></span><span class=""><a href="http://logicalis-la.webex.com/join/ariel.roza" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: blue;" class="">http://logicalis-la.webex.com/join/ariel.roza</span></a></span><span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class=""><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">Av. Belgrano 955 – Piso 20 – CABA – Argentina – C1092AAJ<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span class=""><a href="http://www.la.logicalis.com/" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(228, 30, 38);" class="">www.la.logicalis.com</span></a></span><span lang="EN-US" style="font-size: 9pt; font-family: "Times New Roman", serif; color: rgb(228, 30, 38);" class=""><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<b class=""><span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(228, 30, 38);" class="">_________________________________________________<br class="">
</span></b><b class=""><span lang="EN-US" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">Business<span class="Apple-converted-space"> </span></span></b><b class=""><span lang="EN-GB" style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(63, 66, 67);" class="">and
technology working as one</span></b><b class=""><span lang="EN-GB" style="font-size: 9pt; color: rgb(63, 66, 67);" class=""> </span></b><b class=""><span lang="EN-GB" style="font-size: 9pt; color: rgb(63, 66, 67);" class=""><o:p class=""></o:p></span></b></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="color: rgb(31, 73, 125);" class=""><span id="cid:image001.png@01D3D33A.1FE8F100"><image001.png></span><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="color: rgb(31, 73, 125);" class=""><span id="cid:image002.png@01D3D33A.1FE8F100"><image002.png></span><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span id="cid:image004.jpg@01D3D33B.44B8CF90"><image004.jpg></span><a href="http://twitter.com/LogicalisLatam" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="font-size: 8pt; color: blue; text-decoration: none;" class=""><span id="cid:image005.png@01D3D33A.1FE8F100"><image005.png></span></span></a><span style="font-size: 8pt; color: rgb(31, 73, 125);" class=""> </span><a href="http://es-es.facebook.com/pages/Logicalis-Latam/234648439078" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="font-size: 8pt; color: blue; text-decoration: none;" class=""><span id="cid:image006.png@01D3D33A.1FE8F100"><image006.png></span></span></a><span style="font-size: 8pt; color: rgb(31, 73, 125);" class=""> </span><a href="http://www.youtube.com/logicalislatam" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="font-size: 8pt; color: blue; text-decoration: none;" class=""><span id="cid:image007.png@01D3D33A.1FE8F100"><image007.png></span></span></a><span style="font-size: 8pt; color: rgb(31, 73, 125);" class=""> <o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(166, 166, 166);" class="">Logicalis Argentina S.A. solo puede ser obligado por sus representantes legales conforme los límites establecidos en el acto constitutivo y la legislación en vigor.<span class="Apple-converted-space"> </span><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(166, 166, 166);" class="">El contenido del presente correo electrónico e inclusive sus anexos contienen información confidencial.<o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(166, 166, 166);" class="">El mismo no puede ser divulgado y/o utilizado por cualquiera otro distinto al destinatario, ni puede ser copiado de cualquier forma.</span><span style="color: rgb(31, 73, 125);" class=""><o:p class=""></o:p></span></div>
<div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<o:p class=""> </o:p></div>
</div>
<span style="caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<span style="caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">cisco-voip
mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<a href="mailto:cisco-voip@puck.nether.net" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">cisco-voip@puck.nether.net</a><br style="caret-color: rgb(0, 0, 0); font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div>
</div>
<br class="">
</div>
</div>
</body>
</html>