Can't update HuntPilot via AXL 9.0

Version 1
    This document was generated from CDN thread

    Created by: Michael Kail on 20-02-2013 07:49:41 AM
    Hi,

    has anybody tried to update a huntpilot with AXL 9.0 on a CUCM 9.0? I always get the error: Item not valid: The specified entry was not found
    When i look at the traces there happens an error on the cucm with the following request:
    delete from HuntPilotQueue where fkNumPlan_pilot='8fcacc29-2869-b4e0-44e3-9289ece9f529'
    The table HuntPilotQueue is empty.
     
    Has anybody the same problem?
     
    Regards Michael

    Subject: RE: Can't update HuntPilot via AXL 9.0
    Replied by: Michael Kail on 25-02-2013 04:59:00 AM
    Here's just a small axl trace extract:

     <?xml version="1.0" encoding="UTF-8"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.cisco.com/AXL/API/9.0"><SOAP-ENV:Body><ns1:updateHuntPilot><uuid>156c3fda-7b55-399e-7a85-e0d5e4de81f7</uuid><newPattern>1500</newPattern><description>Test</description><newRoutePartitionName>test</newRoutePartitionName><forwardHuntNoAnswer><destination>555</destination></forwardHuntNoAnswer><forwardHuntBusy><destination>555</destination></forwardHuntBusy></ns1:updateHuntPilot></SOAP-ENV:Body></SOAP-ENV:Envelope>


    2013-02-25 12:15:47,810 DEBUG [http-bio-443-exec-16] servletRouters.AXLFilter - DBLCNQueue Count: 0
    2013-02-25 12:15:47,810 DEBUG [http-bio-443-exec-16] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
    2013-02-25 12:15:47,810 INFO  [http-bio-443-exec-16] servletRouters.AXLAlpha - SOAPAction : "CUCMB ver=9.0 updateHuntPilot"
    2013-02-25 12:15:47,834 DEBUG [http-bio-443-exec-16] servletRouters.AXLAlpha - addToCache("ccmadministrator")
    2013-02-25 12:15:47,835 INFO  [http-bio-443-exec-16] servletRouters.AXLAlpha - Going to axis--->
    2013-02-25 12:15:47,838 DEBUG [http-bio-443-exec-16] axlapiservice.Handler - getPkid Query is :select pkid from RoutePartition where my_lower(name ) =my_lower('test' )
    2013-02-25 12:15:47,839 DEBUG [http-bio-443-exec-16] axlapiservice.Handler - update NumPlan set CFBIntDestination='555',CFBDestination='555',Description='Test',CFNAIntDestination='555',DNOrPattern='1500',fkRoutePartition='6d6e1128-eeea-4b5c-b2ca-9a8764174914',CFNADestination='555' where pkid='156c3fda-7b55-399e-7a85-e0d5e4de81f7'
    2013-02-25 12:15:47,879 DEBUG [http-bio-443-exec-16] axlapiservice.Handler - delete from HuntPilotQueue where fkNumPlan_pilot='156c3fda-7b55-399e-7a85-e0d5e4de81f7'
    2013-02-25 12:15:47,882 ERROR [http-bio-443-exec-16] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@10cd0c5
    com.cisco.www.axlapiservice.ItemNotValidException: Item not valid: The specified entry was not found
        at com.cisco.www.axlapiservice.UpdateHuntPilotHandler.doUpdate(UpdateHuntPilotHandler.java:503)
        at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.updateHuntPilot(AXLAPIServiceSkeleton.java:872)
        at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:345)
        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:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at sun.reflect.GeneratedMethodAccessor1068.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:274)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:271)
        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:306)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:166)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:299)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:57)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:193)
        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:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
        at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:67)
        at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:102)
        at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:89)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:321)
        at com.cisco.www.servletRouters.AXLAlpha.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at sun.reflect.GeneratedMethodAccessor217.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:274)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:271)
        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:306)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:166)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:299)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:57)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:193)
        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:188)
        at com.cisco.www.servletRouters.AXLFilter.doFilter(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor218.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:274)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:271)
        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:306)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:246)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:57)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:193)
        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:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:309)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
    2013-02-25 12:15:47,883 DEBUG [http-bio-443-exec-16] axlapiservice.AXLCallFlow - In AXL CAll Flow
    2013-02-25 12:15:47,884 DEBUG [http-bio-443-exec-16] axlapiservice.AXLCallFlow - In AXL CAll Flow errorCodeStringItem not valid: The specified entry was not found
    2013-02-25 12:15:47,884 DEBUG [http-bio-443-exec-16] axlapiservice.AXLCallFlow - Setting soap fault
    2013-02-25 12:15:47,884 DEBUG [http-bio-443-exec-16] axlapiservice.AXLCallFlow - Setting soap fault2
    2013-02-25 12:15:47,885 INFO  [http-bio-443-exec-16] servletRouters.AXLAlpha - Request processed by AXIS
    2013-02-25 12:15:47,886 INFO  [http-bio-443-exec-16] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server</faultcode><faultstring>Item not valid: The specified entry was not found</faultstring><detail><axlError><axlcode>5007</axlcode><axlmessage>Item not valid: The specified entry was not found</axlmessage><request>updateHuntPilot</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
    2013-02-25 12:15:47,886 INFO  [http-bio-443-exec-16] servletRouters.AXLFilter - Request 1354172275651 was process in 80ms
     

    Subject: RE: Can't update HuntPilot via AXL 9.0
    Replied by: Michael Kail on 25-02-2013 06:19:19 AM
    Okay, found the error. You have to add 'queueCalls' parameter to the update request to get it working. Not mentioned in the documentation -.-