[cisco-voip] CUCM 6.1.2 and VG224 in Bulk

[Wes Sisk]

clarification:

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.

example from my system:
admin:run sql select name from device where name like '%44444%'
name
===============
AN4444444444FFF
AN4444444444400

this is a dummy vg224 gw i added.
the FFF device is the virtual placeholder for the gateway, 400 is port 0 
of that gateway.

admin:run sql select * from mgcp
pkid                                 domainname      description     
scratch tkproduct fkcallmanagergroup
    
xml                                                                               
versionstamp
              specialloadinformation tkdeviceprotocol tkclass 
resettoggle tkreset
==================================== =============== =============== 
======= ========= =================================
=== 
================================================================================= 
==================================
============= ====================== ================ ======= 
=========== =======
748a7c5c-8c16-7ac0-083c-46fb0db10195 SKIGW4444444444 
SKIGW4444444444         30038     d13c4201-7802-11d3-bdf0-00108302e
ad1 <CiscoFaxMode>Fax 
Relay</CiscoFaxMode><ModemPassthrough>Enable</ModemPassthrough> 
1216138078-bd28e4d8-3c29-4f5d-b4e0
-0166f194083e NULL                   0                2       f           2


Regards,
Wes

Wes Sisk wrote:
> running this on the publisher, correct?
>
> ohh, also have an issue of duplicate MGCP name.
>
> /wes
>
> Nick Griffin wrote:
>> 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 
>> <mailto: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 <mailto: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 <mailto:cisco-voip at puck.nether.net>
>>>         https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>>     ------------------------------------------------------------------------
>>>     _______________________________________________ cisco-voip
>>>     mailing list cisco-voip at puck.nether.net
>>>     <mailto:cisco-voip at puck.nether.net>
>>>     https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080715/36215f69/attachment.html>