<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
change '=' to 'like' and give a try. also try:<br>
run sql select name from device where name like '%1E4A5483EF'<br>
<br>
/Wes<br>
<br>
Nick Griffin wrote:
<blockquote
cite="mid:a2b352c40807150833n5a215f2k35a6bb49025df76b@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Allright, I found one that was complaining about "duplicate
index". I deleted the gateway from CUCM administration and ran your
query:</div>
<div> </div>
<div>admin:run sql select name from device where name =
'SKIGW1E4A5483EF'<br>
name<br>
====<br>
admin:<br>
</div>
<div>It doesn't appear to show anything even when a device IS
configured in call manager.</div>
<div>Here is one that exists in CUCM GW configuration:</div>
<div> </div>
<div>admin:run sql select name from device where name =
'SKIGW1E4A5482B9'<br>
name<br>
====<br>
</div>
<div> </div>
<div>Thoughts?</div>
<div> </div>
<div>Thanks!<br>
<br>
</div>
<div class="gmail_quote">On Mon, Jul 14, 2008 at 4:27 PM, Ryan
Ratliff <<a moz-do-not-send="true" href="mailto:rratliff@cisco.com">rratliff@cisco.com</a>>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<div style="">The unique index column is most likely the device
name. Try doing a (run sql select name from device where name = '<span
style="font-family: -webkit-monospace; white-space: pre;">SKIGW1F9E075583')
from the CLI, assuming the one below is a duplicate.</span>
<div><font face="-webkit-monospace"><span style="white-space: pre;"><br>
</span></font>
<div>
<p style="margin: 0px;"><font
style="font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal;"
face="Helvetica" size="3">-Ryan</font></p>
</div>
<br>
<div>
<div>
<div class="Wj3C7c">
<div>On Jul 14, 2008, at 5:23 PM, Nick Griffin wrote:</div>
<br>
<font size="2">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.<br>
<br>
Error on Job Scheduler:<br>
duplicate value in a UNIQUE INDEX column<br>
<br>
Example Entry in vg224 import file:<br>
</font>
<pre>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,,,,,,
</pre>
Thoughts appreciated!<br>
<br>
Nick Griffin<br>
</div>
</div>
<div style="margin: 0px;">_______________________________________________</div>
<div style="margin: 0px;">cisco-voip mailing list</div>
<div style="margin: 0px;"><a moz-do-not-send="true"
href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></div>
<div style="margin: 0px;"><a moz-do-not-send="true"
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</body>
</html>