Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CCM 6.0 AXL EM getPhone A syntax error has occurred.

Hi.

I'm trying to get phone info ("getPhone") through AXL, from a CCM 6.0 running in vmware.

The request for a phone that has no one logged in is successful. But when someone is logged in I get the following response:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Header/><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Client</faultcode><faultstring>A syntax error has occurred.</faultstring><detail><axl:Error xmlns:axl="http://www.cisco.com/AXL/API/1.0"><axl:code>-201</axl:code><axl:message>A syntax error has occurred.</axl:message><request>getPhone</request></axl:Error></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

Does anyone have a clue?

3 REPLIES

Re: CCM 6.0 AXL EM getPhone A syntax error has occurred.

I take it the request on the wire looks the same for both scenarios. Is that correct?

Have you turned up axl debugging logs to the full extent, make the test and see if there's something in the logs? You might also want to look at DBL traces.

Those will also be the trace files the developer support will ask you for when you open a case on such an issue (I have some experience in that :)

New Member

Re: CCM 6.0 AXL EM getPhone A syntax error has occurred.

Hi.

The trace level of AXL was in DEBUG.

The trace file has a SQL exception:

2008-01-23 07:46:10,695 ERROR [http-8443-Processor21] axl.Handler - com.cisco.ccm.axl.PhoneHandler@67b7c9

java.sql.SQLException: A syntax error has occurred.

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:395)

at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3175)

at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484)

at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2328)

at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2244)

at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1415)

at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1388)

at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204)

at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1212)

at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:202)

at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:941)

at com.cisco.ccm.axl.PhoneHandler.doGet(PhoneHandler.java:1217)

at com.cisco.ccm.axl.Handler.execute(Handler.java:440)

at com.cisco.ccm.axl.AxlListener.onMessage(AxlListener.java:345)

at com.cisco.ccm.axl.AxlListener.doPost(AxlListener.java:238)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)

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:275)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:395)

at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3489)

... 41 more

New Member

Re: CCM 6.0 AXL EM getPhone A syntax error has occurred.

I'm having this same issue. We can make a dozen other SOAP calls without issue, but the getPhone call fails with the -201 error. Oddly, if I specify a deviceName that doesn't exist, it gives me a device not found error. The -201 only happens when the deviceName is found.

411
Views
0
Helpful
3
Replies