AddPhone: A character to numeric conversion process failed

Version 1

    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 01-11-2013 03:19:05 AM
    Hi Dennis,
    Thanks for your answer.
    No I have not tried to do so. I will do it shortly and post the result. I was hopping that it was possible to identify the faulty variable type from the request.
    KR
    Salim
    This document was generated from CDN thread

    Created by: Salim Guerid on 01-11-2013 12:30:59 AM
    Hi all,
    I am trying to add a new CSF device using the following code:

     1AddPhoneReq req = new AddPhoneReq();
     2req.phone = new XPhone();
     3req.phone.name = "CSF4" + userID;
     4req.phone.description = site + " CSF " + userID + "-" + extension;
     5req.phone.devicePoolName = new XFkType() { Value = siteDevicePool };
     6req.phone.commonDeviceConfigName = new XFkType() { Value = site + "-Device Config" };
     7req.phone.phoneTemplateName = new XFkType() { Value = PhoneButtonTemplate };
     8req.phone.commonPhoneConfigName = new XFkType() { Value = site + "-Common Phone Profile" };
     9req.phone.callingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    10req.phone.locationName = new XFkType() { Value = site };
    11req.phone.sipProfileName = new XFkType() { Value = stdCSFSIPProfile };
    12req.phone.securityProfileName = new XFkType() { Value = DeviceSecurityProfile };
    13req.phone.subscribeCallingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    14req.phone.ownerUserName = new XFkType() { Value = userID };
    15
    16// Values added to try to address the issue
    17req.phone.packetCaptureDuration = "0";
    18req.phone.networkHoldMohAudioSourceId = "1";
    19req.phone.userlocale = "";
    20req.phone.networkLocale = "";
    21req.phone.userHoldMohAudioSourceId = "1";
    22req.phone.idleTimeout = "5";
    23req.phone.versionStamp = "1";
    24req.phone.mlppDomainId = "1";
    25req.phone.dndRingSetting = "5";
    26
    27StandardResponse res = AXLAPIServiceSingleton.getInstance().addPhone(req);

    The request:

     1
     2<?xml version="1.0" encoding="UTF-8"?>
     3<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
     4   <soap:Body>
     5      <addPhone xmlns="http://www.cisco.com/AXL/API/8.5">
     6         <phone xmlns="">
     7            <name>CSF4SIG</name>
     8            <description>CH3 CSF AAA-10241</description>
     9            <protocolSide>User</protocolSide>
    10            <callingSearchSpaceName>Internal-CH3</callingSearchSpaceName>
    11            <devicePoolName>CH3</devicePoolName>
    12            <commonDeviceConfigName>CH3-Device Config</commonDeviceConfigName>
    13            <commonPhoneConfigName>CH3-Common Phone Profile</commonPhoneConfigName>
    14            <locationName>CH3</locationName>
    15            <mediaResourceListName xsi:nil="true" />
    16            <networkHoldMohAudioSourceId>1</networkHoldMohAudioSourceId>
    17            <userHoldMohAudioSourceId>1</userHoldMohAudioSourceId>
    18            <automatedAlternateRoutingCssName xsi:nil="true" />
    19            <aarNeighborhoodName xsi:nil="true" />
    20            <loadInformation xsi:nil="true" />
    21            <versionStamp>1</versionStamp>
    22            <mlppDomainId>1</mlppDomainId>
    23            <useTrustedRelayPoint>Default</useTrustedRelayPoint>
    24            <securityProfileName>Cisco Unified Client Services Framework - Standard SIP Non-Secure</securityProfileName>
    25            <sipProfileName>JABBER SIP Profile</sipProfileName>
    26            <cgpnTransformationCssName xsi:nil="true" />
    27            <geoLocationName xsi:nil="true" />
    28            <geoLocationFilterName xsi:nil="true" />
    29            <phoneTemplateName>Standard Client Services Framework</phoneTemplateName>
    30            <primaryPhoneName xsi:nil="true" />
    31            <userlocale />
    32            <networkLocale />
    33            <idleTimeout>5</idleTimeout>
    34            <softkeyTemplateName xsi:nil="true" />
    35            <defaultProfileName xsi:nil="true" />
    36            <builtInBridgeStatus>Default</builtInBridgeStatus>
    37            <ownerUserName>SIG</ownerUserName>
    38            <packetCaptureMode>None</packetCaptureMode>
    39            <subscribeCallingSearchSpaceName>Internal-CH3</subscribeCallingSearchSpaceName>
    40            <rerouteCallingSearchSpaceName xsi:nil="true" />
    41            <certificateOperation>No Pending Operation</certificateOperation>
    42            <deviceMobilityMode>Default</deviceMobilityMode>
    43            <dndRingSetting>5</dndRingSetting>
    44            <mobilityUserIdName xsi:nil="true" />
    45            <mobileSmartClientProfileName xsi:nil="true" />
    46            <dialRulesName xsi:nil="true" />
    47            <featureControlPolicy xsi:nil="true" />
    48         </phone>
    49      </addPhone>
    50   </soap:Body>
    51</soap:Envelope>

    The response:

     1<?xml version="1.0" encoding="UTF-8"?>
     2<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
     3   <soapenv:Body>
     4      <soapenv:Fault>
     5         <faultcode>soapenv:Client</faultcode>
     6         <faultstring>A character to numeric conversion process failed</faultstring>
     7         <detail>
     8            <axlError>
     9               <axlcode>-1213</axlcode>
    10               <axlmessage>A character to numeric conversion process failed</axlmessage>
    11               <request>addPhone</request>
    12            </axlError>
    13         </detail>
    14      </soapenv:Fault>
    15   </soapenv:Body>
    16</soapenv:Envelope>

    I understand well that the error is that I am trying to store a value with non numerical character into a numeric DB field as described here (http://www-01.ibm.com/support/docview.wss?uid=swg21432403).
    However I am running out of idea on how to correct.


    Any help would be highly appreciated.

    Subject: RE: New Message from Salim Guerid in AXL Developer - Administration XML Que
    Replied by: Dennis Heim on 01-11-2013 02:11:22 AM
    Have you tried creating it by hand (via CCM Admin gui), and then doing a getPhone xml request and comparing that to what you are sending?

    Dennis Heim | Solution Architect (Collaboration)
    World Wide Technology, Inc. | 314-212-1814

    PS Engineering:  Innovate & Ignite.


    From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
    Sent: Friday, November 01, 2013 1:31 AM
    To: cdicuser@developer.cisco.com
    Subject: New Message from Salim Guerid in AXL Developer - Administration XML Questions: AddPhone: A character to numeric conversion process failed

    Salim Guerid has created a new message in the forum "Administration XML Questions": -------------------------------------------------------------- Hi all,
    I am trying to add a new CSF device using the following code:
    1
    2AddPhoneReq req = new AddPhoneReq();
    3req.phone = new XPhone();
    4req.phone.name = "CSF4" + userID;
    5req.phone.description = site + " CSF " + userID + "-" + extension;
    6req.phone.devicePoolName = new XFkType() { Value = siteDevicePool };
    7req.phone.commonDeviceConfigName = new XFkType() { Value = site + "-Device Config" };
    8req.phone.phoneTemplateName = new XFkType() { Value = PhoneButtonTemplate };
    9req.phone.commonPhoneConfigName = new XFkType() { Value = site + "-Common Phone Profile" };
    10req.phone.callingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    11req.phone.locationName = new XFkType() { Value = site };
    12req.phone.sipProfileName = new XFkType() { Value = stdCSFSIPProfile };
    13req.phone.securityProfileName = new XFkType() { Value = DeviceSecurityProfile };
    14req.phone.subscribeCallingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    15req.phone.ownerUserName = new XFkType() { Value = userID };
    16
    17// Values added to try to address the issue
    18req.phone.packetCaptureDuration = "0";
    19req.phone.networkHoldMohAudioSourceId = "1";
    20req.phone.userlocale = "";
    21req.phone.networkLocale = "";
    22req.phone.userHoldMohAudioSourceId = "1";
    23req.phone.idleTimeout = "5";
    24req.phone.versionStamp = "1";
    25req.phone.mlppDomainId = "1";
    26req.phone.dndRingSetting = "5";
    27
    28StandardResponse res = AXLAPIServiceSingleton.getInstance().addPhone(req);


    The request:
    1
    2<?xml version="1.0" encoding="UTF-8"?>
    3<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    4   <soap:Body>
    5      <addPhone xmlns="http://www.cisco.com/AXL/API/8.5">
    6         <phone xmlns="">
    7            <name>CSF4SIG</name>
    8            <description>CH3 CSF AAA-10241</description>
    9            <protocolSide>User</protocolSide>
    10            <callingSearchSpaceName>Internal-CH3</callingSearchSpaceName>
    11            <devicePoolName>CH3</devicePoolName>
    12            <commonDeviceConfigName>CH3-Device Config</commonDeviceConfigName>
    13            <commonPhoneConfigName>CH3-Common Phone Profile</commonPhoneConfigName>
    14            <locationName>CH3</locationName>
    15            <mediaResourceListName xsi:nil="true" />
    16            <networkHoldMohAudioSourceId>1</networkHoldMohAudioSourceId>
    17            <userHoldMohAudioSourceId>1</userHoldMohAudioSourceId>
    18            <automatedAlternateRoutingCssName xsi:nil="true" />
    19            <aarNeighborhoodName xsi:nil="true" />
    20            <loadInformation xsi:nil="true" />
    21            <versionStamp>1</versionStamp>
    22            <mlppDomainId>1</mlppDomainId>
    23            <useTrustedRelayPoint>Default</useTrustedRelayPoint>
    24            <securityProfileName>Cisco Unified Client Services Framework - Standard SIP Non-Secure</securityProfileName>
    25            <sipProfileName>JABBER SIP Profile</sipProfileName>
    26            <cgpnTransformationCssName xsi:nil="true" />
    27            <geoLocationName xsi:nil="true" />
    28            <geoLocationFilterName xsi:nil="true" />
    29            <phoneTemplateName>Standard Client Services Framework</phoneTemplateName>
    30            <primaryPhoneName xsi:nil="true" />
    31            <userlocale />
    32            <networkLocale />
    33            <idleTimeout>5</idleTimeout>
    34            <softkeyTemplateName xsi:nil="true" />
    35            <defaultProfileName xsi:nil="true" />
    36            <builtInBridgeStatus>Default</builtInBridgeStatus>
    37            <ownerUserName>AAA</ownerUserName>
    38            <packetCaptureMode>None</packetCaptureMode>
    39            <subscribeCallingSearchSpaceName>Internal-CH3</subscribeCallingSearchSpaceName>
    40            <rerouteCallingSearchSpaceName xsi:nil="true" />
    41            <certificateOperation>No Pending Operation</certificateOperation>
    42            <deviceMobilityMode>Default</deviceMobilityMode>
    43            <dndRingSetting>5</dndRingSetting>
    44            <mobilityUserIdName xsi:nil="true" />
    45            <mobileSmartClientProfileName xsi:nil="true" />
    46            <dialRulesName xsi:nil="true" />
    47            <featureControlPolicy xsi:nil="true" />
    48         </phone>
    49      </addPhone>
    50   </soap:Body>
    51</soap:Envelope>



    The response:
    1
    2<?xml version="1.0" encoding="UTF-8"?>
    3<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    4   <soapenv:Body>
    5      <soapenv:Fault>
    6         <faultcode>soapenv:Client</faultcode>
    7         <faultstring>A character to numeric conversion process failed</faultstring>
    8         <detail>
    9            <axlError>
    10               <axlcode>-1213</axlcode>
    11               <axlmessage>A character to numeric conversion process failed</axlmessage>
    12               <request>addPhone</request>
    13            </axlError>
    14         </detail>
    15      </soapenv:Fault>
    16   </soapenv:Body>
    17</soapenv:Envelope>


    I understand well that the error is that I am trying to store a value with non numerical character into a numeric DB field as described here (http://www-01.ibm.com/support/docview.wss?uid=swg21432403).
    However I am running out of idea on how to correct.

    Any help would be highly appreciated.
    --
    To respond to this post, please click the following link: http://developer.cisco.com/web/axl-developer/forums/-/message_boards/view_message/20888328 or simply reply to this email.

    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 03-11-2013 01:30:31 AM
    Hi,
    Here is the getPhone:

      1<?xml version="1.0" encoding="UTF-8"?>
      2<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
      3   <soapenv:Body>
      4      <ns:getPhoneResponse xmlns:ns="http://www.cisco.com/AXL/API/8.5">
      5         <return>
      6            <phone uuid="{518B7F58-3FDF-6AA1-5805-CD7689C35260}">
      7               <name>CSF4SIG</name>
      8               <description>CH3 CSF SIG - 10241</description>
      9               <product>Cisco Unified Client Services Framework</product>
     10               <model>Cisco Unified Client Services Framework</model>
     11               <class>Phone</class>
     12               <protocol>SIP</protocol>
     13               <protocolSide>User</protocolSide>
     14               <callingSearchSpaceName uuid="{EF109E49-4A93-A715-FC2A-7289028A5A17}">Internal-CH3</callingSearchSpaceName>
     15               <devicePoolName uuid="{0F0744C4-D8F1-0956-31C9-7ADEC4AB908B}">CH3</devicePoolName>
     16               <commonDeviceConfigName uuid="{D4867809-E67E-48D5-496D-BE31BCECDAF1}">CH3-Device Config</commonDeviceConfigName>
     17               <commonPhoneConfigName uuid="{76BE71E3-09AF-0198-A376-DF389E8767AB}">RTCP Common Phone Profile</commonPhoneConfigName>
     18               <networkLocation>Use System Default</networkLocation>
     19               <locationName uuid="{6C8460FB-FD64-B611-6A9B-2A327C22EB28}">CH3</locationName>
     20               <mediaResourceListName />
     21               <networkHoldMohAudioSourceId />
     22               <userHoldMohAudioSourceId />
     23               <automatedAlternateRoutingCssName />
     24               <aarNeighborhoodName />
     25               <loadInformation special="false" />
     26               <vendorConfig>
     27                  <videoCapability>1</videoCapability>
     28                  <desktopClient>
     29                     <ciscoSupportField />
     30                  </desktopClient>
     31               </vendorConfig>
     32               <versionStamp>{1383458960-7D0DB871-8FD5-44F8-9D42-3D2A4F9D2FE2}</versionStamp>
     33               <traceFlag>false</traceFlag>
     34               <mlppDomainId />
     35               <mlppIndicationStatus>Off</mlppIndicationStatus>
     36               <preemption>Disabled</preemption>
     37               <useTrustedRelayPoint>Default</useTrustedRelayPoint>
     38               <retryVideoCallAsAudio>true</retryVideoCallAsAudio>
     39               <securityProfileName uuid="{C6085E14-A32C-4C5E-A3D1-8DAF60D81594}">Cisco Unified Client Services Framework - Standard SIP Non-Secure</securityProfileName>
     40               <sipProfileName uuid="{95C28F72-AFA3-5F1A-BA09-6204C9DD5121}">Jabber SIP Profile</sipProfileName>
     41               <cgpnTransformationCssName />
     42               <useDevicePoolCgpnTransformCss>true</useDevicePoolCgpnTransformCss>
     43               <geoLocationName />
     44               <geoLocationFilterName />
     45               <sendGeoLocation>false</sendGeoLocation>
     46               <lines />
     47               <numberOfButtons>1</numberOfButtons>
     48               <phoneTemplateName uuid="{8E1A10FA-A52C-4435-A4EC-540D266C8C37}">Standard Client Services Framework</phoneTemplateName>
     49               <speeddials />
     50               <busyLampFields />
     51               <primaryPhoneName />
     52               <ringSettingIdleBlfAudibleAlert>Default</ringSettingIdleBlfAudibleAlert>
     53               <ringSettingBusyBlfAudibleAlert>Default</ringSettingBusyBlfAudibleAlert>
     54               <blfDirectedCallParks />
     55               <addOnModules />
     56               <userlocale />
     57               <networkLocale />
     58               <idleTimeout />
     59               <authenticationUrl />
     60               <directoryUrl />
     61               <idleUrl />
     62               <informationUrl />
     63               <messagesUrl />
     64               <proxyServerUrl />
     65               <servicesUrl />
     66               <services />
     67               <softkeyTemplateName />
     68               <defaultProfileName />
     69               <enableExtensionMobility>false</enableExtensionMobility>
     70               <currentProfileName />
     71               <loginTime />
     72               <loginDuration />
     73               <currentConfig>
     74                  <userHoldMohAudioSourceId />
     75                  <phoneTemplateName uuid="{8E1A10FA-A52C-4435-A4EC-540D266C8C37}">Standard Client Services Framework</phoneTemplateName>
     76                  <mlppDomainId />
     77                  <mlppIndicationStatus>Off</mlppIndicationStatus>
     78                  <preemption>Disabled</preemption>
     79                  <softkeyTemplateName />
     80                  <ignorePresentationIndicators>false</ignorePresentationIndicators>
     81                  <singleButtonBarge>Off</singleButtonBarge>
     82                  <joinAcrossLines>Off</joinAcrossLines>
     83                  <callInfoPrivacyStatus>Default</callInfoPrivacyStatus>
     84                  <dndStatus />
     85                  <dndRingSetting />
     86                  <dndOption>Ringer Off</dndOption>
     87                  <alwaysUsePrimeLine>Default</alwaysUsePrimeLine>
     88                  <alwaysUsePrimeLineForVoiceMessage>Default</alwaysUsePrimeLineForVoiceMessage>
     89                  <emccCallingSearchSpaceName xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" uuid="" />
     90                  <deviceName />
     91                  <model />
     92                  <product />
     93                  <deviceProtocol />
     94                  <class />
     95                  <addressMode />
     96                  <allowAutoConfig />
     97                  <remoteSrstOption />
     98                  <remoteSrstIp />
     99                  <remoteSrstPort />
    100                  <remoteSipSrstIp />
    101                  <remoteSipSrstPort />
    102                  <geolocationInfo />
    103               </currentConfig>
    104               <singleButtonBarge>Off</singleButtonBarge>
    105               <joinAcrossLines>Off</joinAcrossLines>
    106               <builtInBridgeStatus>Off</builtInBridgeStatus>
    107               <callInfoPrivacyStatus>Default</callInfoPrivacyStatus>
    108               <hlogStatus>On</hlogStatus>
    109               <ownerUserName uuid="2d43fc2e-8cea-4e5e-6d71-09781d33c4a5">SIG</ownerUserName>
    110               <ignorePresentationIndicators>false</ignorePresentationIndicators>
    111               <packetCaptureMode>None</packetCaptureMode>
    112               <packetCaptureDuration>0</packetCaptureDuration>
    113               <subscribeCallingSearchSpaceName />
    114               <rerouteCallingSearchSpaceName />
    115               <allowCtiControlFlag>true</allowCtiControlFlag>
    116               <presenceGroupName uuid="{AD243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Presence group</presenceGroupName>
    117               <unattendedPort>false</unattendedPort>
    118               <requireDtmfReception>false</requireDtmfReception>
    119               <rfc2833Disabled>false</rfc2833Disabled>
    120               <certificateOperation>No Pending Operation</certificateOperation>
    121               <certificateStatus>None</certificateStatus>
    122               <upgradeFinishTime />
    123               <deviceMobilityMode>Default</deviceMobilityMode>
    124               <remoteDevice>false</remoteDevice>
    125               <dndOption>Ringer Off</dndOption>
    126               <dndRingSetting />
    127               <dndStatus>false</dndStatus>
    128               <isActive>true</isActive>
    129               <isDualMode>false</isDualMode>
    130               <mobilityUserIdName />
    131               <phoneSuite>Default</phoneSuite>
    132               <phoneServiceDisplay>Default</phoneServiceDisplay>
    133               <isProtected>false</isProtected>
    134               <mobileSmartClientProfileName />
    135               <mtpRequired>false</mtpRequired>
    136               <mtpPreferedCodec>711ulaw</mtpPreferedCodec>
    137               <dialRulesName />
    138               <sshUserId />
    139               <digestUser />
    140               <outboundCallRollover>No Rollover</outboundCallRollover>
    141               <hotlineDevice>false</hotlineDevice>
    142               <secureInformationUrl />
    143               <secureDirectoryUrl />
    144               <secureMessageUrl />
    145               <secureServicesUrl />
    146               <secureAuthenticationUrl />
    147               <secureIdleUrl />
    148               <alwaysUsePrimeLine>Default</alwaysUsePrimeLine>
    149               <alwaysUsePrimeLineForVoiceMessage>Default</alwaysUsePrimeLineForVoiceMessage>
    150               <featureControlPolicy />
    151               <deviceTrustMode>Not Trusted</deviceTrustMode>
    152            </phone>
    153         </return>
    154      </ns:getPhoneResponse>
    155   </soapenv:Body>
    156</soapenv:Envelope>


    Subject: RE: New Message from Salim Guerid in AXL Developer - Administration XML Que
    Replied by: Dennis Heim on 03-11-2013 01:00:40 AM
    A few things:


    ·         Leave MLPP blank. It is showing 1

    ·         sipProfileName is showing as JABBER SIP Profile and on the other Jabber SIP Profile (I can only assume caps matter)

    ·         useDevicePoolCgpnTransformCss is missing (Check the axl schema if that is required.

    If none of that fixes it, I would turn up the axl logs temp. to detailed and then review those. Sometimes the detailed axl logs give more details as to what is going on.



    Dennis Heim | Solution Architect (Collaboration)
    World Wide Technology, Inc. | 314-212-1814

    PS Engineering:  Innovate & Ignite.


    From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
    Sent: Friday, November 01, 2013 1:31 AM
    To: cdicuser@developer.cisco.com
    Subject: New Message from Salim Guerid in AXL Developer - Administration XML Questions: AddPhone: A character to numeric conversion process failed

    Salim Guerid has created a new message in the forum "Administration XML Questions": -------------------------------------------------------------- Hi all,
    I am trying to add a new CSF device using the following code:
    1
    2AddPhoneReq req = new AddPhoneReq();
    3req.phone = new XPhone();
    4req.phone.name = "CSF4" + userID;
    5req.phone.description = site + " CSF " + userID + "-" + extension;
    6req.phone.devicePoolName = new XFkType() { Value = siteDevicePool };
    7req.phone.commonDeviceConfigName = new XFkType() { Value = site + "-Device Config" };
    8req.phone.phoneTemplateName = new XFkType() { Value = PhoneButtonTemplate };
    9req.phone.commonPhoneConfigName = new XFkType() { Value = site + "-Common Phone Profile" };
    10req.phone.callingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    11req.phone.locationName = new XFkType() { Value = site };
    12req.phone.sipProfileName = new XFkType() { Value = stdCSFSIPProfile };
    13req.phone.securityProfileName = new XFkType() { Value = DeviceSecurityProfile };
    14req.phone.subscribeCallingSearchSpaceName = new XFkType() { Value = stdLineCSS[0] + "-" + site };
    15req.phone.ownerUserName = new XFkType() { Value = userID };
    16
    17// Values added to try to address the issue
    18req.phone.packetCaptureDuration = "0";
    19req.phone.networkHoldMohAudioSourceId = "1";
    20req.phone.userlocale = "";
    21req.phone.networkLocale = "";
    22req.phone.userHoldMohAudioSourceId = "1";
    23req.phone.idleTimeout = "5";
    24req.phone.versionStamp = "1";
    25req.phone.mlppDomainId = "1";
    26req.phone.dndRingSetting = "5";
    27
    28StandardResponse res = AXLAPIServiceSingleton.getInstance().addPhone(req);


    The request:
    1
    2<?xml version="1.0" encoding="UTF-8"?>
    3<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    4   <soap:Body>
    5      <addPhone xmlns="http://www.cisco.com/AXL/API/8.5">
    6         <phone xmlns="">
    7            <name>CSF4SIG</name>
    8            <description>CH3 CSF AAA-10241</description>
    9            <protocolSide>User</protocolSide>
    10            <callingSearchSpaceName>Internal-CH3</callingSearchSpaceName>
    11            <devicePoolName>CH3</devicePoolName>
    12            <commonDeviceConfigName>CH3-Device Config</commonDeviceConfigName>
    13            <commonPhoneConfigName>CH3-Common Phone Profile</commonPhoneConfigName>
    14            <locationName>CH3</locationName>
    15            <mediaResourceListName xsi:nil="true" />
    16            <networkHoldMohAudioSourceId>1</networkHoldMohAudioSourceId>
    17            <userHoldMohAudioSourceId>1</userHoldMohAudioSourceId>
    18            <automatedAlternateRoutingCssName xsi:nil="true" />
    19            <aarNeighborhoodName xsi:nil="true" />
    20            <loadInformation xsi:nil="true" />
    21            <versionStamp>1</versionStamp>
    22            <mlppDomainId>1</mlppDomainId>
    23            <useTrustedRelayPoint>Default</useTrustedRelayPoint>
    24            <securityProfileName>Cisco Unified Client Services Framework - Standard SIP Non-Secure</securityProfileName>
    25            <sipProfileName>JABBER SIP Profile</sipProfileName>
    26            <cgpnTransformationCssName xsi:nil="true" />
    27            <geoLocationName xsi:nil="true" />
    28            <geoLocationFilterName xsi:nil="true" />
    29            <phoneTemplateName>Standard Client Services Framework</phoneTemplateName>
    30            <primaryPhoneName xsi:nil="true" />
    31            <userlocale />
    32            <networkLocale />
    33            <idleTimeout>5</idleTimeout>
    34            <softkeyTemplateName xsi:nil="true" />
    35            <defaultProfileName xsi:nil="true" />
    36            <builtInBridgeStatus>Default</builtInBridgeStatus>
    37            <ownerUserName>AAA</ownerUserName>
    38            <packetCaptureMode>None</packetCaptureMode>
    39            <subscribeCallingSearchSpaceName>Internal-CH3</subscribeCallingSearchSpaceName>
    40            <rerouteCallingSearchSpaceName xsi:nil="true" />
    41            <certificateOperation>No Pending Operation</certificateOperation>
    42            <deviceMobilityMode>Default</deviceMobilityMode>
    43            <dndRingSetting>5</dndRingSetting>
    44            <mobilityUserIdName xsi:nil="true" />
    45            <mobileSmartClientProfileName xsi:nil="true" />
    46            <dialRulesName xsi:nil="true" />
    47            <featureControlPolicy xsi:nil="true" />
    48         </phone>
    49      </addPhone>
    50   </soap:Body>
    51</soap:Envelope>



    The response:
    1
    2<?xml version="1.0" encoding="UTF-8"?>
    3<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    4   <soapenv:Body>
    5      <soapenv:Fault>
    6         <faultcode>soapenv:Client</faultcode>
    7         <faultstring>A character to numeric conversion process failed</faultstring>
    8         <detail>
    9            <axlError>
    10               <axlcode>-1213</axlcode>
    11               <axlmessage>A character to numeric conversion process failed</axlmessage>
    12               <request>addPhone</request>
    13            </axlError>
    14         </detail>
    15      </soapenv:Fault>
    16   </soapenv:Body>
    17</soapenv:Envelope>


    I understand well that the error is that I am trying to store a value with non numerical character into a numeric DB field as described here (http://www-01.ibm.com/support/docview.wss?uid=swg21432403).
    However I am running out of idea on how to correct.

    Any help would be highly appreciated.
    --
    To respond to this post, please click the following link: http://developer.cisco.com/web/axl-developer/forums/-/message_boards/view_message/20888328 or simply reply to this email.

    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 03-11-2013 02:22:48 AM
    Ok, checked the API an added the min occurrence=1 fields in my request:
    1req.phone.@class = "Phone";
    2req.phone.product = "Cisco Unified Client Services Framework";
    3req.phone.protocol = "SIP";
    4req.phone.packetCaptureMode = "None";
    5req.phone.protocolSide = "User";
    6req.phone.useTrustedRelayPoint = "Default";
    7req.phone.certificateOperation = "No Pending Operation";
    8req.phone.deviceMobilityMode = "Default";
    The CSF is still not created but the error changed now to -1.
    The request:

     1<?xml version="1.0" encoding="UTF-8"?>
     2<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
     3   <soap:Body>
     4      <addPhone xmlns="http://www.cisco.com/AXL/API/8.5">
     5         <phone xmlns="">
     6            <name>CSF4SIG</name>
     7            <description>CH3 CSF SIG-10241</description>
     8            <product>Cisco Unified Client Services Framework</product>
     9            <class>Phone</class>
    10            <protocol>SIP</protocol>
    11            <protocolSide>User</protocolSide>
    12            <callingSearchSpaceName>Internal-CH3</callingSearchSpaceName>
    13            <devicePoolName>CH3</devicePoolName>
    14            <commonDeviceConfigName>CH3-Device Config</commonDeviceConfigName>
    15            <commonPhoneConfigName>CH3-Common Phone Profile</commonPhoneConfigName>
    16            <locationName>CH3</locationName>
    17            <mediaResourceListName xsi:nil="true" />
    18            <networkHoldMohAudioSourceId xsi:nil="true" />
    19            <userHoldMohAudioSourceId xsi:nil="true" />
    20            <automatedAlternateRoutingCssName xsi:nil="true" />
    21            <aarNeighborhoodName xsi:nil="true" />
    22            <loadInformation xsi:nil="true" />
    23            <versionStamp xsi:nil="true" />
    24            <mlppDomainId xsi:nil="true" />
    25            <useTrustedRelayPoint>Default</useTrustedRelayPoint>
    26            <securityProfileName>Cisco Unified Client Services Framework - Standard SIP Non-Secure</securityProfileName>
    27            <sipProfileName>JABBER SIP Profile</sipProfileName>
    28            <cgpnTransformationCssName xsi:nil="true" />
    29            <geoLocationName xsi:nil="true" />
    30            <geoLocationFilterName xsi:nil="true" />
    31            <phoneTemplateName>Standard Client Services Framework</phoneTemplateName>
    32            <primaryPhoneName xsi:nil="true" />
    33            <userlocale xsi:nil="true" />
    34            <networkLocale xsi:nil="true" />
    35            <idleTimeout xsi:nil="true" />
    36            <softkeyTemplateName xsi:nil="true" />
    37            <defaultProfileName xsi:nil="true" />
    38            <builtInBridgeStatus>Default</builtInBridgeStatus>
    39            <ownerUserName>SIG</ownerUserName>
    40            <packetCaptureMode>None</packetCaptureMode>
    41            <subscribeCallingSearchSpaceName>Internal-CH3</subscribeCallingSearchSpaceName>
    42            <rerouteCallingSearchSpaceName xsi:nil="true" />
    43            <certificateOperation>No Pending Operation</certificateOperation>
    44            <deviceMobilityMode>Default</deviceMobilityMode>
    45            <dndRingSetting xsi:nil="true" />
    46            <mobilityUserIdName xsi:nil="true" />
    47            <mobileSmartClientProfileName xsi:nil="true" />
    48            <dialRulesName xsi:nil="true" />
    49            <featureControlPolicy xsi:nil="true" />
    50         </phone>
    51      </addPhone>
    52   </soap:Body>
    53</soap:Envelope>
    The response:

     1<?xml version="1.0" encoding="UTF-8"?>
     2<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
     3   <soapenv:Body>
     4      <soapenv:Fault>
     5         <faultcode>soapenv:Server</faultcode>
     6         <faultstring />
     7         <detail>
     8            <axlError>
     9               <axlcode>-1</axlcode>
    10               <axlmessage />
    11               <request>addPhone</request>
    12            </axlError>
    13         </detail>
    14      </soapenv:Fault>
    15   </soapenv:Body>
    16</soapenv:Envelope>
    Any idea?

    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 03-11-2013 02:30:44 AM
    Hi Dennis,
    Thanks for your answer. 
     - Leave MLPP blank. It is showing 1
    --> I set that value for testing but removed it in my last test as you can see in the request.

    · sipProfileName is showing as JABBER SIP Profile and on the other Jabber SIP Profile (I can only assume caps matter)
    --> I spoted that one an renamed the profile into the CCM.

    · useDevicePoolCgpnTransformCss is missing (Check the axl schema if that is required.
    --> I have tested with or without setting this value but it does not change.

    Do you know if:
    I need to precise the sequence value? I am not sure what it is and what's the impact?
    I need to mention the a line? Apparently it is not ncessary.

    I will check how to turn up the axl logs, I am not sure exactly where it is located.


    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 03-11-2013 08:43:29 AM
    Well, I have set the AXL log to Debug and here is the result 

     12013-11-03 15:19:00,017 DEBUG [http-8443-7] axlapiservice.Handler - insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkEndUser,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,fkSIPProfile,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,tkdndoption,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( 'ef109e49-4a93-a715-fc2a-7289028a5a17','11','0',null,'0','2','1','0f0744c4-d8f1-0956-31c9-7adec4ab908b','8e1a10fa-a52c-4435-a4ec-540d266c8c37','ef109e49-4a93-a715-fc2a-7289028a5a17','2d43fc2e-8cea-4e5e-6d71-09781d33c4a5',null,'2','95c28f72-afa3-5f1a-ba09-6204c9dd5121','f','0',null,'CH3 CSF SIG-10241',null,'d4867809-e67e-48d5-496d-be31bcecdaf1',null,'ef109e49-4a93-a715-fc2a-7289028a5a17',null,'1','6c8460fb-fd64-b611-6a9b-2a327c22eb28','CSF4SIG','1','577a1e46-aba7-5e2a-f7ab-4999c65c78ba','0','da3cf717-cfca-a52c-7209-2499b4c6c401',null,null,'c6085e14-a32c-4c5e-a3d1-8daf60d81594','2','390' )
     22013-11-03 15:19:00,170 DEBUG [http-8443-7] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchSpace where my_lower(name ) =my_lower('Internal-CH3' )
     32013-11-03 15:19:00,174 ERROR [http-8443-7] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@37fe9e
     4java.lang.NullPointerException
     5        at com.cisco.www.axlapiservice.AddPhoneHandler.doAdd(AddPhoneHandler.java:931)
     6        at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.addPhone(AXLAPIServiceSkeleton.java:13345)
     7        at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:7446)
     8        at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
     9        at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
    10        at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
    11at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
    12        at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
    13        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    14        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    15        at sun.reflect.GeneratedMethodAccessor2444.invoke(Unknown Source)
    16        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    17        at java.lang.reflect.Method.invoke(Method.java:597)
    18        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
    19        at java.security.AccessController.doPrivileged(Native Method)
    20        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    21        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
    22        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
    23        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
    24        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
    25        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
    26        at java.security.AccessController.doPrivileged(Native Method)
    27        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
    28        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    29        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    30        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    31at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:65)
    32        at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:80)
    33        at java.security.AccessController.doPrivileged(Native Method)
    34        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:294)
    35        at com.cisco.www.servletRouters.AXLAlpha.doPost(Unknown Source)
    36        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    37        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    38        at sun.reflect.GeneratedMethodAccessor2444.invoke(Unknown Source)
    39        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    40        at java.lang.reflect.Method.invoke(Method.java:597)
    41        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
    42        at java.security.AccessController.doPrivileged(Native Method)
    43        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    44        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
    45        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
    46        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
    47        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
    48        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
    49        at java.security.AccessController.doPrivileged(Native Method)
    50        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
    51...
    522013-11-03 15:19:00,178 DEBUG [http-8443-7] axlapiservice.AXLCallFlow - In AXL CAll Flow2013-11-03 15:19:00,179 DEBUG [http-8443-7] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringnull
    What looks super anoying to me is that if I run manually the query found in the log, It works pretty well:

    1admin:run sql ccm insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkEndUser,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,fkSIPProfile,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,tkdndoption,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( 'ef109e49-4a93-a715-fc2a-7289028a5a17','11','0',null,'0','2','1','0f0744c4-d8f1-0956-31c9-7adec4ab908b','8e1a10fa-a52c-4435-a4ec-540d266c8c37','ef109e49-4a93-a715-fc2a-7289028a5a17','2d43fc2e-8cea-4e5e-6d71-09781d33c4a5',null,'2','95c28f72-afa3-5f1a-ba09-6204c9dd5121','f','0',null,'CH3 CSF SIG-10241',null,'d4867809-e67e-48d5-496d-be31bcecdaf1',null,'ef109e49-4a93-a715-fc2a-7289028a5a17',null,'1','6c8460fb-fd64-b611-6a9b-2a327c22eb28','CSF4SIG','1','577a1e46-aba7-5e2a-f7ab-4999c65c78ba','0','da3cf717-cfca-a52c-7209-2499b4c6c401',null,null,'c6085e14-a32c-4c5e-a3d1-8daf60d81594','2','390' ) Rows: 1

    Before it is beeing said, I run CCM version 8.6.2.20000-2 and is not able to upgrade in a reasonable timeframe.

    Subject: RE: New Message from Salim Guerid in AXL Developer - Administration XML Que
    Replied by: Dennis Heim on 03-11-2013 10:01:40 AM
    It almost sounds like some type of AXL Bug.

    Dennis Heim | Solution Architect (Collaboration)
    World Wide Technology, Inc. | 314-212-1814

    PS Engineering:  Innovate & Ignite.


    From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
    Sent: Sunday, November 03, 2013 9:44 AM
    To: cdicuser@developer.cisco.com
    Subject: New Message from Salim Guerid in AXL Developer - Administration XML Questions: RE: AddPhone: A character to numeric conversion process failed

    Salim Guerid has created a new message in the forum "Administration XML Questions": -------------------------------------------------------------- Well, I have set the AXL log to Debug and here is the result [@theme_images_path@/emoticons/sad.gif]
    12013-11-03 15:19:00,017 DEBUG [http-8443-7] axlapiservice.Handler - insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkEndUser,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,fkSIPProfile,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,tkdndoption,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( 'ef109e49-4a93-a715-fc2a-7289028a5a17','11','0',null,'0','2','1','0f0744c4-d8f1-0956-31c9-7adec4ab908b','8e1a10fa-a52c-4435-a4ec-540d266c8c37','ef109e49-4a93-a715-fc2a-7289028a5a17','2d43fc2e-8cea-4e5e-6d71-09781d33c4a5',null,'2','95c28f72-afa3-5f1a-ba09-6204c9dd5121','f','0',null,'CH3 CSF SIG-10241',null,'d4867809-e67e-48d5-496d-be31bcecdaf1',null,'ef109e49-4a93-a715-fc2a-7289028a5a17',null,'1','6c8460fb-fd64-b611-6a9b-2a327c22eb28','CSF4SIG','1','577a1e46-aba7-5e2a-f7ab-4999c65c78ba','0','da3cf717-cfca-a52c-7209-2499b4c6c401',null,null,'c6085e14-a32c-4c5e-a3d1-8daf60d81594','2','390' )
    22013-11-03 15:19:00,170 DEBUG [http-8443-7] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchSpace where my_lower(name ) =my_lower('Internal-CH3' )
    32013-11-03 15:19:00,174 ERROR [http-8443-7] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@37fe9e<mailto:com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@37fe9e>
    4java.lang.NullPointerException
    5        at com.cisco.www.axlapiservice.AddPhoneHandler.doAdd(AddPhoneHandler.java:931)
    6        at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.addPhone(AXLAPIServiceSkeleton.java:13345)
    7        at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:7446)
    8        at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
    9        at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
    10        at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
    11at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
    12        at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
    13        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    14        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    15        at sun.reflect.GeneratedMethodAccessor2444.invoke(Unknown Source)
    16        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    17        at java.lang.reflect.Method.invoke(Method.java:597)
    18        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
    19        at java.security.AccessController.doPrivileged(Native Method)
    20        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    21        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
    22        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
    23        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
    24        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
    25        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
    26        at java.security.AccessController.doPrivileged(Native Method)
    27        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
    28        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    29        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    30        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    31at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:65)
    32        at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:80)
    33        at java.security.AccessController.doPrivileged(Native Method)
    34        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:294)
    35        at com.cisco.www.servletRouters.AXLAlpha.doPost(Unknown Source)
    36        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    37        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    38        at sun.reflect.GeneratedMethodAccessor2444.invoke(Unknown Source)
    39        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    40        at java.lang.reflect.Method.invoke(Method.java:597)
    41        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
    42        at java.security.AccessController.doPrivileged(Native Method)
    43        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    44        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
    45        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
    46        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
    47        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
    48        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
    49        at java.security.AccessController.doPrivileged(Native Method)
    50        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
    51...
    522013-11-03 15:19:00,178 DEBUG [http-8443-7] axlapiservice.AXLCallFlow - In AXL CAll Flow2013-11-03 15:19:00,179 DEBUG [http-8443-7] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringnull
    What looks super anoying for me is that if I run manually the query found in the log, It works pretty wel:
    1admin:run sql ccm insert into Device ( fkCallingSearchspace_restrict,tkDeviceProtocol,tkPacketCaptureMode,SpecialLoadInformation,tkStatus_MLPPIndicationStatus,tkStatus_DeviceMobilityMode,tkProtocolSide,fkDevicePool,fkPhoneTemplate,fkCallingSearchSpace,fkEndUser,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,fkSIPProfile,isprotected,tkPreemption,fkDialRules,Description,fkAARNeighborhood,fkCommonDeviceConfig,ikDevice_defaultProfile,fkcallingsearchspace_cgpntransform,fkMediaResourceList,tkCertificateOperation,fkLocation,Name,tkClass,fkCommonPhoneConfig,tkdndoption,pkid,fkCallingSearchSpace_AAR,fkFeatureControlPolicy,fkSecurityProfile,tkStatus_UseTrustedRelayPoint,tkProduct ) values ( 'ef109e49-4a93-a715-fc2a-7289028a5a17','11','0',null,'0','2','1','0f0744c4-d8f1-0956-31c9-7adec4ab908b','8e1a10fa-a52c-4435-a4ec-540d266c8c37','ef109e49-4a93-a715-fc2a-7289028a5a17','2d43fc2e-8cea-4e5e-6d71-09781d33c4a5',null,'2','95c28f72-afa3-5f1a-ba09-6204c9dd5121','f','0',null,'CH3 CSF SIG-10241',null,'d4867809-e67e-48d5-496d-be31bcecdaf1',null,'ef109e49-4a93-a715-fc2a-7289028a5a17',null,'1','6c8460fb-fd64-b611-6a9b-2a327c22eb28','CSF4SIG','1','577a1e46-aba7-5e2a-f7ab-4999c65c78ba','0','da3cf717-cfca-a52c-7209-2499b4c6c401',null,null,'c6085e14-a32c-4c5e-a3d1-8daf60d81594','2','390' ) Rows: 1
    Before it is beeing said, I run CCM version 8.6.2.20000-2 and is not able to upgrade in a reasonable timeframe.
    --
    To respond to this post, please click the following link: http://developer.cisco.com/web/axl-developer/forums/-/message_boards/view_message/20932528 or simply reply to this email.

    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 03-11-2013 03:02:17 PM


    Subject: RE: AddPhone: A character to numeric conversion process failed
    Replied by: Salim Guerid on 25-11-2013 12:40:01 AM
    Cisco TAC was useful  
    Such nul pointer exception could be caused by not mentionning the mobilityUserIdName:

    1req.phone.mobilityUserIdName = new XFkType() { Value=userID};
    Problem solved.
    Next one here...