AXL / java.sql.SQLException

Version 1
    This document was generated from CDN thread

    Created by: CHRISTIAN END on 02-09-2009 08:56:18 AM
    Hello,
    i worked on a script with PHP that sets a CFA for a directory number and a special state of the user for this phone in a MySql DB.
     
    On my CUCM 7 in the office it works fine. It also works fine on a CUCM 6.1.2 for a few days.
    But now i get this error messages in the AXL Trace... I hope someone can help me!!!
     
    This is only one of the Requests and errors... This request was for NO CFA.
     

    2009-09-02 08:00:04,815 INFO [http-8443-Processor22] axl.AXLRouter - Received request 1248944066632 from AXLadmin at IP 53.101.17.68
    2009-09-02 08:00:04,938 INFO [http-8443-Processor22] axl.AXLRouter - <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><axl:updateLine sequence="1234" xmlns:axlapi="http://www.cisco.com/AXL/API/1.0" xmlns:axl="http://www.cisco.com/AXL/API/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.cisco.com/AXL/API/1.0 axlsoap.xsd"><UpdateLineReq><pattern>777</pattern><callForwardAll><destination></destination></callForwardAll></UpdateLineReq></axl:updateLine></SOAP-ENV:Body></SOAP-ENV:Envelope>
    2009-09-02 08:00:05,042 ERROR [http-8443-Processor22] axl.AXLRouter - com.cisco.ccm.axl.AXLRouter@1af7dad
    java.sql.SQLException: Can't load driver java.lang.reflect.InvocationTargetException
    at com.informix.util.IfxErrMsg.getLocSQLException(IfxErrMsg.java:494)
    at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:271)
    at java.sql.DriverManager.getConnection(DriverManager.java:525)
    at java.sql.DriverManager.getConnection(DriverManager.java:193)
    at com.cisco.ccm.dbl.Connector.getConn(Connector.java:663)
    at com.cisco.ccm.dbl.Connector.connect(Connector.java:580)
    at com.cisco.ccm.dbl.Connector.connect(Connector.java:510)
    at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:751)
    at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:733)
    at com.cisco.ccm.axl.AXLThrottler.getNodeNames(AXLThrottler.java:223)
    at com.cisco.ccm.axl.AXLThrottler.getClusterInformation(AXLThrottler.java:89)
    at com.cisco.ccm.axl.AXLThrottler.getThrottlingCount(AXLThrottler.java:145)
    at com.cisco.ccm.axl.AXLRouter.checkThrottleStatus(AXLRouter.java:487)
    at com.cisco.ccm.axl.AXLRouter.doPost(AXLRouter.java:161)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at sun.reflect.GeneratedMethodAccessor2954.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.valves.AccessLogValve.invoke(AccessLogValve.java:541)
    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.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
    at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
    ... 42 more
    Caused by: java.sql.SQLException: INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.
    at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:971)
    ... 47 more
    Caused by: com.informix.asf.IfxASFRemoteException:
    at com.informix.asf.Connection.recvConnectionResponse(Connection.java:600)
    at com.informix.asf.Connection.establishConnection(Connection.java:1488)
    at com.informix.asf.Connection.<init>(Connection.java:261)
    at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:906)
    ... 47 more

    Subject: RE: AXL / java.sql.SQLException
    Replied by: David Staudt on 02-09-2009 12:34:29 PM
    I believe this error indicates that the AXL service could not connect to the UCM database.  If the request is being sent to a UCM subscriber node, ensure that the publisher node is up and running, and that the cluster configuration is correct.

    Subject: RE: AXL / java.sql.SQLException
    Replied by: CHRISTIAN END on 03-09-2009 01:10:31 PM
    I point the AXL request to the publisher. I try to restart the machines. Possible that there is something stuck in the system.