topic Re: Axl error code -1, message is null in Management

Axl error code -1, message is null

erersultan — Fri, 14 Mar 2014 10:35:51 GMT

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!

Re: Axl error code -1, message is null

davidn# — Fri, 14 Mar 2014 17:12:24 GMT

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

Re: Axl error code -1, message is null

erersultan — Mon, 17 Mar 2014 10:07:30 GMT

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;

Re: Axl error code -1, message is null

davidn# — Mon, 17 Mar 2014 18:49:18 GMT

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

Re: Axl error code -1, message is null

davidn# — Mon, 17 Mar 2014 19:17:42 GMT

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

Re: Axl error code -1, message is null

tinghche — Mon, 17 Mar 2014 21:51:21 GMT

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="?">

<product>Cisco 3905</product>

<class>Phone</class>

<devicePoolName>Default</devicePoolName>

<commonPhoneConfigName>Standard Common Phone Profile</commonPhoneConfigName>

<useTrustedRelayPoint>Default</useTrustedRelayPoint>

<lines>

<line>

<routePartitionName>Generated_Everyone</routePartitionName>

</dirn>

</line>

</lines>

</phone>

</ns:addPhone>

</soapenv:Body>

</soapenv:Envelope>

Re: Axl error code -1, message is null

erersultan — Tue, 18 Mar 2014 04:26:09 GMT

<?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;

Re: Axl error code -1, message is null

erersultan — Tue, 18 Mar 2014 04:28:55 GMT

Thanks, Ting Hao Chen! But I already tried this variant before, and it dosn't work.

Re: Axl error code -1, message is null

tinghche — Thu, 20 Mar 2014 18:23:20 GMT

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>

Re: Axl error code -1, message is null

erersultan — Wed, 26 Mar 2014 03:53:42 GMT

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.

Re: Axl error code -1, message is null

erersultan — Wed, 26 Mar 2014 06:58:49 GMT

executeSQLUpdate log

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

Re: Axl error code -1, message is null

tinghche — Wed, 26 Mar 2014 15:07:39 GMT

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

Re: Re: Axl error code -1, message is null

erersultan — Thu, 27 Mar 2014 03:53:50 GMT

This is my .Net Project

Re: Re: Axl error code -1, message is null

tinghche — Wed, 02 Apr 2014 16:10:27 GMT

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

Re: Axl error code -1, message is null

david norman — Sat, 07 Jun 2014 07:16:34 GMT

I had the same issue when I was trying to add a line into CUCM 8.6.1. I also noticed the java.lang.NullPointerException in the RTMT AXL logs.

To fix this issue I went into the AXLAPIService.cs and changed the CUCM:DB from version 8.0 to version 7.0. I also changed the namespace to http://www.cisco.com/AXL/API/7.0

I have read that the 8.0 schema is a lot more particular on the namespaces. I couldn't find out how to fix the problem, just to bypass it I think.

Re: Axl error code -1, message is null

kishor171 — Wed, 27 Aug 2014 10:34:51 GMT

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.