03-14-2014 03:35 AM
Hello guys. My name is Yersultan and I am from Kazakhstan.
I wanted to create an application, which to register the IP phone in the Call Manager. For this, I use AXl programming.
The problem is that the Call Manager 8.6.1.20000-1 everything works
fine. A version 8.6.2.20000-2, I can’t create Device-Phone using axl.
I generated AXLAPIService.cs from AXLAPI.wsdl and AXLSoap.xsd(version 8.5).
Here is my code:
public static string AddPhone(AXLAPIService axlApiService, string FIO, string MACaddress, string PhoneNumber, string product)
{
string errMsg = "";
try
{
AddPhoneReq addPhoneReq = new AddPhoneReq();
addPhoneReq.phone = new XPhone();
addPhoneReq.phone.name = "SEP170000100002";
addPhoneReq.phone.product = "Cisco 3905";
addPhoneReq.phone.@class = "Phone";
addPhoneReq.phone.protocol = "SIP";
addPhoneReq.phone.protocolSide = "User";
XFkType xfktype = new XFkType();
xfktype.Value = "Default";
addPhoneReq.phone.devicePoolName = xfktype;
xfktype = new XFkType();
xfktype.Value = "Standard Common Phone Profile";
addPhoneReq.phone.commonPhoneConfigName = xfktype;
xfktype = new XFkType();
xfktype.Value = "Hub_None";
addPhoneReq.phone.locationName = xfktype;
addPhoneReq.phone.useTrustedRelayPoint = "Default";
addPhoneReq.phone.lines = new XPhoneLines();
addPhoneReq.phone.lines.Items = new XPhoneLine[1];
XPhoneLine line = new XPhoneLine();
line.index = "5";
line.display = "Line1";
//existing directory number
line.dirn = new XDirn();
line.dirn.pattern = "1002";
xfktype = new XFkType();
xfktype.Value = "pt_HQ_Reqular2";
line.dirn.routePartitionName = xfktype;
addPhoneReq.phone.lines.Items.SetValue(line, 0);
StandardResponse res2 = axlApiService.addPhone(addPhoneReq); //
}
catch (Exception err)
{
return err.Message;
}
return errMsg;
}
What am I doing wrong? In advance, thanks!
03-14-2014 10:12 AM
Hi Yersultan,
Can you post the full stack trace with both AXL request and response so we can determine what the issue is? Thanks in advance.
Regards,
David
03-17-2014 03:07 AM
Thank you, David. I was able to add other objects to Call Manager with axl. For example, Directory number, End user etc. I can't add only the Device->Phone. This is a stack trace:
в System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
в System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
в AXLAPIService.addPhone(AddPhoneReq addPhone1)
в Service.AddPhone(AXLAPIService axlApiService, String FIO, String MACaddress, String PhoneNumber, String product) в c:\inetpub\wwwroot\WS_CUCMTest\App_Code\Service.cs:строка 142
But error message is null;
03-17-2014 11:49 AM
Hi Yersultan,
I meant the actual content of the AXL request/response. You can capture a wireshare pcap from your PC where your app is running and send to us so we can see exactly what's going on under the hood. Thanks.
David
03-17-2014 12:17 PM
Alternatively, you can also get us the detailed AXL trace logs from CUCM using RTMT tool.
For instructions on how to setup and obtain the AXL trace logs, please check out this page -> AXL trace log
Regards,
David
03-17-2014 02:51 PM
Looks like the uuid for line.dirn is needed.
I tested locally and it seem like an existing numplan will be needed to successfully add a phone.
Here is my actually AXL API request
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">
<soapenv:Header/>
<soapenv:Body>
<ns:addPhone sequence="?">
<phone ctiid="?">
<name>SEP170000100002</name>
<!--Optional:-->
<product>Cisco 3905</product>
<class>Phone</class>
<protocol>SIP</protocol>
<protocolSide>User</protocolSide>
<devicePoolName>Default</devicePoolName>
<commonPhoneConfigName>Standard Common Phone Profile</commonPhoneConfigName>
<locationName>Hub_None</locationName>
<useTrustedRelayPoint>Default</useTrustedRelayPoint>
<!--Optional:-->
<lines>
<line>
<index>5</index>
<label>Line1</label>
<dirn uuid="f1703640-2715-1d51-e68b-2811f1a50486">
<pattern>1002</pattern>
<routePartitionName>Generated_Everyone</routePartitionName>
</dirn>
</line>
</lines>
</phone>
</ns:addPhone>
</soapenv:Body>
</soapenv:Envelope>
03-17-2014 09:28 PM
Thanks, Ting Hao Chen! But I already tried this variant before, and it dosn't work.
03-17-2014 09:26 PM
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><addPhone xmlns="http://www.cisco.com/AXL/API/8.5"><phone xmlns=""><name>SEP170000100002</name><product>Cisco 3905</product><class>Phone</class><protocol>SIP</protocol><protocolSide>User</protocolSide><callingSearchSpaceName xsi:nil="true" /><devicePoolName>Default</devicePoolName><commonDeviceConfigName xsi:nil="true" /><commonPhoneConfigName>Standard Common Phone Profile</commonPhoneConfigName><locationName>Hub_None</locationName><mediaResourceListName xsi:nil="true" /><networkHoldMohAudioSourceId xsi:nil="true" /><userHoldMohAudioSourceId xsi:nil="true" /><automatedAlternateRoutingCssName xsi:nil="true" /><aarNeighborhoodName xsi:nil="true" /><loadInformation xsi:nil="true" /><versionStamp xsi:nil="true" /><mlppDomainId xsi:nil="true" /><useTrustedRelayPoint>Default</useTrustedRelayPoint><securityProfileName xsi:nil="true" /><sipProfileName xsi:nil="true" /><cgpnTransformationCssName xsi:nil="true" /><geoLocationName xsi:nil="true" /><geoLocationFilterName xsi:nil="true" /><lines><line><index>5</index><display>Line1</display><dirn><pattern>1002</pattern><routePartitionName>pt_HQ_Reqular2</routePartitionName></dirn><ringSettingIdlePickupAlert xsi:nil="true" /><ringSettingActivePickupAlert xsi:nil="true" /><e164Mask xsi:nil="true" /><recordingProfileName xsi:nil="true" /><monitoringCssName xsi:nil="true" /><speedDial xsi:nil="true" /></line></lines><phoneTemplateName xsi:nil="true" /><primaryPhoneName xsi:nil="true" /><userlocale xsi:nil="true" /><networkLocale xsi:nil="true" /><idleTimeout xsi:nil="true" /><softkeyTemplateName xsi:nil="true" /><defaultProfileName xsi:nil="true" /><builtInBridgeStatus>Default</builtInBridgeStatus><ownerUserName xsi:nil="true" /><packetCaptureMode>None</packetCaptureMode><subscribeCallingSearchSpaceName xsi:nil="true" /><rerouteCallingSearchSpaceName xsi:nil="true" /><certificateOperation>No Pending Operation</certificateOperation><deviceMobilityMode>Default</deviceMobilityMode><dndRingSetting xsi:nil="true" /><mobilityUserIdName xsi:nil="true" /><mobileSmartClientProfileName xsi:nil="true" /><dialRulesName xsi:nil="true" /><featureControlPolicy xsi:nil="true" /></phone></addPhone></soap:Body></soap:Envelope>
2014-03-18 10:20:10,527 DEBUG [http-8443-9] servletRouters.AXLFilter - DBLCNQueue Count: 0
2014-03-18 10:20:10,527 DEBUG [http-8443-9] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
2014-03-18 10:20:10,528 INFO [http-8443-9] servletRouters.AXLAlpha - SOAPAction : "CUCM:DB ver=8.5 addPhone"
2014-03-18 10:20:10,528 INFO [http-8443-9] servletRouters.AXLAlpha - Going to axis--->
2014-03-18 10:20:10,533 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,534 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,534 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,535 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,536 DEBUG [http-8443-9] axlapiservice.AddPhoneHandler - select tkModel from TypeProduct where typeproduct.enum='479'
2014-03-18 10:20:10,537 DEBUG [http-8443-9] axlapiservice.Handler - fkCallingSearchSpace IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,538 DEBUG [http-8443-9] axlapiservice.Handler - getPkid Query is :select pkid from DevicePool where my_lower(name ) =my_lower('Default' )
2014-03-18 10:20:10,540 DEBUG [http-8443-9] axlapiservice.Handler - fkFeatureControlPolicy IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,541 DEBUG [http-8443-9] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='479' and tkdeviceprotocol in ('11',99)
2014-03-18 10:20:10,543 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 104
2014-03-18 10:20:10,544 DEBUG [http-8443-9] axlapiservice.Handler - fkCommonDeviceConfig IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,544 DEBUG [http-8443-9] axlapiservice.Handler - getPkid Query is :select pkid from CommonPhoneConfig where my_lower(name ) =my_lower('Standard Common Phone Profile' )
2014-03-18 10:20:10,547 DEBUG [http-8443-9] axlapiservice.Handler - getPkid Query is :select pkid from Location where my_lower(name ) =my_lower('Hub_None' )
2014-03-18 10:20:10,549 DEBUG [http-8443-9] axlapiservice.Handler - fkMediaResourceList IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,549 DEBUG [http-8443-9] axlapiservice.Handler - fkCallingSearchSpace_AAR IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,550 DEBUG [http-8443-9] axlapiservice.Handler - fkAARNeighborhood IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,551 DEBUG [http-8443-9] axlapiservice.Handler - fkFeatureControlPolicy IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,551 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 34
2014-03-18 10:20:10,551 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 35
2014-03-18 10:20:10,552 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,553 DEBUG [http-8443-9] axlapiservice.AddPhoneHandler - select pkid from securityprofile where tkmodel = '592' and tkdeviceprotocol = '11' and securityprofile.isStandard = 't' and securityprofile.tkDeviceSecurityMode = '1'
2014-03-18 10:20:10,556 DEBUG [http-8443-9] axlapiservice.AddPhoneHandler - Select pkid from SipProfile where name = 'Standard SIP Profile'
2014-03-18 10:20:10,558 DEBUG [http-8443-9] axlapiservice.Handler - fkPhoneTemplate IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,561 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 18
2014-03-18 10:20:10,561 DEBUG [http-8443-9] axlapiservice.Handler - ikDevice_defaultProfile IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,561 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 79
2014-03-18 10:20:10,562 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 78
2014-03-18 10:20:10,562 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 53
2014-03-18 10:20:10,563 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,564 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,570 DEBUG [http-8443-9] axlapiservice.Handler - fkCallingSearchspace_restrict IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,571 DEBUG [http-8443-9] axlapiservice.Handler - fkCallingSearchspace_reroute IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,572 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,573 DEBUG [http-8443-9] axlapiservice.Handler - Inside addTkdataAXIS utils part
2014-03-18 10:20:10,574 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 76
2014-03-18 10:20:10,574 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 76
2014-03-18 10:20:10,574 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 72
2014-03-18 10:20:10,575 DEBUG [http-8443-9] axlapiservice.Handler - Product 479 does not support feature 63
2014-03-18 10:20:10,575 DEBUG [http-8443-9] axlapiservice.Handler - fkDialRules IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,576 DEBUG [http-8443-9] axlapiservice.Handler - fkcallingsearchspace_cgpntransform IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,576 DEBUG [http-8443-9] axlapiservice.Handler - insert into Device ( tkDeviceProtocol,tkPacketCaptureMode,fkCallingSearchspace_restrict,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,isprotected,tkPreemption,fkDialRules,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,fkSipProfile,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( '11','0',null,null,'0','2','1','1b1b9eb6-7803-11d3-bdf0-00108302ead1','8dbba1b3-61e6-469a-9abb-87d4855cbb00',null,null,'2','f','0',null,null,null,null,null,null,'fcbc7581-4d8d-48f3-917e-00b09fb39213','1','29c5c1c4-8871-4d1e-8394-0b9181e8c54d','SEP170000100002','1','ac243d17-98b4-4118-8feb-5ff2e1b781ac','9a5b57b1-dcde-4141-3f37-ca9ba4a461c1',null,null,'a9219adb-e95a-44dd-bf6f-8ef4e125d1f6','2','479' )
2014-03-18 10:20:10,774 DEBUG [http-8443-9] axlapiservice.Handler - fkcallingsearchspace_cgpntransform IS Being assigned a null value in addfkdataaxis
2014-03-18 10:20:10,774 ERROR [http-8443-9] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@a9aab1
java.lang.NullPointerException
at com.cisco.www.axlapiservice.AddPhoneHandler.doAdd(AddPhoneHandler.java:931)
at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.addPhone(AXLAPIServiceSkeleton.java:13345)
at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:7446)
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor822.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:65)
at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:80)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:294)
at com.cisco.www.servletRouters.AXLAlpha.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor822.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at com.cisco.www.servletRouters.AXLFilter.doFilter(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1011.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:243)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:394)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
2014-03-18 10:20:10,777 DEBUG [http-8443-9] axlapiservice.AXLCallFlow - In AXL CAll Flow
2014-03-18 10:20:10,777 DEBUG [http-8443-9] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringnull
2014-03-18 10:20:10,778 DEBUG [http-8443-9] axlapiservice.AXLCallFlow - Setting soap fault
2014-03-18 10:20:10,778 DEBUG [http-8443-9] axlapiservice.AXLCallFlow - Setting soap fault2
2014-03-18 10:20:10,779 INFO [http-8443-9] servletRouters.AXLAlpha - Request processed by AXIS
2014-03-18 10:20:10,779 INFO [http-8443-9] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server</faultcode><faultstring></faultstring><detail><axlError><axlcode>-1</axlcode><axlmessage></axlmessage><request>addPhone</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
2014-03-18 10:20:10,780 INFO [http-8443-9] servletRouters.AXLFilter - Request 1393402092773 was process in 262ms
2014-03-18 10:20:13,436 DEBUG [Thread-192] servletRouters.AXLThrottler - Throttle URL[0] : jdbc:informix-sqli://UCM-DINT:1500/ccm8_6_2_20000_2:informixserver=ucm_dint_ccm8_6_2_20000_2;user=informix;IFX_LOCK_MODE_WAIT=10;IFX_SOC_TIMEOUT=300000;
03-20-2014 11:23 AM
No specific message either...
Could you please run the "executeSQLUpdate" API with that "insert into device" sql statement shows in the logs to see what it returns? That seems to be the final SQL statment that gets passed to AXL service.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:axl="http://www.cisco.com/AXL/API/8.5">
<soapenv:Header/>
<soapenv:Body>
<axl:executeSQLUpdate sequence="?">
<sql>insert into Device ( tkDeviceProtocol,tkPacketCaptureMode,fkCallingSearchspace_restrict,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,isprotected,tkPreemption,fkDialRules,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,fkSipProfile,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( '11','0',null,null,'0','2','1','1b1b9eb6-7803-11d3-bdf0-00108302ead1','8dbba1b3-61e6-469a-9abb-87d4855cbb00',null,null,'2','f','0',null,null,null,null,null,null,'fcbc7581-4d8d-48f3-917e-00b09fb39213','1','29c5c1c4-8871-4d1e-8394-0b9181e8c54d','SEP170000100002','1','ac243d17-98b4-4118-8feb-5ff2e1b781ac','9a5b57b1-dcde-4141-3f37-ca9ba4a461c1',null,null,'a9219adb-e95a-44dd-bf6f-8ef4e125d1f6','2','479' ) </sql>
</axl:executeSQLUpdate>
<soapenv:Body>
</soapenv:Envelope>
03-25-2014 08:53 PM
Thanks Ting-Hao Chen! Yes i tried your request. And it is run successfully.
But I need to select a product, device pool name and so on. With this way I can not select them.
03-25-2014 11:58 PM
executeSQLUpdate log
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><executeSQLUpdate xmlns="http://www.cisco.com/AXL/API/8.5"><sql xmlns=""> insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,fkSipProfile,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( null,'11','0',null,'0','2','1','1b1b9eb6-7803-11d3-bdf0-00108302ead1','8dbba1b3-61e6-469a-9abb-87d4855cbb00',null,null,'2','f','0',null,'Adding from WS_CUCMAdministration',null,null,null,null,null,'fcbc7581-4d8d-48f3-917e-00b09fb39213','1','29c5c1c4-8871-4d1e-8394-0b9181e8c54d','SEPF41FC266E0E9','1','ac243d17-98b4-4118-8feb-5ff2e1b781ac','403cddd6-1376-d47e-9f53-916187b5174d',null,null,'a9219adb-e95a-44dd-bf6f-8ef4e125d1f6','2','479' )</sql></executeSQLUpdate></soap:Body></soap:Envelope>
2014-03-26 12:22:53,978 DEBUG [http-8443-2] servletRouters.AXLFilter - DBLCNQueue Count: 0
2014-03-26 12:22:53,979 DEBUG [http-8443-2] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
2014-03-26 12:22:53,979 INFO [http-8443-2] servletRouters.AXLAlpha - SOAPAction : "CUCM:DB ver=8.5 executeSQLUpdate"
2014-03-26 12:22:53,979 INFO [http-8443-2] servletRouters.AXLAlpha - Going to axis--->
2014-03-26 12:22:54,001 DEBUG [http-8443-2] axlapiservice.AXLAPIServiceSkeleton - In ExecuteSQLQueryResponseDocument
2014-03-26 12:22:54,001 DEBUG [http-8443-2] axlapiservice.ExecuteSqlHandler - insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,fkSipProfile,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( null,'11','0',null,'0','2','1','1b1b9eb6-7803-11d3-bdf0-00108302ead1','8dbba1b3-61e6-469a-9abb-87d4855cbb00',null,null,'2','f','0',null,'Adding from WS_CUCMAdministration',null,null,null,null,null,'fcbc7581-4d8d-48f3-917e-00b09fb39213','1','29c5c1c4-8871-4d1e-8394-0b9181e8c54d','SEPF41FC266E0E9','1','ac243d17-98b4-4118-8feb-5ff2e1b781ac','403cddd6-1376-d47e-9f53-916187b5174d',null,null,'a9219adb-e95a-44dd-bf6f-8ef4e125d1f6','2','479' )
2014-03-26 12:22:54,098 DEBUG [http-8443-2] axlapiservice.AXLAPIServiceSkeleton - Returning request
2014-03-26 12:22:54,100 INFO [http-8443-2] servletRouters.AXLAlpha - Request processed by AXIS
2014-03-26 12:22:54,100 INFO [http-8443-2] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns:executeSQLUpdateResponse xmlns:ns="http://www.cisco.com/AXL/API/8.5"><return><rowsUpdated>1</rowsUpdated></return></ns:executeSQLUpdateResponse></soapenv:Body></soapenv:Envelope>
2014-03-26 12:22:54,100 INFO [http-8443-2] servletRouters.AXLFilter - Request 1393402092808 was process in 126ms
03-26-2014 08:07 AM
hmm...
Then, there must be something else that caused the problem.
Could you please share with me your .NET project so that I can try to reproduce here?
Thanks,
Howard
03-26-2014 08:53 PM
04-02-2014 09:10 AM
Didn't have time to test this out until now. I had the exact same problem as yours...
I checked the AXL log and it seems to thrown lots of throttling warning. Not sure if this has something to do with .NET implementation...
Will test more
Howard
08-27-2014 03:34 AM
Is there a solution for this problem? I am getting the same issue. I am on CUCM version 10.5 and .NET 4.0. In the RTMT AXL logs, I see the java.lang.NullPointerException.
I copied the Update statement from the logs and executed using the ExecuteSQLUpdate method. It was successfull and the phone got created.
Can you please help.
My task is quite complicated, I need to add a phone, then associated lines to the phone, then speed dials etc. Doing this via the SQL update statements is not elegant.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide