CUCM5, insert phones/users using BAT, got error

Answered Question
Dec 11th, 2007
User Badges:

Insert Phones/users


Begin Time : 12/11/2007 11:05:53


Query :


Insert Phones/Users in lmc_phone_users_Dec11_2007.txt


Failure Details :


Device Name/User ID Error Code Error Description


-----------------------------------------------------------------------------------------


001D45B5E7D9 EXTENSION MOBILITY :: Error : Could not insert new row - duplicate value in a UNIQUE INDEX column.


Please help. Thanks

Correct Answer by allan.thomas about 9 years 4 months ago

Verify that the UDP name is unique, that it does not already exist. For example if you are using numerics for UDPs, then search device profiles for this same profile name.


Regards

Allan.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4.5 (2 ratings)
Loading.
Tommer Catlin Tue, 12/11/2007 - 12:27
User Badges:
  • Green, 3000 points or more

Check your CSV File, I have n noticed lately that the column headers have a space before the first letter. This throws off the entire import then.


Also, do a double check. Open the CSV file in notepad, count the commas and fields. It should add up to 36 I believe. If you see commas missing, that is why.


YOu may also have to use the device format as SEP001D45B5E7D9

xiaoliangyue Tue, 12/11/2007 - 12:55
User Badges:

Thanks, Tommer. I actually tried to add 10 phones/users, only the 1st failed with the above error msg.

Tommer Catlin Tue, 12/11/2007 - 12:58
User Badges:
  • Green, 3000 points or more

Can you copy and paste the raw Notepad for that one phone here?

xiaoliangyue Tue, 12/11/2007 - 13:00
User Badges:

FIRST NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,DEVICE NAME,DESCRIPTION,CSS,DEVICE POOL,DIRECTORY NUMBER 1,FORWARD BUSY EXTERNAL DESTINATION 1,FORWARD BUSY INTERNAL DESTINATION 1,FORWARD NO ANSWER EXTERNAL DESTINATION 1,FORWARD NO ANSWER INTERNAL DESTINATION 1,PARTITION 1,ALERTING NAME 1,ALERTING NAME ASCII 1,SPEED DIAL NUMBER 1,SPEED DIAL LABEL 1,SPEED DIAL LABEL ASCII 1

,Desk1,41861,12345,,,12345,,,41861,,,,,,,,001D45B5E7D9,LMC Desk1,CSS_LMC_Unrestricted,,41861,,,,,,,,,,


Tommer Catlin Tue, 12/11/2007 - 13:04
User Badges:
  • Green, 3000 points or more

Yeah, the device name is not unique or it is not the correct format. Also make sure the UDP was already created. If it's not created, then you cant associated it to the line, etc.

Correct Answer
allan.thomas Tue, 12/11/2007 - 13:00
User Badges:
  • Blue, 1500 points or more

Verify that the UDP name is unique, that it does not already exist. For example if you are using numerics for UDPs, then search device profiles for this same profile name.


Regards

Allan.

allan.thomas Tue, 12/11/2007 - 13:17
User Badges:
  • Blue, 1500 points or more

No problem, good to hear you resolved the problem, appreciate the rating, thanks.


Best regards and seasons greetings.


Allan


Actions

This Discussion