<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Curious, when you insert a new user and associate control of a device to that user, does it duplicate the user ID at that point, or is this condition only impacting existing users?</p>
<p><br>
</p>
The first thing I'd do is make sure cluster replication is healthy; however if you've got TAC involved, I'm sure they've checked that (<em>utils dbreplication runtimestate</em>)? Also, could you show the output of;<br>
<ul>
<li><em>utils ntp server list</em></li><li><em>utils ntp status</em></li></ul>
<p></p>
<p><br>
</p>
<p>Thanks,<br>
</p>
<p><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
= Ryan =
<p><br>
</p>
<p><br>
</p>
<p>Email: ryanthomashuff@outlook.com</p>
<p>Spark: ryanthomashuff@outlook.com</p>
<p>Twitter: <a id="LPNoLP" href="http://twitter.com/ryanthomashuff">@ryanthomashuff</a><br>
</p>
<p>LinkedIn: <a id="LPNoLP" href="http://linkedin.com/in/ryanthomashuff">ryanthomashuff</a><br>
</p>
<p>Web <a id="LPNoLP" href="http://ryanthomashuff.com">ryanthomashuff.com</a></p>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Jonathan Charles <jonvoip@gmail.com><br>
<b>Sent:</b> Monday, December 21, 2015 4:43 PM<br>
<b>To:</b> Ryan Huff<br>
<b>Cc:</b> Anthony Holloway; cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Devices assigned to same user twice...</font>
<div> </div>
</div>
<div>
<div dir="ltr">Nope clean install.. been live for 90 days or so... </div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Dec 21, 2015 at 3:03 PM, Ryan Huff <span dir="ltr">
<<a href="mailto:ryanhuff@outlook.com" target="_blank">ryanhuff@outlook.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div dir="ltr">
<div style="font-size:12pt; color:#000000; background-color:#ffffff; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Jonathan,</p>
<p><br>
</p>
<p>My suspicion is, and if you ran this command from the CLI of the Publisher, you might get duplicates;</p>
<p><br>
</p>
<p><i>run sql select eu.userid, <a href="http://d.name" target="_blank">d.name</a>, d.description, n.dnorpattern as DN,
<a href="http://rp.name" target="_blank">rp.name</a> as partition from device as d inner join devicenumplanmap as dnpm on dnpm.fkdevice = d.pkid inner join enduserdevicemap as eudm on eudm.fkdevice=d.pkid inner join enduser as eu on eudm.fkenduser=eu.pkid inner
join numplan as n on dnpm.fknumplan = n.pkid inner join routepartition as rp on n.fkroutepartition=rp.pkid and d.tkclass = 1</i></p>
<p><i><br>
</i></p>
<p>As to <i>how</i> this might of happened I am not sure other than to say not likely organic. Perhaps an uploaded BAT CSV with the contents of
<i>User ID 1 </i>duplicated (accidentally) into the column of <i>User ID 2</i>?</p>
<p><br>
</p>
<p>Either way, that would cause all sorts of weirdness, could cause an infinite loop in the CTI control delegation process .... and who knows what else.
<br>
Are you dealing with a cluster that was recently upgraded, and if so, by refresh?</p>
<p><br>
</p>
<p>Thanks,<br>
</p>
<span class="">
<p><br>
</p>
<div>
<div style="font-size:12pt; color:#000000; background-color:#ffffff; font-family:Calibri,Arial,Helvetica,sans-serif">
= Ryan =
<p><br>
</p>
<p><br>
</p>
<p>Email: <a href="mailto:ryanthomashuff@outlook.com" target="_blank">ryanthomashuff@outlook.com</a></p>
<p>Spark: <a href="mailto:ryanthomashuff@outlook.com" target="_blank">ryanthomashuff@outlook.com</a></p>
<p>Twitter: <a href="http://twitter.com/ryanthomashuff" target="_blank">@ryanthomashuff</a><br>
</p>
<p>LinkedIn: <a href="http://linkedin.com/in/ryanthomashuff" target="_blank">ryanthomashuff</a><br>
</p>
<p>Web <a href="http://ryanthomashuff.com" target="_blank">ryanthomashuff.com</a></p>
</div>
</div>
<br>
<br>
</span>
<div style="color:rgb(0,0,0)">
<hr style="display:inline-block; width:98%">
<div dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><span class=""><b>From:</b> cisco-voip <<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>> on behalf of Jonathan
Charles <<a href="mailto:jonvoip@gmail.com" target="_blank">jonvoip@gmail.com</a>><br>
</span><b>Sent:</b> Monday, December 21, 2015 3:39 P<br>
<b>To:</b> Anthony Holloway<br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><span class=""><br>
<b>Subject:</b> Re: [cisco-voip] Devices assigned to same user twice...</span></font>
<div> </div>
</div>
<div>
<div class="h5">
<div>
<div dir="ltr">I mean this:
<div><br>
</div>
<div><img style="-moz-user-select: none;" tabindex="0" alt="Inline image 1" height="195" width="293" src="cid:ii_151c644982c970fc"><br>
</div>
<div><br>
</div>
<div>So, for each device, each user is assigned twice... I need to clear this out and reassociate... any idea how to? Other than to clear out the fields and re-upload?</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Jonathan</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Dec 21, 2015 at 2:33 PM, Anthony Holloway <span dir="ltr">
<<a href="mailto:avholloway+cisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div dir="ltr">The fields marked "User ID 1", "User ID 2", "User ID N", etc. are not the Owner User ID. That field is marked "Owner User ID"
<div><br>
</div>
<div>The User ID N fields are a list of user who can control this device. In other words, simply go to one of the End User accounts in CUCM and disassociate the phone from the user's control and these will start to go away.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>
<div>On Mon, Dec 21, 2015 at 11:11 AM, Jonathan Charles <span dir="ltr"><<a href="mailto:jonvoip@gmail.com" target="_blank">jonvoip@gmail.com</a>></span> wrote:<br>
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div>
<div>
<div dir="ltr">So, doing a bulk export of phones inCUCM 10.5.2 I noticed that many of the devices have the same user assigned twice (as User ID 1 and User ID 2)...
<div><br>
</div>
<div>Further, TAC is claiming that this is causing the CCM service to spike and crash.</div>
<div><br>
</div>
<div>Just curious if there is a known issue with this... and possibly how it happened</div>
<span><font color="#888888">
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Jonathan</div>
</font></span></div>
<br>
</div>
</div>
<span>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br>
</span></blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</body>
</html>