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 :
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 : "CUCMB 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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: