VG224 SCCP Bulk

[mightyking]

Hi Guys,

I have an issue insertitng VG224 (SCCP) using Bulk Tool. Only the first 10 DNs get insterted and error message for the remaining 14 ports. Has enybody faced this issue. Is there any workaround solution? I know I can switch to MGCP but rather to stick with SCCP as all our other VG224 (world wide) are SCCP. Here's the error message:

"The specified name has invalid characters or is not formatted correctly for this device type"

Thanks,

MK

[Rob Huffman]

Hi MK,

Can you please provide the CUCM version.

Cheers!

Rob

[mightyking]

Hi Rob,

It's CUCM 7.1.3.

Thanks,

MK

[Rob Huffman]

Hi MK,

I have a feeling that this is a bug, but sadly the Bug Toolkit is

out of service right now so I can't verify. I'll check in the AM if

you would like

Cheers!

Rob

[mightyking]

Yes please do let me know if there's a work around other than an upgrade or ES patch.

Thanks,

MK

[Rob Huffman · Accepted solution]

BAT Inserts Only First 10 Ports Of VG224

Symptom: While inserting VG224 SCCP, we get the following message after the 10th port : 491 The specified name has invalid characters or is not formatted correctly for this device type.Conditions: CUCM 7.1.3 Issue not faced in CUCM 7.1.2 and belowWorkaround: Insert VG224 as MGCP instead of SCCPFurther Problem Description: 01. The first 10 ports insert fine 02. Issue from 11th port onwards 03. GW inserts fine when MGCP selected instead of SCCP 04. GW inserts fine on CUCM 7.1.2 05. Issue 100% recreatable in lab on a 7.1.3 boxThis is what I see in the BPS logs : 2009-11-06 18:10:10,552 DEBUG [Thread-11] common.LogWrapper - GatewayDBManager::ExecuteInsert|Error code : 491 java.sql.SQLException: 491 at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3171) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2328) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2244) at com.informix.jdbc.IfxSqli.c(IfxSqli.java:1244) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2170) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2107) at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:378) at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1299) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1269) at com.informix.jdbc.IfxStatement.c(IfxStatement.java:989) at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:875) at com.cisco.ccm.bps.gateway.InsertGateway.ExecuteInsertList(Unknown Source) at com.cisco.ccm.bps.gateway.InsertGateway.fnExecuteSql(Unknown Source) at com.cisco.ccm.bps.gateway.InsertGateway.InsertRecords(Unknown Source) at com.cisco.ccm.bps.gateway.InsertGateway.insert(Unknown Source) at com.cisco.ccm.bps.service.TransactionController.selectTransaction(Unknown Source) at com.cisco.ccm.bps.service.ScheduledJobHandler.run(Unknown Source) Caused by: java.sql.SQLException at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:395) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3489) ... 16 more 2009-11-06 18:10:10,564 DEBUG [Thread-11] common.LogWrapper - GatewayDBManager::ExecuteInsert|Exception : java.sql.SQLException: 491 2009-11-06 18:10:10,565 DEBUG [Thread-11] common.LogWrapper - DBManager::getDBErrorMessage|Query : SELECT name FROM typedberrors WHERE enum ='491'.

Status FixedSeverity 2 - severe Last Modified In Last YearProduct Cisco Unified Communications Manager (CallManager)Technology 1st Found-In 7.1(3) Fixed-In 7.1(4.98000.56) 8.0(0.98000.92) 7.1(3.21900.4) 7.1(3.21008.1) 8.0(1.10000.40) 7.1(5.10000.12)

Cheers!

Rob

[mightyking]

Thanks Rob,

MK