<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Perfect thanks for the additional info, it will definitely help. It appears the numbers that errored are all not active, which seems to explain the problem there.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Matthew G. Loraditch – CCNP-Voice, CCNA, CCDA<br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
1965 Greenspring Drive</span><span style="color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D">Timonium, MD 21093</span><span style="color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
voice. 410.252.8830<br>
fax. 410.252.9284 <br>
<br>
<a href="http://twitter.com/heliontech"><span style="color:blue">Twitter</span></a> |
<a href="http://www.facebook.com/#!/pages/Helion/252157915296"><span style="color:blue">Facebook</span></a> |
<a href="http://www.heliontechnologies.com/"><span style="color:blue">Website</span></a> |
<a href="mailto:support@heliontechnologies.com?subject=Technical%20Support%20Request">
<span style="color:blue">Email Support</span></a></span><span style="font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="color:#1F497D"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Brian Meade (brmeade) [mailto:brmeade@cisco.com]
<br>
<b>Sent:</b> Wednesday, October 09, 2013 9:59 PM<br>
<b>To:</b> Matthew Loraditch; cisco-voip@puck.nether.net<br>
<b>Subject:</b> RE: Import on CUCM Several Failed Devices<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Not exactly sure on that one.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">From the CUCM data dictionary (<a href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf</a>),
we see the pickupgrouplinemap table has the fknumplan_line column. The Pickup Group Line Map table is used to map pickup groups to corresponding directory numbers (which each exist in the fknumplan table). I would guess you may have shared DNs in the template
maybe getting assigned to different Pickup groups? Or maybe just having any shared lines with Pickup groups might mess this up. Do those records have pickup groups assigned?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Also, the Bulk Provisioning Service logs may have a little more detail on what it’s throwing up at. I’d suggest setting the BPS traces to Debug level, running the import again, and then pulling the BPS logs
via RTMT to take a look. You could also just watch it process records live by running “file tail activelog cm/trace/bps/log4j/ recent” on the publisher.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Brian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Matthew Loraditch [<a href="mailto:MLoraditch@heliontechnologies.com">mailto:MLoraditch@heliontechnologies.com</a>]
<br>
<b>Sent:</b> Wednesday, October 09, 2013 9:40 PM<br>
<b>To:</b> Brian Meade (brmeade); <a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> RE: Import on CUCM Several Failed Devices<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Holy Cow that was it. My list of errors is much smaller and manageable now.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Don’t suppose this “</span>4700 Unique constraint (informix.ix_pickupgrouplinemap_fknumplan_line) violated.” Has an easy solution somewhere?<o:p></o:p></p>
<p class="MsoNormal">I’ve only got nine so I am ok doing manually but I’ve 5 more customers to do this migration for eventually so you never know when it might hit again.<span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Matthew G. Loraditch – CCNP-Voice, CCNA, CCDA<br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
1965 Greenspring Drive</span><span style="color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D">Timonium, MD 21093</span><span style="color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
voice. 410.252.8830<br>
fax. 410.252.9284 <br>
<br>
<a href="http://twitter.com/heliontech"><span style="color:blue">Twitter</span></a> |
<a href="http://www.facebook.com/#!/pages/Helion/252157915296"><span style="color:blue">Facebook</span></a> |
<a href="http://www.heliontechnologies.com/"><span style="color:blue">Website</span></a> |
<a href="mailto:support@heliontechnologies.com?subject=Technical%20Support%20Request">
<span style="color:blue">Email Support</span></a></span><span style="font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="color:#1F497D"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Brian Meade (brmeade) [<a href="mailto:brmeade@cisco.com">mailto:brmeade@cisco.com</a>]
<br>
<b>Sent:</b> Wednesday, October 09, 2013 9:28 PM<br>
<b>To:</b> Matthew Loraditch; <a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> RE: Import on CUCM Several Failed Devices<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Matthew,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I found someone who had a similar issue with BE5000 to BE6000 migration. The solution was to clear out all the user ID’s from the UserID1 field and move them to the Owner User ID Field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Brian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> cisco-voip [<a href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Matthew Loraditch<br>
<b>Sent:</b> Wednesday, October 09, 2013 9:22 PM<br>
<b>To:</b> <a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> [cisco-voip] Import on CUCM Several Failed Devices<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">CMBE5K to 6k, same version to same version,<o:p></o:p></p>
<p class="MsoNormal">32 Devices Failed with 1 of 2 errors:<o:p></o:p></p>
<p class="MsoNormal">SEPXXXX Index: 1, Size: 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">OR<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">SEPXXXX DEVICE-USER Association :: Error : Unique constraint (informix.mx_229_1656_1655_2484) violated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Apparently what’s good enough for the BE5K database isn’t for a regular CUCM DB….
<o:p></o:p></p>
<p class="MsoNormal">Seriously, anyone have a clue what these errors mean? Hard to fix when the error is so vague.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#003366"><img border="0" width="225" height="105" id="Picture_x0020_1" src="cid:image001.jpg@01CEC53B.03B79BB0" alt="Description: cid:image001.jpg@01C95158.4441E1B0"></span><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Matthew G. Loraditch – CCNP-Voice, CCNA, CCDA<br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif""><br>
1965 Greenspring Drive</span><br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif"">Timonium, MD 21093</span><br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif""><br>
voice. 410.252.8830<br>
fax. 410.252.9284 <br>
<br>
<a href="http://twitter.com/heliontech"><span style="color:blue">Twitter</span></a> |
<a href="http://www.facebook.com/#!/pages/Helion/252157915296"><span style="color:blue">Facebook</span></a> |
<a href="http://www.heliontechnologies.com/"><span style="color:blue">Website</span></a> |
<a href="mailto:support@heliontechnologies.com?subject=Technical%20Support%20Request">
<span style="color:blue">Email Support</span></a></span><span style="font-family:"Arial","sans-serif""><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><img border="0" width="214" height="58" id="Picture_x0020_2" src="cid:image002.png@01CEC53B.03B79BB0" alt="cid:image002.png@01CD4007.FFC0DA30"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>