CUCM AXL getPhone missing "roamingDevicePoolName"

[michalkaska99]

Hallo,

I am trying to retrieve from CallManager an information about roaming device pool name of the IP Phone.

I use two functions

1, listPhone

2, getPhone

in AXL schema, both have described, that "roamingDevicePoolName" is one of the returned tags. Unfortunately, when I use getPhone, I completely miss the "roamingDevicePoolName" in CUCM answer whin in listPhone is this tag successfuly delivered.

I triyed schema 10.0, 10.5, 11.0, 11.5. All with identical behavior. CallManager is version 11.5.

Have anybody experience in getting this roaming information using the getPhone function?

IN getPhone function i used request with returnedtags specifiet and also without. I retreived all parameters except this one

Any help is apreciated.

<?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/11.5"><SOAP-ENV:Body><ns1:getPhone><name>SEPE0899DFB26DF</name><returnedTags uuid="1"><name>1</name><description>1</description><product>1</product><model>1</model><devicePoolName>1</devicePoolName><loadInformation>1</loadInformation><geoLocationName>1</geoLocationName><userLocale>1</userLocale><roamingDevicePoolName>1</roamingDevicePoolName></returnedTags></ns1:getPhone></SOAP-ENV:Body></SOAP-ENV:Envelope>

2017-05-12 14:18:07,433 DEBUG [http-bio-443-exec-11] servletRouters.AXLAlpha - Request processed by AXIS

2017-05-12 14:18:07,438 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - dbConnector Initialization in handler.java

2017-05-12 14:18:07,439 DEBUG [http-bio-443-exec-11] axlapiservice.Axl - Connection given to current thread

2017-05-12 14:18:07,439 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - getPkid Query is :select pkid from Device where my_lower(name ) =my_lower('SEPE0899DFB26DF' )

