[cisco-voip] Import on CUCM Several Failed Devices

[Matthew Loraditch]

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.


Matthew G. Loraditch - CCNP-Voice, CCNA, CCDA

1965 Greenspring Drive
Timonium, MD 21093

voice. 410.252.8830
fax.  410.252.9284

Twitter<http://twitter.com/heliontech>  |  Facebook<http://www.facebook.com/#!/pages/Helion/252157915296>  | Website<http://www.heliontechnologies.com/>  |  Email Support<mailto:support at heliontechnologies.com?subject=Technical%20Support%20Request>


From: Brian Meade (brmeade) [mailto:brmeade at cisco.com]
Sent: Wednesday, October 09, 2013 9:59 PM
To: Matthew Loraditch; cisco-voip at puck.nether.net
Subject: RE: Import on CUCM Several Failed Devices

Not exactly sure on that one.

>From the CUCM data dictionary (http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf), 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?

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.

Brian

From: Matthew Loraditch [mailto:MLoraditch at heliontechnologies.com]
Sent: Wednesday, October 09, 2013 9:40 PM
To: Brian Meade (brmeade); cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: RE: Import on CUCM Several Failed Devices

Holy Cow that was it. My list of errors is much smaller and manageable now.

Don't suppose this "4700 Unique constraint (informix.ix_pickupgrouplinemap_fknumplan_line) violated." Has an easy solution somewhere?
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.


Matthew G. Loraditch - CCNP-Voice, CCNA, CCDA

1965 Greenspring Drive
Timonium, MD 21093

voice. 410.252.8830
fax.  410.252.9284

Twitter<http://twitter.com/heliontech>  |  Facebook<http://www.facebook.com/#!/pages/Helion/252157915296>  | Website<http://www.heliontechnologies.com/>  |  Email Support<mailto:support at heliontechnologies.com?subject=Technical%20Support%20Request>


From: Brian Meade (brmeade) [mailto:brmeade at cisco.com]
Sent: Wednesday, October 09, 2013 9:28 PM
To: Matthew Loraditch; cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: RE: Import on CUCM Several Failed Devices

Matthew,

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.

Brian

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Matthew Loraditch
Sent: Wednesday, October 09, 2013 9:22 PM
To: cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: [cisco-voip] Import on CUCM Several Failed Devices

CMBE5K to 6k, same version to same version,
32 Devices Failed with 1 of 2 errors:
SEPXXXX Index: 1, Size: 1

OR

SEPXXXX DEVICE-USER Association :: Error : Unique constraint (informix.mx_229_1656_1655_2484) violated.

Apparently what's good enough for the BE5K database isn't for a regular CUCM DB....
Seriously, anyone have a clue what these errors mean? Hard to fix when the error is so vague.


[Description: cid:image001.jpg at 01C95158.4441E1B0]
Matthew G. Loraditch - CCNP-Voice, CCNA, CCDA

1965 Greenspring Drive
Timonium, MD 21093

voice. 410.252.8830
fax.  410.252.9284

Twitter<http://twitter.com/heliontech>  |  Facebook<http://www.facebook.com/#!/pages/Helion/252157915296>  | Website<http://www.heliontechnologies.com/>  |  Email Support<mailto:support at heliontechnologies.com?subject=Technical%20Support%20Request>
[cid:image002.png at 01CD4007.FFC0DA30]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20131010/e95f4a58/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 33011 bytes
Desc: image001.jpg
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20131010/e95f4a58/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 10887 bytes
Desc: image002.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20131010/e95f4a58/attachment.png>