CCM 6.0 AXL EM getPhone A syntax error has occurred.

Unanswered Question
Jan 16th, 2008

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?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
stephan.steiner Mon, 01/21/2008 - 00:27

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

mariomiguelmf Wed, 01/23/2008 - 06:58

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 - [email protected]

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

sklic Mon, 01/21/2008 - 16:28

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.

Actions

This Discussion