04-08-2015 08:59 AM - edited 03-17-2019 02:35 AM
I'm trying to add a phone that was previously registered but now, as far as I can tell, does not show up at all in Call Manager. I am receiving this message: Add failed. Could not insert new row - duplicate value in a UNIQUE INDEX column (Unique Index:device_name)
Any help would be appreciated
04-08-2015 09:11 AM
Hi
Seems like there is still a stale entry in the database that is causing the issue while adding the phone.
Can you get me the output of following sql query on cucm nodes:
run sql select pkid,name from device where name = 'SEP<MAC>'
SEP<MAC> = SEP + MAC address of device you are trying to add.
Also check if there is any replication issue on your cucm cluster
Regards
Aditya Gupta
04-08-2015 10:40 AM
Thanks for taking the time to answer my question. I am very new to Cisco VOIP so excuse my ignorance. I attempted to run the query you requested but appear to be doing something wrong as I am getting a syntax error
04-08-2015 10:52 AM
No worries.. just paste the screenshot of the query you ran and error message you got.
04-08-2015 11:31 AM
04-08-2015 11:41 AM
that's not the correct format. Paste the query as i have written below:
run sql select pkid,name from device where name = 'SEP1CAA07108E0A'
Regards
Aditya Gupta
04-08-2015 11:48 AM
Returns:
The specified table (devices) is not in the database
04-08-2015 01:46 PM
Table name is device not devices
Regards
Aditya Gupta
04-08-2015 10:39 PM
Hi Aditya,
Do you remember the extension that was assigned to the same phone previously?
If yes, then check the extension and it's dependency records. If you don't find any dependency records then try to add phone with different mac address first with the same extension as earlier and then try to modify the mac address again.
Also, try to add phones in all the nodes one by one (i.e PUB and your available SUB's)
Thanks,
Nishant
04-09-2015 06:38 AM
Thank you. I will check
04-09-2015 01:48 PM
Hello,
I hate to ask this question but have you searched for a Phone
based on -> Device name -> contains -> 1CAA07108E0A
Please don't be insulted, but I haven't seen a posting that stated this has been done.
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