[cisco-voip] CUCM 6.1.2 and VG224 in Bulk

[Nick Griffin]

Same Results:

admin:run sql select name from device where name like '%1E4A5483EF'
name
====
admin:run sql select name from device where name like 'SKIGW1E4A5483EF'
name
====
Attempting to import still show's the duplicate index error.

On Tue, Jul 15, 2008 at 10:37 AM, Wes Sisk <wsisk at cisco.com> wrote:

> change '=' to 'like' and give a try. also try:
> run sql select name from device where name like '%1E4A5483EF'
>
> /Wes
>
> Nick Griffin wrote:
>
>   Allright, I found one that was complaining about "duplicate index". I
> deleted the gateway from CUCM administration and ran your query:
>
> admin:run sql select name from device where name = 'SKIGW1E4A5483EF'
> name
> ====
> admin:
> It doesn't appear to show anything even when a device IS configured in call
> manager.
> Here is one that exists in CUCM GW configuration:
>
> admin:run sql select name from device where name = 'SKIGW1E4A5482B9'
> name
> ====
>
> Thoughts?
>
> Thanks!
>
> On Mon, Jul 14, 2008 at 4:27 PM, Ryan Ratliff <rratliff at cisco.com> wrote:
>
>> The unique index column is most likely the device name.  Try doing a (run
>> sql select name from device where name = 'SKIGW1F9E075583') from the CLI,
>> assuming the one below is a duplicate.
>>
>> -Ryan
>>
>>   On Jul 14, 2008, at 5:23 PM, Nick Griffin wrote:
>>
>> I have the need to import approximately 800 analog extensions off of 32
>> VG224's. I am able to get nearly 700 of them imported, however there are
>> misc phones that are not importing with the error message below. Is there
>> any way to get more information regarding what the duplicate value may be? I
>> don't believe duplicate Dn's throw this error, at least not in my testing.
>>
>> Error on Job Scheduler:
>> duplicate value in a UNIQUE INDEX column
>>
>> Example Entry in vg224 import file:
>>
>> DOMAIN NAME,DESCRIPTION,SLOT,SUBUNIT,PORT DIRECTORY NUMBER,PORT NUMBER,PORT DESCRIPTION,ALERTING NAME,ALERTING NAME ASCII,DISPLAY,ASCII DISPLAY,EXTERNAL PHONE NUMBER MASK,PARTITION,FORWARD ALL CSS,LINE CSS,LINE DESCRIPTION,FORWARD BUSY EXTERNAL CSS,FORWARD BUSY INTERNAL CSS,FORWARD NO ANSWER EXTERNAL CSS,FORWARD NO ANSWER INTERNAL CSS,FORWARD NO COVERAGE INTERNAL CSS,FORWARD NO COVERAGE EXTERNAL CSS
>>
>>
>> SKIGW1F9E075583,,2,0,3377,22,Construction Trailer,Construction Trailer,Construction Trailer,Construction Trailer,Construction Trailer,417690XXXX,,CSS-Campus-COS2,CSS-Campus-COS4,Construction Trailer,,,,,,
>>
>>
>> Thoughts appreciated!
>>
>> Nick Griffin
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
> ------------------------------
>
> _______________________________________________
> cisco-voip mailing listcisco-voip at puck.nether.nethttps://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080715/0c2e88c1/attachment.html>