error on updateLineGroup

Version 1
    This document was generated from CDN thread

    Created by: MARCUS STOLZENBERG on 08-10-2010 09:12:32 AM
    Hi,
     
    CUCM Ver. 8.03.
     
    I try to update the members of an existing LineGroup.
     
    I tried it with soapui.
     
    Version 1:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:updateLineGroup sequence="?">
                      <name>Test</name>
             <Members>
                    <member>
    <lineSelectionOrder>1</lineSelectionOrder>
                   <directoryNumber uuid="?">
                      <pattern>1209</pattern>
                      <routePartitionName>intern</routePartitionName>
                   </directoryNumber>
                </member>
             </Members>
                  </ns:updateLineGroup>
       </soapenv:Body>
    </soapenv:Envelope>
     
    Version 2:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">

       <soapenv:Header/>

       <soapenv:Body>

          <ns:updateLineGroup sequence="?">

                      <name>Test</name>

             <addMembers>

                    <member>

    <lineSelectionOrder>1</lineSelectionOrder>

                   <directoryNumber uuid="?">

                      <pattern>1209</pattern>

                      <routePartitionName>intern</routePartitionName>

                   </directoryNumber>

                </member>

             </addMembers>

                  </ns:updateLineGroup>

       </soapenv:Body>

    </soapenv:Envelope>
     
     
    but I get the following error:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
       <soapenv:Body>
          <soapenv:Fault>
             <faultcode>soapenv:Client</faultcode>
             <faultstring>A syntax error has occurred.</faultstring>
             <detail>
                <axlError>
                   <axlcode>-201</axlcode>
                   <axlmessage>A syntax error has occurred.</axlmessage>
                   <request>updateLineGroup</request>
                </axlError>
             </detail>
          </soapenv:Fault>
       </soapenv:Body>
    </soapenv:Envelope>
     
    To ceck the connection I did a rename of the Huntgroup -> no problem.
     
    Best Regards,
    Marcus

    Subject: RE: error on updateLineGroup
    Replied by: Florian Kroessbacher on 08-10-2010 09:44:47 AM
    Hy,
     
    can you push me the wsdl, cause i'm running on 7.1(5)
     
    cheers Floh

    Subject: RE: error on updateLineGroup
    Replied by: MARCUS STOLZENBERG on 22-10-2010 12:12:53 PM
    Hy,
     
    can you push me the wsdl, cause i'm running on 7.1(5)
     
    cheers Floh


     
    Hi  Floh,
     
    I don't know if I am allowed to share the wsdl file(s). Mayby one of the admins can clear this.
     
    I did some more tests and activated and collected axl log from server:
     
     <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:updateLineGroup sequence="?">
             <name>t6667</name>
             <addMembers>
                  <member>
                   <directoryNumber>
                      <pattern>1209</pattern>
                      <routePartitionName>intern</routePartitionName>
                   </directoryNumber>
                </member>
             </addMembers>
                  </ns:updateLineGroup>
       </soapenv:Body>
    </soapenv:Envelope>

    2010-10-22 14:01:47,099 DEBUG [http-8443-12] servletRouters.AXLFilter - DBLCNQueue Count: 0
    2010-10-22 14:01:47,099 DEBUG [http-8443-12] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
    2010-10-22 14:01:47,099 INFO  [http-8443-12] servletRouters.AXLAlpha - SOAPAction : "CUCMB ver=8.0 updateLineGroup"
    2010-10-22 14:01:47,100 INFO  [http-8443-12] servletRouters.AXLAlpha - Going to axis--->
    2010-10-22 14:01:47,102 DEBUG [http-8443-12] axlapiservice.Handler - Handler initializing
    2010-10-22 14:01:47,106 DEBUG [http-8443-12] axlapiservice.Handler - getPkid Query is :select pkid from LineGroup where my_lower(name ) =my_lower('t6667' )
    2010-10-22 14:01:47,108 DEBUG [http-8443-12] axlapiservice.Handler - update LineGroup set  where pkid='d39c7f14-4f1a-789b-0a23-76b03531daf1'
    2010-10-22 14:01:47,112 ERROR [http-8443-12] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info
    2010-10-22 14:01:47,113 DEBUG [http-8443-12] axlapiservice.AXLCallFlow - In AXL CAll Flow
    2010-10-22 14:01:47,113 DEBUG [http-8443-12] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringA syntax error has occurred.
    2010-10-22 14:01:47,114 DEBUG [http-8443-12] axlapiservice.AXLCallFlow - Exception caught. Attempting to retrieve error information from database.java.lang.NumberFormatException: For input string: "A syntax error has occurred."
    2010-10-22 14:01:47,114 INFO  [http-8443-12] axlapiservice.AXLCallFlow - sqlString is : select name from typedberrors where enum=A syntax error has occurred.
    2010-10-22 14:01:47,115 INFO  [http-8443-12] axlapiservice.AXLCallFlow - errorCodeString is : A syntax error has occurred.
    2010-10-22 14:01:47,118 ERROR [http-8443-12] axlapiservice.AXLCallFlow - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@12a7fb8
    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:963)
        at com.cisco.www.axlapiservice.AXLCallFlow.getSOAPError(AXLCallFlow.java:111)
        at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.updateLineGroup(AXLAPIServiceSkeleton.java:2396)
        at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:1398)
        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.GeneratedMethodAccessor302.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.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.GeneratedMethodAccessor302.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.www.servletRouters.AXLFilter.doFilter(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor347.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: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)
     
    Best Regards,
    Marcus

    Subject: RE: error on updateLineGroup
    Replied by: Axel Schemberg on 25-10-2010 11:18:29 AM
    Hi Marcus,
     
    I am not sure, but you are sending 'sequence="?"' ... try 'sequence="123"' (or any other number).
     
    Regards
     
    Axel

    Subject: RE: error on updateLineGroup
    Replied by: MARCUS STOLZENBERG on 25-10-2010 12:02:10 PM
    Hi Marcus,
     
    I am not sure, but you are sending 'sequence="?"' ... try 'sequence="123"' (or any other number).
     
    Regards
     
    Axel

     
    Hi Axel,
     
    I tried this. Same error:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:updateLineGroup sequence="123">
             <name>t6667</name>
             <addMembers>
                  <member>
                   <directoryNumber>
                      <pattern>1208</pattern>
                      <routePartitionName>intern</routePartitionName>
                   </directoryNumber>
                </member>
             </addMembers>
                  </ns:updateLineGroup>
       </soapenv:Body>
    </soapenv:Envelope>

    2010-10-25 13:29:21,408 DEBUG [Thread-30] servletRouters.AXLThrottler - Throttle URL[0] : jdbc:informix-sqli://cmlab08:1500/ccm8_0_3_20000_2:informixserver=cmlab08_ccm8_0_3_20000_2;IFX_LOCK_MODE_WAIT=10;DB_LOCALE=en_US.utf8;CLIENT_LOCALE=en_US.utf8;user=informix;IFX_SOC_TIMEOUT=300000;
    2010-10-25 13:29:21,423 DEBUG [http-8443-4] servletRouters.AXLFilter - DBLCNQueue Count: 2
    2010-10-25 13:29:21,425 DEBUG [http-8443-4] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
    2010-10-25 13:29:21,425 INFO  [http-8443-4] servletRouters.AXLAlpha - SOAPAction : "CUCMB ver=8.0 updateLineGroup"
    2010-10-25 13:29:21,465 DEBUG [http-8443-4] servletRouters.AXLAlpha - addToCache("Administrator")
    2010-10-25 13:29:21,466 INFO  [http-8443-4] servletRouters.AXLAlpha - Going to axis--->
    2010-10-25 13:29:21,478 DEBUG [http-8443-4] axlapiservice.Handler - Handler initializing
    2010-10-25 13:29:21,497 DEBUG [http-8443-4] axlapiservice.Handler - getPkid Query is :select pkid from LineGroup where my_lower(name ) =my_lower('t6667' )
    2010-10-25 13:29:21,499 DEBUG [http-8443-4] axlapiservice.Handler - update LineGroup set  where pkid='3bf650dc-cd79-17ce-b144-fbff45a3d290'
    2010-10-25 13:29:21,502 ERROR [http-8443-4] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info
    2010-10-25 13:29:21,502 DEBUG [http-8443-4] axlapiservice.AXLCallFlow - In AXL CAll Flow
    2010-10-25 13:29:21,503 DEBUG [http-8443-4] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringA syntax error has occurred.
    2010-10-25 13:29:21,504 DEBUG [http-8443-4] axlapiservice.AXLCallFlow - Exception caught. Attempting to retrieve error information from database.java.lang.NumberFormatException: For input string: "A syntax error has occurred."
    2010-10-25 13:29:21,504 INFO  [http-8443-4] axlapiservice.AXLCallFlow - sqlString is : select name from typedberrors where enum=A syntax error has occurred.
    2010-10-25 13:29:21,505 INFO  [http-8443-4] axlapiservice.AXLCallFlow - errorCodeString is : A syntax error has occurred.
    2010-10-25 13:29:21,508 ERROR [http-8443-4] axlapiservice.AXLCallFlow - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@1648ab9
    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)
     
    ...
     
    Thanks.
     
    Best Regards,
    Marcus
     
     

    Subject: RE: error on updateLineGroup
    Replied by: David Staudt on 27-10-2010 09:58:38 PM
    I believe this is a known issue with updateLineGroup: CSCsz81819
     
    You should be able to workaround by using executeSQLUpdate to add rows to the linegroupnumplanmap table.  See the Data Dictionary for details on the table/fields.