[cisco-voip] Devices assigned to same user twice...

[Jonathan Charles]

Nope clean install.. been live for 90 days or so...

On Mon, Dec 21, 2015 at 3:03 PM, Ryan Huff <ryanhuff at outlook.com> wrote:

> Jonathan,
>
>
> My suspicion is, and if you ran this command from the CLI of the
> Publisher, you might get duplicates;
>
>
> *run sql select eu.userid, d.name <http://d.name>, d.description,
> n.dnorpattern as DN, rp.name <http://rp.name> 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*
>
>
> As to *how* this might of happened I am not sure other than to say not
> likely organic. Perhaps an uploaded BAT CSV with the contents of *User ID
> 1 *duplicated (accidentally) into the column of *User ID 2*?
>
>
> 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.
> Are you dealing with a cluster that was recently upgraded, and if so, by
> refresh?
>
>
> Thanks,
>
>
> = Ryan =
>
>
>
> Email: ryanthomashuff at outlook.com
>
> Spark: ryanthomashuff at outlook.com
>
> Twitter: @ryanthomashuff <http://twitter.com/ryanthomashuff>
>
> LinkedIn: ryanthomashuff <http://linkedin.com/in/ryanthomashuff>
>
> Web ryanthomashuff.com
>
>
> ------------------------------
> *From:* cisco-voip <cisco-voip-bounces at puck.nether.net> on behalf of
> Jonathan Charles <jonvoip at gmail.com>
> *Sent:* Monday, December 21, 2015 3:39 P
> *To:* Anthony Holloway
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] Devices assigned to same user twice...
>
> I mean this:
>
> [image: Inline image 1]
>
> 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?
>
>
>
> Jonathan
>
> On Mon, Dec 21, 2015 at 2:33 PM, Anthony Holloway <
> avholloway+cisco-voip at gmail.com> wrote:
>
>> 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"
>>
>> 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.
>>
>> On Mon, Dec 21, 2015 at 11:11 AM, Jonathan Charles <jonvoip at gmail.com>
>> wrote:
>>
>>> 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)...
>>>
>>> Further, TAC is claiming that this is causing the CCM service to spike
>>> and crash.
>>>
>>> Just curious if there is a known issue with this... and possibly how it
>>> happened
>>>
>>>
>>>
>>> Jonathan
>>>
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20151221/6cd8c16b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 6797 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20151221/6cd8c16b/attachment.png>