<!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">
clarification:<br>
<br>
for gateways with many ports (vg224, 248) CM aggregates those under a
single virtual MGCP gateway so you can view the 'gateway' and all
associated ports.<br>
<br>
example from my system:<br>
admin:run sql select name from device where name like '%44444%'<br>
name<br>
===============<br>
AN4444444444FFF<br>
AN4444444444400<br>
<br>
this is a dummy vg224 gw i added.<br>
the FFF device is the virtual placeholder for the gateway, 400 is port
0 of that gateway.<br>
<br>
admin:run sql select * from mgcp<br>
pkid domainname description
scratch tkproduct fkcallmanagergroup<br>
xml
versionstamp<br>
specialloadinformation tkdeviceprotocol tkclass
resettoggle tkreset<br>
==================================== =============== ===============
======= ========= =================================<br>
===
=================================================================================
==================================<br>
============= ====================== ================ =======
=========== =======<br>
748a7c5c-8c16-7ac0-083c-46fb0db10195 SKIGW4444444444
SKIGW4444444444 30038 d13c4201-7802-11d3-bdf0-00108302e<br>
ad1 <CiscoFaxMode>Fax
Relay</CiscoFaxMode><ModemPassthrough>Enable</ModemPassthrough>
1216138078-bd28e4d8-3c29-4f5d-b4e0<br>
-0166f194083e NULL 0 2
f 2<br>
<br>
<br>
Regards,<br>
Wes<br>
<br>
Wes Sisk wrote:
<blockquote cite="mid:487CC904.7010109@cisco.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
running this on the publisher, correct?<br>
<br>
ohh, also have an issue of duplicate MGCP name.<br>
<br>
/wes<br>
<br>
Nick Griffin wrote:
<blockquote
cite="mid:a2b352c40807150847t5b7cec35xe900e965f2b8ff9@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Same Results:</div>
<div> </div>
<div>admin:run sql select name from device where name like
'%1E4A5483EF'<br>
name<br>
====<br>
admin:run sql select name from device where name like 'SKIGW1E4A5483EF'<br>
name<br>
====<br>
</div>
<div>Attempting to import still show's the duplicate index error. <br>
<br>
</div>
<div class="gmail_quote">On Tue, Jul 15, 2008 at 10:37 AM, Wes Sisk
<<a moz-do-not-send="true" href="mailto:wsisk@cisco.com">wsisk@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 text="#000000" bgcolor="#ffffff">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 type="cite">
<div>
<div class="Wj3C7c">
<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"
target="_blank">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>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')<br>
from the CLI, assuming the one below is a duplicate.</span>
<div><font face="-webkit-monospace"><span
style="white-space: pre;"><br>
<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>
<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>
</div>
</div>
<pre><hr size="4" width="90%"><div class="Ih2E3d">
_______________________________________________
cisco-voip mailing list
<a moz-do-not-send="true" href="mailto:cisco-voip@puck.nether.net"
target="_blank">cisco-voip@puck.nether.net</a>
<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></pre>
</blockquote>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</blockquote>
</body>
</html>