2017-05-12 14:18:07,465 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - pkid: 893857fb-425b-48a9-a791-91521650eb5f and query: SELECT Device.*,CallingSearchSpace_7.name as CallingSearchSpacename7,DevicePool_8.name as DevicePoolname8,CommonDeviceConfig_9.name as CommonDeviceConfigname9,CommonPhoneConfig_10.name as CommonPhoneConfigname10,Location_12.name as Locationname12,MediaResourceList_13.name as MediaResourceListname13,CallingSearchSpace_16.name as CallingSearchSpacename16,AARNeighborhood_17.name as AARNeighborhoodname17,MlppDomain_22.id as MlppDomainname22,SecurityProfile_27.name as SecurityProfilename27,SecurityProfile_27.tkkeysize as keySize, SecurityProfile_27.tkauthenticationmode as authenticationMode, SecurityProfile_27.tkeckeysize as ecKeySize, SecurityProfile_27.tkkeyorder as keyOrder, SIPProfile_28.name as SIPProfilename28,CallingSearchspace_29.name as CallingSearchspacename29,CallingSearchspace_30.name as CallingSearchspacename30,GeoLocation_31.name as GeoLocationname31,GeoLocationFilter_32.name as GeoLocationFiltername32,ElinGroup_33.name as ElinGroup33,PhoneTemplate_38.name as PhoneTemplatename38, PhoneTemplate_38.numOfButtons as numOfButtons, Device_43.name as Devicename43,SoftkeyTemplate_62.name as SoftkeyTemplatename62,Device_64.name as Devicename64,ExtensionMobilityDynamicTableName.fkdevice_currentloginprofile,ExtensionMobilityDynamicTableName.loginTime, ExtensionMobilityDynamicTableName.loginDuration,PhoneTemplate_71.name as PhoneTemplatename71,MlppDomain_72.id as MlppDomainname72,SoftkeyTemplate_75.name as SoftkeyTemplatename75,CallingSearchspace_105.name as CallingSearchspacename105,CallingSearchspace_106.name as CallingSearchspacename106,Matrix_108.name as Matrixname108,EndUser_127.userid as EndUsername127,EndUser_127.pkid as EndUserPkid127,EndUser_128.userid as EndUsername128,EndUser_128.pkid as EndUserPkid128,DialRules_134.name as DialRulesname134,DPD.tkStatus_CallinfoPrivate FROM Device, OUTER CALLINGSEARCHSPACE callingsearchspace_7, OUTER DEVICEPOOL devicepool_8, OUTER COMMONDEVICECONFIG commondeviceconfig_9, OUTER COMMONPHONECONFIG commonphoneconfig_10, OUTER LOCATION location_12, OUTER MEDIARESOURCELIST mediaresourcelist_13, OUTER CALLINGSEARCHSPACE callingsearchspace_16, OUTER AARNEIGHBORHOOD aarneighborhood_17, OUTER MLPPDOMAIN mlppdomain_22, OUTER SECURITYPROFILE securityprofile_27, OUTER SIPPROFILE sipprofile_28, OUTER CALLINGSEARCHSPACE callingsearchspace_29, OUTER CALLINGSEARCHSPACE callingsearchspace_30, OUTER GEOLOCATION geolocation_31, OUTER GEOLOCATIONFILTER geolocationfilter_32, OUTER ELINGROUP ElinGroup_33, OUTER PHONETEMPLATE phonetemplate_38, OUTER DEVICE device_43, OUTER SOFTKEYTEMPLATE softkeytemplate_62, OUTER DEVICE device_64, OUTER ExtensionMobilityDynamic ExtensionMobilityDynamicTableName, OUTER PHONETEMPLATE phonetemplate_71, OUTER MLPPDOMAIN mlppdomain_72, OUTER SOFTKEYTEMPLATE softkeytemplate_75, OUTER CALLINGSEARCHSPACE callingsearchspace_105, OUTER CALLINGSEARCHSPACE callingsearchspace_106, OUTER MATRIX matrix_108, OUTER ENDUSER enduser_127,OUTER ENDUSER enduser_128, OUTER DIALRULES dialrules_134,OUTER DevicePrivacyDynamic DPD WHERE callingsearchspace_7.pkid = Device.fkcallingsearchspace and devicepool_8.pkid = Device.fkdevicepool and commondeviceconfig_9.pkid = Device.fkcommondeviceconfig and commonphoneconfig_10.pkid = Device.fkcommonphoneconfig and location_12.pkid = Device.fklocation and mediaresourcelist_13.pkid = Device.fkmediaresourcelist and callingsearchspace_16.pkid = Device.fkcallingsearchspace_aar and aarneighborhood_17.pkid = Device.fkaarneighborhood and mlppdomain_22.pkid = Device.fkmlppdomain and securityprofile_27.pkid = Device.fksecurityprofile and sipprofile_28.pkid = Device.fksipprofile and callingsearchspace_29.pkid = Device.fkcallingsearchspace_cgpntransform and callingsearchspace_30.pkid = Device.fkCallingSearchSpace_CgpnIngressDN and geolocation_31.pkid = Device.fkgeolocation and geolocationfilter_32.pkid = Device.fkgeolocationfilter_lp and ElinGroup_33.pkid = Device.fkELINGroup and phonetemplate_38.pkid = Device.fkphonetemplate and device_43.pkid = Device.ikdevice_primaryphone and softkeytemplate_62.pkid = Device.fksoftkeytemplate and device_64.pkid = Device.ikdevice_defaultprofile and Device.pkid = ExtensionMobilityDynamicTableName.fkdevice and phonetemplate_71.pkid = Device.fkphonetemplate and mlppdomain_72.pkid = Device.fkmlppdomain and softkeytemplate_75.pkid = Device.fksoftkeytemplate and callingsearchspace_105.pkid = Device.fkcallingsearchspace_restrict and callingsearchspace_106.pkid = Device.fkcallingsearchspace_reroute and matrix_108.pkid = Device.fkmatrix_presence and  enduser_127.pkid = Device.fkenduser_mobility and enduser_128.pkid = Device.fkenduser and dialrules_134.pkid = Device.fkdialrules and DPD.fkDevice=Device.pkid and Device.pkid = ?

2017-05-12 14:18:07,509 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - select * from Telecaster where fkdevice='893857fb-425b-48a9-a791-91521650eb5f'

2017-05-12 14:18:07,516 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='569'  and tkdeviceprotocol in ('11',99)

2017-05-12 14:18:07,518 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 120

2017-05-12 14:18:07,518 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 114

2017-05-12 14:18:07,519 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 114

2017-05-12 14:18:07,519 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 supports feature 116

2017-05-12 14:18:07,526 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - Select userid from enduser where pkid = (select fkenduser from extensionmobilitydynamic where fkdevice ='893857fb-425b-48a9-a791-91521650eb5f')

2017-05-12 14:18:07,530 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - SELECT fkWiFiHotspotProfile,WiFiHotspotProfile.name AS wifi_name FROM device, OUTER WiFiHotspotProfile WHERE device.fkWiFiHotspotProfile = WiFiHotspotProfile.pkid AND device.pkid ='893857fb-425b-48a9-a791-91521650eb5f'

2017-05-12 14:18:07,532 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - SELECT fkwirelesslanprofilegroup,wirelessLanprofileGroup.name AS wireless_name FROM device, OUTER wirelessLanprofileGroup WHERE device.fkwirelesslanprofilegroup = wirelessLanprofileGroup.pkid AND device.pkid ='893857fb-425b-48a9-a791-91521650eb5f'

2017-05-12 14:18:07,537 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 supports feature 116

2017-05-12 14:18:07,539 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - select loadinformation from defaults where tkmodel =684 and tkdeviceprotocol in (11,99)

2017-05-12 14:18:07,542 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 120

2017-05-12 14:18:07,542 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 114

