11-20-2012 06:30 AM - edited 03-16-2019 02:17 PM
Hi,
I can't delete one device pool on CUCM.
This is the message that I received:
"Delete failed. The pkid column in the devicepool table in the database is being referenced from another table. Please check the dependency records, remove the reference, and then try the delete again."
In information about device pool, there is no associated members:
Device Pool: | Auto_Device_Pool-TEMP (0 members**) |
When I go to Dependency record (which are enabled in Enterprise parameters) I can see:
Record Count: 1
Record Type: Device Defaults
Then, when I go to Device Defaults, there is no device that is using that device pool. So I exported device defaults configuration via bulk tool, and in generated csv I found one record that is using this device pool:
DEVICE TYPE,PROTOCOL,LOAD INFORMATION,DEVICE POOL,PHONE TEMPLATE,INACTIVE LOAD INFORMATION
Cisco Dual Mode for iPhone,SIP,,Auto_Device_Pool-TEMP,Standard Dual Mode for iPhone,
However, in CUCM Administration pages, on Device defaults page, this device (Cisco Dual Mode for iPhone) is not listed, so I can't change default pool to something different.
I allready have one more device pool that I can't delete for same reason (device named CTI Port is using it, and it is not displaying on Device default page) so I would like to delete one of this device pools.
Can someone help?
Thanks.
01-15-2013 05:07 AM
Have you allready solve this issue?
I cant list all device defaults...and i need to change de device pool of 7 so i can delete a device pool.
Best Regards
01-15-2013 05:22 AM
Hi
I would probably try loading the latest iPhone .cop file to see if that fixes it.
Re: the CTI Port preventing the other deletion, check in Bulk Admin/Phones/Phone Templates to see if it's referenced in a CTI Port BAT template.
Aaron
01-15-2013 05:49 AM
Hi
Can you try the following on the CUCM CLI:
1. Get the Pkid of the Device pool which you want to delete :
run sql select pkid from devicepool where name='Auto_Device_Pool-TEMP'
2.Check entries in Defaults table for the affected DP:
run sql select * from defaults where fkdevicepool like 'pkid from 1st query'
3. Get the pkid of a DP other than one which you want to delete.
run sql select * from devicepool where name='DPname'
4. Update the defaults table:
run sql update defaults set fkdevicepool='pkid from 3rd query' where fkdevicepool='pkid
from afected DP'
this will help to change the Device pool in the device defaults. Once done. you can delete the device pool.
Regards
Aditya Gupta
01-16-2013 02:12 AM
Works perfectly. Thanks!
Regards,
Carlos Marques
04-04-2018 12:47 AM
How do we get the pkid of the specific device pool from the Publisher?
04-04-2018 02:02 AM
04-23-2018 05:09 AM
To get the pkid of the specific device pool run the query "run sql select pkid from devicepool where name="Name of the DP of which you want to get the pkid".
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide