[cisco-voip] Error while trying to delete partitions

[cips]

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