Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Delete an ADP Profile

We have a problem enabling a Cisco 7960 device for Extension Mobility. Whenever we check the checkbox in the IP Phone (device) configuration page, we get "Method Call Failed (4)" and I think this is because there is an orphaned ADP for this phone. Does anyone know how to delete the ADP for this IP Phone? I tried using BAT and I am not able to do so, I also get an error. There's no way I can delete an ADP in Call Manager Phone COnfiuration page, I can only list under Device Profile.

Please let me know if you have any idea how I can cleanly remove an Auto-Generated Device Profile in the Call Manager so I can enable this IP Phone for Ext. Mobility.

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Delete an ADP Profile

Jun,

You may be running into CSCsl33794.

http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCsl33794

If you are comfortable with SQL, remove the references in the Telecaster table for the orphaned ADP then delete the ADP profile from the Device table via SQL server enterprise manager.

1. Find the pkid of the unwanted ADP in Device table.

2. Open the Telecaster table and find the row which has fkdevice = pkid of the unwanted ADP. Delete this row.

3. Delete the unwanted ADP row in device table. (eg. DELETE FROM Device where Name = 'ADPaabbccddeeff')

You might run into referential constraints, for example if the unwanted ADP is subscribed to a service, so every field that references the unwanted ADP device would have to be removed for you to successfully delete the device.

Hope this helps.

Regards,

Michael.

3 REPLIES
Cisco Employee

Re: Delete an ADP Profile

Jun,

You may be running into CSCsl33794.

http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCsl33794

If you are comfortable with SQL, remove the references in the Telecaster table for the orphaned ADP then delete the ADP profile from the Device table via SQL server enterprise manager.

1. Find the pkid of the unwanted ADP in Device table.

2. Open the Telecaster table and find the row which has fkdevice = pkid of the unwanted ADP. Delete this row.

3. Delete the unwanted ADP row in device table. (eg. DELETE FROM Device where Name = 'ADPaabbccddeeff')

You might run into referential constraints, for example if the unwanted ADP is subscribed to a service, so every field that references the unwanted ADP device would have to be removed for you to successfully delete the device.

Hope this helps.

Regards,

Michael.

New Member

Re: Delete an ADP Profile

Michael,

That fixed my problem. Thanks very much!!!

Cisco Employee

Re: Delete an ADP Profile

You are welcome, Jun. Thanks for the update and the good news. Thanks also for the opportunity to assist here.

Regards,

Michael.

1469
Views
5
Helpful
3
Replies
CreatePlease to create content