cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
648
Views
0
Helpful
0
Comments
cdnadmin
Community Member
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.
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:

Quick Links