Update phone issue with CCM5.1

Answered Question
Jul 30th, 2007
User Badges:

Hi,

I have big issue while trying to update phones in CCM 5.1 : when I check the extension mobility to a phone and save, the following status message occurs :

Update failed. Could not insert new row - "duplicate value in a UNIQUE INDEX column".

Did someone have the same problem ?


Thanking you in advance

Correct Answer by jfawcett about 9 years 7 months ago

Hi I had the same problem with and autogenerated file.Managed to remove it by

going to the device profile and under search options changed Find user to Find Autogenerated. This showed the adp profile that was generated. I was then able to delete it. Worked OK


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Majdi Harb Mon, 07/30/2007 - 05:12
User Badges:
  • Silver, 250 points or more

do u encounter this error in each phone u add or just on one phone?


this error sometimes comes up when u add a phone with same unique value (like MAC) that was previuosly entered for another phone.


please check and update


nonosensei Mon, 07/30/2007 - 05:27
User Badges:

The same for each phone.

The phone already exist, but it seems that when I check the extension mobility and save, the CCM try to add a new phone even if it already exist.

Majdi Harb Mon, 07/30/2007 - 05:32
User Badges:
  • Silver, 250 points or more

strange problem

i think u have to open a TAC

nonosensei Mon, 07/30/2007 - 05:34
User Badges:

YEs I htink I have no choice.


thanks for your reply

agster Fri, 08/03/2007 - 02:38
User Badges:

I have exactly the same problem, but in my instance, it's only when we try to assign and update the Ext Mob profile on a phone which previously existed, then deleted and has been re-added.

Please let me know what Cisco TAC say, although I may have to open the same case :-(

nonosensei Fri, 08/03/2007 - 04:28
User Badges:

HI,

I have found the solution, it works for me.

When a device is autoregistred, it gets a default device profile named "[email protected]" of the device. So I search the default device profile associated with the phone I have a problem with ( your search the @ mac of the phone in the device profile search, with the search option positioned to "autogenerated").

You delete this profile, then your phone will get a new one, and you can add it the EM functionnality.


Regards

S M85 Thu, 11/15/2007 - 02:50
User Badges:

Hello guys,


I see that for the TS the problem is solved. The phones @my new customer are not auto generated. can you confirm to me how you solved this? The phone is giving me the error, update failed could not insert new row - duplicate value in a unique index column.



nonosensei Mon, 11/19/2007 - 02:11
User Badges:

Hi,


My phones are autogenerated. I just delete the default auto registration profile and then I worked.


Regards

Correct Answer
jfawcett Thu, 11/29/2007 - 11:35
User Badges:

Hi I had the same problem with and autogenerated file.Managed to remove it by

going to the device profile and under search options changed Find user to Find Autogenerated. This showed the adp profile that was generated. I was then able to delete it. Worked OK


Actions

This Discussion