Nope clean install.. been live for 90 days or so... On Mon, Dec 21, 2015 at 3:03 PM, Ryan Huff <[email protected]> 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: [email protected] > > Spark: [email protected] > > Twitter: @ryanthomashuff <http://twitter.com/ryanthomashuff> > > LinkedIn: ryanthomashuff <http://linkedin.com/in/ryanthomashuff> > > Web ryanthomashuff.com > > > ------------------------------ > *From:* cisco-voip <[email protected]> on behalf of > Jonathan Charles <[email protected]> > *Sent:* Monday, December 21, 2015 3:39 P > *To:* Anthony Holloway > *Cc:* [email protected] > *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 < > [email protected]> 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 <[email protected]> >> 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 >>> [email protected] >>> https://puck.nether.net/mailman/listinfo/cisco-voip >>> >>> >> >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
