cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
737
Views
0
Helpful
3
Replies

CCM 6.0 AXL EM getPhone A syntax error has occurred.

mariomiguelmf
Level 1
Level 1

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 3

stephan.steiner
Spotlight
Spotlight

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

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

sklic
Level 4
Level 4

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.

Getting Started

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: