This document was generated from CDN thread
Created by: Stefania Oliviero on 13-10-2011 09:38:40 AM
Hi to all, I'm using CUCM 8.5, I've downloaded wsdl file for AXL and I've used Eclipse to create AXL wrapper.
So, I need to add new lines to a phone via AXL, but I've got an error: A character to numeric conversion process failed
Below, you can see the log (I found on CUCM), and from this log I can see the problem is given by serialization of the line index parameter (highlighetd in red).
Has anyone had similar problem ?
With .net and 7.1 wsdl files I haven't had this problem, It worked fine.
This is the the AXL log I've found on CUCM:
2011-10-13 15:04:16,674 INFO [http-8443-1] servletRouters.AXLFilter - AXL REQUEST :
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ xmlns:xsd="http://www.w3.org/2001/XMLSchema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance soapenv:Body updatePhone xmlns="http://www.cisco.com/AXL/API/8.5 name xmlns="">SEP04C5A44C91B0</name><lines xmlns=""><line><index>com.cisco.www.AXL.API._8_5.XInteger@2 /index label Name /label asciiLabel Name /asciiLabel display Name /display dirn pattern 6502 /pattern routePartitionName PTDN_Phones /routePartitionName /dirn displayAscii Name /displayAscii e164Mask 555555 /e164Mask /line /lines /updatePhone /soapenv:Body /soapenv:Envelope
2011-10-13 15:04:16,702 DEBUG [http-8443-1] servletRouters.AXLFilter - DBLCNQueue Count: 0
2011-10-13 15:04:16,702 DEBUG [http-8443-1] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
2011-10-13 15:04:16,703 INFO [http-8443-1] servletRouters.AXLAlpha - SOAPAction : "CUCM
B ver=8.5 updatePhone"
2011-10-13 15:04:16,703 INFO [http-8443-1] servletRouters.AXLAlpha - Going to axis--->
2011-10-13 15:04:16,709 DEBUG [http-8443-1] axlapiservice.Handler - getPkid Query is :select pkid from Device where my_lower(name ) =my_lower('SEP04C5A44C91B0' )
2011-10-13 15:04:16,711 DEBUG [http-8443-1] axlapiservice.UpdatePhoneHandler - select isdualmode, tkProduct,tkdeviceprotocol,tkmodel,tkclass,mtpRequired from device where pkid='60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,715 DEBUG [http-8443-1] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol in ('0',99)
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 21
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 21
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 34
2011-10-13 15:04:16,720 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 35
2011-10-13 15:04:16,720 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 18
2011-10-13 15:04:16,721 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 79
2011-10-13 15:04:16,721 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 78
2011-10-13 15:04:16,722 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 53
2011-10-13 15:04:16,722 DEBUG [http-8443-1] axlapiservice.UpdatePhoneHandler - Select tkcertificateoperation from device where pkid = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,725 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 72
2011-10-13 15:04:16,725 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 76
2011-10-13 15:04:16,729 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 77
2011-10-13 15:04:16,729 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 63
2011-10-13 15:04:16,731 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 104
2011-10-13 15:04:16,734 DEBUG [http-8443-1] axlapiservice.Handler - select fknumplan, numplanindex from devicenumplanmap where fkdevice = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,734 DEBUG [http-8443-1] axlapiservice.Handler - getPkid Query is :select pkid from RoutePartition where my_lower(name ) =my_lower('PTDN_Phones' )
2011-10-13 15:04:16,737 DEBUG [http-8443-1] axlapiservice.Handler - select pkid,tkPatternUsage from numplan where fkRoutePartition='e9482426-c79e-a716-a340-a9c505a6e31a' and DNOrPattern='6502'
2011-10-13 15:04:16,740 DEBUG [http-8443-1] axlapiservice.Handler - select tkproduct,tkdeviceprotocol from device where pkid = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,742 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 5
2011-10-13 15:04:16,743 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 28
2011-10-13 15:04:16,744 DEBUG [http-8443-1] axlapiservice.Handler - Select param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol='0' and tksupportsfeature ='99'
2011-10-13 15:04:16,747 DEBUG [http-8443-1] axlapiservice.Handler - Select param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol='0' and tksupportsfeature ='30'
2011-10-13 15:04:16,749 DEBUG [http-8443-1] axlapiservice.Handler - test param2 200:4:2
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - First Token 200
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - maxCalls2 4
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - busyTri2 2
2011-10-13 15:04:16,751 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 99
2011-10-13 15:04:16,751 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 30
2011-10-13 15:04:16,752 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 99
2011-10-13 15:04:16,752 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 30
2011-10-13 15:04:16,753 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 92
2011-10-13 15:04:16,754 DEBUG [http-8443-1] axlapiservice.Handler - insert into DeviceNumPlanMap ( busyTrigger,displayascii,fkNumPlan,labelascii,fkDevice,MaxNumCalls,pkid,E164Mask,display,label,NumPlanIndex ) values ( '2','Name','7416115f-633a-6f46-e683-8063cc9677fe','Name','60659999-279f-a467-f9f2-15b7e15667dc','4','a2d4723e-6621-326d-6069-c9ce68c7f993','555555','Name','Name','com.cisco.www.AXL.API._8_5.XInteger@2 )
2011-10-13 15:04:16,757 ERROR [http-8443-1] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info
2011-10-13 15:04:16,758 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - In AXL CAll Flow
2011-10-13 15:04:16,758 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringA character to numeric conversion process failed
2011-10-13 15:04:16,759 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Exception caught. Attempting to retrieve error information from database.java.lang.NumberFormatException: For input string: "A character to numeric conversion process failed"
2011-10-13 15:04:16,759 INFO [http-8443-1] axlapiservice.AXLCallFlow - sqlString is : select name from typedberrors where enum=A character to numeric conversion process failed
2011-10-13 15:04:16,760 INFO [http-8443-1] axlapiservice.AXLCallFlow - errorCodeString is : A character to numeric conversion process failed
2011-10-13 15:04:16,762 ERROR [http-8443-1] axlapiservice.AXLCallFlow - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@8cec2c
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3461)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1662)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:219)
at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:1024)
at com.cisco.[url=http://www.axlapiservice.axlcallflow.getsoaperror(axlcallflow.java:111/]www.axlapiservice.AXLCallFlow.getSOAPError(AXLCallFlow.java:111)
at com.cisco.[url=http://www.axlapiservice.axlapiserviceskeleton.updatephone(axlapiserviceskeleton.java:17778/]www.axlapiservice.AXLAPIServiceSkeleton.updatePhone(AXLAPIServiceSkeleton.java:17778)
at com.cisco.[url=http://www.axlapiservice.axlapiservicemessagereceiverinout.invokebusinesslogic(axlapiservicemessagereceiverinout.java:9840/]www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:9840)
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:65)
at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:80)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:294)
at com.cisco.[url=http://www.servletrouters.axlalpha.dopost(unknown/]www.servletRouters.AXLAlpha.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at com.cisco.[url=http://www.servletrouters.axlfilter.dofilter(unknown/]www.servletRouters.AXLFilter.doFilter(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:243)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:394)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
... 82 more
2011-10-13 15:04:16,763 INFO [http-8443-1] axlapiservice.AXLCallFlow - Exception occured while querying the database : java.sql.SQLException: A character to numeric conversion process failed
2011-10-13 15:04:16,764 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Setting soap fault
2011-10-13 15:04:16,764 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Setting soap fault2
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLAlpha - Request processed by AXIS
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ soapenv:Body soapenv:Fault faultcode soapenv:Client /faultcode faultstring A character to numeric conversion process failed</faultstring><detail><axlError><axlcode>-1213</axlcode><axlmessage>A character to numeric conversion process failed</axlmessage><request>updatePhone</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLFilter - Request 1318493741038 was process in 93ms
Thank you.
Stefania.
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Jeremy Sanders on 03-11-2011 12:17:46 AM
I am having the same problem using the updatePhone request to update speed dials.
Did you figure out how to fix it yet?
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Jeremy Sanders on 03-11-2011 12:37:12 AM
Nevermind, after closer inspection, there was a leading space on one of the values I passed in.
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Stefania Oliviero on 03-11-2011 04:54:02 AM
We have resolved, modifiyng wrapper class XInteger. The method toString was wrong so we have overidden this method.
Created by: Stefania Oliviero on 13-10-2011 09:38:40 AM
Hi to all, I'm using CUCM 8.5, I've downloaded wsdl file for AXL and I've used Eclipse to create AXL wrapper.
So, I need to add new lines to a phone via AXL, but I've got an error: A character to numeric conversion process failed
Below, you can see the log (I found on CUCM), and from this log I can see the problem is given by serialization of the line index parameter (highlighetd in red).
Has anyone had similar problem ?
With .net and 7.1 wsdl files I haven't had this problem, It worked fine.
This is the the AXL log I've found on CUCM:
2011-10-13 15:04:16,674 INFO [http-8443-1] servletRouters.AXLFilter - AXL REQUEST :
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ xmlns:xsd="http://www.w3.org/2001/XMLSchema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance soapenv:Body updatePhone xmlns="http://www.cisco.com/AXL/API/8.5 name xmlns="">SEP04C5A44C91B0</name><lines xmlns=""><line><index>com.cisco.www.AXL.API._8_5.XInteger@2 /index label Name /label asciiLabel Name /asciiLabel display Name /display dirn pattern 6502 /pattern routePartitionName PTDN_Phones /routePartitionName /dirn displayAscii Name /displayAscii e164Mask 555555 /e164Mask /line /lines /updatePhone /soapenv:Body /soapenv:Envelope
2011-10-13 15:04:16,702 DEBUG [http-8443-1] servletRouters.AXLFilter - DBLCNQueue Count: 0
2011-10-13 15:04:16,702 DEBUG [http-8443-1] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
2011-10-13 15:04:16,703 INFO [http-8443-1] servletRouters.AXLAlpha - SOAPAction : "CUCM
B ver=8.5 updatePhone"2011-10-13 15:04:16,703 INFO [http-8443-1] servletRouters.AXLAlpha - Going to axis--->
2011-10-13 15:04:16,709 DEBUG [http-8443-1] axlapiservice.Handler - getPkid Query is :select pkid from Device where my_lower(name ) =my_lower('SEP04C5A44C91B0' )
2011-10-13 15:04:16,711 DEBUG [http-8443-1] axlapiservice.UpdatePhoneHandler - select isdualmode, tkProduct,tkdeviceprotocol,tkmodel,tkclass,mtpRequired from device where pkid='60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,715 DEBUG [http-8443-1] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol in ('0',99)
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 21
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 21
2011-10-13 15:04:16,719 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 34
2011-10-13 15:04:16,720 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 35
2011-10-13 15:04:16,720 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 18
2011-10-13 15:04:16,721 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 79
2011-10-13 15:04:16,721 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 78
2011-10-13 15:04:16,722 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 53
2011-10-13 15:04:16,722 DEBUG [http-8443-1] axlapiservice.UpdatePhoneHandler - Select tkcertificateoperation from device where pkid = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,725 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 72
2011-10-13 15:04:16,725 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 76
2011-10-13 15:04:16,729 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 77
2011-10-13 15:04:16,729 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 63
2011-10-13 15:04:16,731 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 104
2011-10-13 15:04:16,734 DEBUG [http-8443-1] axlapiservice.Handler - select fknumplan, numplanindex from devicenumplanmap where fkdevice = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,734 DEBUG [http-8443-1] axlapiservice.Handler - getPkid Query is :select pkid from RoutePartition where my_lower(name ) =my_lower('PTDN_Phones' )
2011-10-13 15:04:16,737 DEBUG [http-8443-1] axlapiservice.Handler - select pkid,tkPatternUsage from numplan where fkRoutePartition='e9482426-c79e-a716-a340-a9c505a6e31a' and DNOrPattern='6502'
2011-10-13 15:04:16,740 DEBUG [http-8443-1] axlapiservice.Handler - select tkproduct,tkdeviceprotocol from device where pkid = '60659999-279f-a467-f9f2-15b7e15667dc'
2011-10-13 15:04:16,742 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 5
2011-10-13 15:04:16,743 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 28
2011-10-13 15:04:16,744 DEBUG [http-8443-1] axlapiservice.Handler - Select param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol='0' and tksupportsfeature ='99'
2011-10-13 15:04:16,747 DEBUG [http-8443-1] axlapiservice.Handler - Select param from ProductSupportsFeature where tkproduct='336' and tkdeviceprotocol='0' and tksupportsfeature ='30'
2011-10-13 15:04:16,749 DEBUG [http-8443-1] axlapiservice.Handler - test param2 200:4:2
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - First Token 200
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - maxCalls2 4
2011-10-13 15:04:16,750 DEBUG [http-8443-1] axlapiservice.Handler - busyTri2 2
2011-10-13 15:04:16,751 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 99
2011-10-13 15:04:16,751 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 30
2011-10-13 15:04:16,752 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 does not support feature 99
2011-10-13 15:04:16,752 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 30
2011-10-13 15:04:16,753 DEBUG [http-8443-1] axlapiservice.Handler - Product 336 supports feature 92
2011-10-13 15:04:16,754 DEBUG [http-8443-1] axlapiservice.Handler - insert into DeviceNumPlanMap ( busyTrigger,displayascii,fkNumPlan,labelascii,fkDevice,MaxNumCalls,pkid,E164Mask,display,label,NumPlanIndex ) values ( '2','Name','7416115f-633a-6f46-e683-8063cc9677fe','Name','60659999-279f-a467-f9f2-15b7e15667dc','4','a2d4723e-6621-326d-6069-c9ce68c7f993','555555','Name','Name','com.cisco.www.AXL.API._8_5.XInteger@2 )
2011-10-13 15:04:16,757 ERROR [http-8443-1] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info
2011-10-13 15:04:16,758 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - In AXL CAll Flow
2011-10-13 15:04:16,758 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringA character to numeric conversion process failed
2011-10-13 15:04:16,759 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Exception caught. Attempting to retrieve error information from database.java.lang.NumberFormatException: For input string: "A character to numeric conversion process failed"
2011-10-13 15:04:16,759 INFO [http-8443-1] axlapiservice.AXLCallFlow - sqlString is : select name from typedberrors where enum=A character to numeric conversion process failed
2011-10-13 15:04:16,760 INFO [http-8443-1] axlapiservice.AXLCallFlow - errorCodeString is : A character to numeric conversion process failed
2011-10-13 15:04:16,762 ERROR [http-8443-1] axlapiservice.AXLCallFlow - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@8cec2c
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3461)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3774)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2580)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1662)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1635)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1229)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:219)
at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:1024)
at com.cisco.[url=http://www.axlapiservice.axlcallflow.getsoaperror(axlcallflow.java:111/]www.axlapiservice.AXLCallFlow.getSOAPError(AXLCallFlow.java:111)
at com.cisco.[url=http://www.axlapiservice.axlapiserviceskeleton.updatephone(axlapiserviceskeleton.java:17778/]www.axlapiservice.AXLAPIServiceSkeleton.updatePhone(AXLAPIServiceSkeleton.java:17778)
at com.cisco.[url=http://www.axlapiservice.axlapiservicemessagereceiverinout.invokebusinesslogic(axlapiservicemessagereceiverinout.java:9840/]www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:9840)
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:65)
at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:80)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:294)
at com.cisco.[url=http://www.servletrouters.axlalpha.dopost(unknown/]www.servletRouters.AXLAlpha.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at com.cisco.[url=http://www.servletrouters.axlfilter.dofilter(unknown/]www.servletRouters.AXLFilter.doFilter(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:243)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:394)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3779)
... 82 more
2011-10-13 15:04:16,763 INFO [http-8443-1] axlapiservice.AXLCallFlow - Exception occured while querying the database : java.sql.SQLException: A character to numeric conversion process failed
2011-10-13 15:04:16,764 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Setting soap fault
2011-10-13 15:04:16,764 DEBUG [http-8443-1] axlapiservice.AXLCallFlow - Setting soap fault2
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLAlpha - Request processed by AXIS
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ soapenv:Body soapenv:Fault faultcode soapenv:Client /faultcode faultstring A character to numeric conversion process failed</faultstring><detail><axlError><axlcode>-1213</axlcode><axlmessage>A character to numeric conversion process failed</axlmessage><request>updatePhone</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
2011-10-13 15:04:16,766 INFO [http-8443-1] servletRouters.AXLFilter - Request 1318493741038 was process in 93ms
Thank you.
Stefania.
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Jeremy Sanders on 03-11-2011 12:17:46 AM
I am having the same problem using the updatePhone request to update speed dials.
Did you figure out how to fix it yet?
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Jeremy Sanders on 03-11-2011 12:37:12 AM
Nevermind, after closer inspection, there was a leading space on one of the values I passed in.
Subject: RE: Error adding new line to a phone, with CUCM 8.5
Replied by: Stefania Oliviero on 03-11-2011 04:54:02 AM
We have resolved, modifiyng wrapper class XInteger. The method toString was wrong so we have overidden this method.