2017-05-12 14:18:07,544 DEBUG [http-bio-443-exec-11] axlapiservice.Handler - Product 569 does not support feature 114

2017-05-12 14:18:07,545 INFO  [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - Checking Capf fields for partial response

2017-05-12 14:18:07,545 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - select requirethirdpartyregistration,blockincomingcallswhenroaming,homenetworkid from  IMSIntegratedMobile where fkdevice='893857fb-425b-48a9-a791-91521650eb5f'

2017-05-12 14:18:07,550 DEBUG [http-bio-443-exec-11] axlapiservice.GetPhoneHandler - GetPhone completed

2017-05-12 14:18:07,555 DEBUG [http-bio-443-exec-11] axlapiservice.Axl - Connection closed and hashmap entry removed in AXL.java closing connection

2017-05-12 14:18:07,568 DEBUG [http-bio-443-exec-11] servletRouters.AXLAlpha - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns:getPhoneResponse xmlns:ns="http://www.cisco.com/AXL/API/11.5"><return><phone ctiid="21" uuid="{893857FB-425B-48A9-A791-91521650EB5F}"><name>SEPE0899DFB26DF</name><description>Auto 1009</description><product>Cisco 8851</product><model>Cisco 8851</model><devicePoolName uuid="{AA221EE4-6172-9E38-0D09-DC439C7EB23A}">DP_AutoReg</devicePoolName><loadInformation special="false">sip88xx.11-5-1-18</loadInformation><geoLocationName uuid="{047047BF-EDD8-8C49-1873-80C23779767B}">GEO_test100</geoLocationName><userLocale /></phone></return></ns:getPhoneResponse></soapenv:Body></soapenv:Envelope>

2017-05-12 14:18:07,568 DEBUG [http-bio-443-exec-11] servletRouters.AXLAlpha - Finished processing request

2017-05-12 14:18:07,569 INFO  [http-bio-443-exec-11] filters.TimingFilter - Request 1493202826812 received from axl at ip 10.8.42.160 was processed in 141ms

2017-05-12 14:18:08,009 DEBUG [http-bio-443-exec-22] filters.TimingFilter - Received request 1493202826813 from axl at IP 10.8.42.160

2017-05-12 14:18:08,009 DEBUG [http-bio-443-exec-22] wrappers.RequestHeaderWrapper - Inside Request Header Wrapper

2017-05-12 14:18:08,009 DEBUG [http-bio-443-exec-22] filters.AuthenticationFilter - Operation:executeSQLQuery api:executeSQLQuery

2017-05-12 14:18:08,009 DEBUG [http-bio-443-exec-22] filters.ThrottlingFilter - Successfully set the value of counter: 4 value: 0

2017-05-12 14:18:08,011 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - Checking request version [11.5]

2017-05-12 14:18:08,012 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - Checking if requested api [executeSQLQuery] the implementedHandlers list

2017-05-12 14:18:08,012 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - [executeSQLQuery] is not in the implementedHandlers list

2017-05-12 14:18:08,012 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - Checking if version is 8.x

2017-05-12 14:18:08,012 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - function to check if the version is 8.x

2017-05-12 14:18:08,013 DEBUG [http-bio-443-exec-22] servletRouters.AXLAlpha - version is not 8.x

2017-05-12 14:18:08,013 INFO  [http-bio-443-exec-22] servletRouters.AXLAlpha - Executing api: executeSQLQuery in axis

2017-05-12 14:18:08,014 DEBUG [http-bio-443-exec-22] wrappers.RequestNamespaceWrapper - Inside Request Wrapper

2017

[dstaudt]

The schema comment for roamingDevicePoolName says:

Read-only.Specifies the device pool being used if the device is roaming and the deviceMobility feature is enabled for it.

Can you confirm that the device has mobility configured, and is in fact roaming at the time of the test?  I tend to think the field should be returned anyway (though nil), however it could be possible that it's simply not returned if not roaming.

If so, then this would likely be considered a defect.  I would suggest opening a ticket with DevNet Developer Support so we can review logs and troubleshoot with you in detail: https://developer.cisco.com/site/devnet/support/

[michalkaska99]

Hallo,

thank you for reaction. I am comparing two AXL features listPhones and getPhones on the same CUCM and asking the same IP phone on this CUCM. Form the CUCM Configuration GUI, I can see, that DeviceMobility is enabled, and phone is in roaming location.

listPhone feature return the "roamingDevicePoolName" but getPhone miss this ket in its AXL response

So it seems there is a bug. I do not have any contract to open CDN ticket. In my application, I can do a workarounf using "listPhone" instead, but I opened this discussion to check, if is that really bug, ir If I do something incorect.

Michal

[dstaudt]

I have opened a tentative defect as CSCve44400 to investigate.

Note, you can open a DevNet ticket without a contract, if you'd like further details about the defect (e.g. if you may need an engineering special patch release.)

Cisco DevNet: DevNet Developer Support