[cisco-voip] Error while trying to delete partitions

[Dennis Heim]

Route Plan report... and see if you find it there.. it may be an orphan DN/unassigned DN.

Dennis Heim
Network Voice Engineer
CDW  Advanced Technology Services
11711 N. Meridian Street, Suite 225
Carmel, IN  46032

317.569.4255 Office
317.569.4201 Fax
317.694.6070 Cell
dennis.heim at cdw.com
www.berbee.com


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of cips
Sent: Friday, December 04, 2009 7:23 AM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Error while trying to delete partitions

You can try doing the following to find the links to the partitions from DN's

Ssh to CUCM
Login
Run command: run sql select name, pkid from routepartition

This will give you an overview of the partitions in the system and their pkid's Write down the pkid that you cannot delete based on the corresponding name 

Run command: run sql select dnorpattern from numplan where fkroutepartition = '80f2b2a7-b305-b507-497a-6f9cff08c494'
Where the pkid number is put in between the quotes.

This now should give you an overview of any number in the system where the pkid/partition is being used.
Next try to delete the DN's accordingly.

Good luck.


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Lewis, Chris
Sent: vrijdag 4 december 2009 10:29
To: Glen Cobby; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Error while trying to delete partitions

Try looking at your DNs as I had an issue whereby a couple of DNs were referenced to a Partition even though they didn't show up in Dependency records

I am running 6.1.2  BTW

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Glen Cobby
Sent: 04 December 2009 09:06
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Error while trying to delete partitions

Hi All,

Before I raise a TAC case I wonder if anyone has seen this error before. We have several partitions that have been used while deploying phones that are now no longer needed. I have checked using dependancy records that the partition is not in use by any devices.
Now if I try and delete the partition I get an error = "Delete Failed. The pkid column in the routepartition table in the database is being referenced from another table. Please check the dependency records and remove the reference and try the delete again."

Just wondering if anyone has seen this before if so what was the fix? I have this across a couple of clusters running CCM 6.1.3.3000.

Thanks

Glen
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

The information contained in this message and its attachments is intended only for the private and confidential use of the intended recipient(s).  If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e- mail is strictly prohibited.
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip