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);
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>
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>
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:[email protected]]
Sent: Friday, November 01, 2013 1:31 AM
To: [email protected]
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>
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:[email protected]]
Sent: Friday, November 01, 2013 1:31 AM
To: [email protected]
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.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 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: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>
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?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>
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: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
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:[email protected]]
Sent: Sunday, November 03, 2013 9:44 AM
To: [email protected]
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...