cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2096
Views
5
Helpful
10
Replies

addPhone: Security Profile is required for this device

stephan.steiner
Spotlight
Spotlight

I'm trying to add a device template to my CUCM using AXL. The device is based on an existing device, so all should be well (and of course I'm adapting the class appropriately).

Then I send of this (of course wrapped into the usual soap header)

<phone>

<name>TCTMTRATEMPLATE</name>

<description>template</description>

<product>Cisco Dual Mode for iPhone</product>

<class>Phone Template</class>

<protocol>SIP</protocol>

<protocolSide>User</protocolSide>

<userHoldMohAudioSourceId>1</userHoldMohAudioSourceId>

<vendorConfig>

<paramEditability>1</paramEditability>

<iPhoneCountryCode>CH</iPhoneCountryCode>

<cuetLevel>1</cuetLevel>

<cucmUseSipDigest>0</cucmUseSipDigest>

<cucmSipDigestUserName>wengerP</cucmSipDigestUserName>

<cucmCtiUserName>wengerp</cucmCtiUserName>

<dialViaOffice>0</dialViaOffice>

<cucmUseVoiceDialing>0</cucmUseVoiceDialing>

<cucmAddVoiceDialingNumberToFavorites>0</cucmAddVoiceDialingNumberToFavorites>

<emEnabled>0</emEnabled>

<cucmGSMHandoffPreference>1</cucmGSMHandoffPreference>

<ldapUseLDAPUserAuthentication>1</ldapUseLDAPUserAuthentication>

<ldapUseSSL>0</ldapUseSSL>

<dialerEmergencyNumbers>112,117,114,1414,1415</dialerEmergencyNumbers>

<Ringtone>0</Ringtone>

<videoCapability>1</videoCapability>

<reserved>configurationfile=jabber-config_iPhone.xml</reserved>

</vendorConfig>

<traceFlag>false</traceFlag>

<preemption>Disabled</preemption>

<mlppIndicationStatus>Off</mlppIndicationStatus>

<preemption>Disabled</preemption>

<lines>

<line>

<index>1</index>

<label>mtra</label>

<display/>

<dirn uuid="{E57E9586-9D32-400D-B2B8-1C1395C3A16D}"/>

<ringSetting>Ring</ringSetting>

<consecutiveRingSetting>Use System Default</consecutiveRingSetting>

<displayAscii/>

<mwlPolicy>Use System Policy</mwlPolicy>

<maxNumCalls>2</maxNumCalls>

<busyTrigger>1</busyTrigger>

<callInfoDisplay>

<callerName>true</callerName>

<callerNumber>false</callerNumber>

<redirectedNumber>false</redirectedNumber>

<dialedNumber>true</dialedNumber>

</callInfoDisplay>

<recordingFlag>Call Recording Disabled</recordingFlag>

<audibleMwi>Default</audibleMwi>

<speedDial/>

<partitionUsage>General</partitionUsage>

<missedCallLogging>true</missedCallLogging>

<recordingMediaSource>Gateway Preferred</recordingMediaSource>

</line>

</lines>

<phoneTemplateName uuid="{CFD9C6FB-B9FA-4A2B-935C-FC5E8A859F5D}">Standard Dual Mode for iPhone</phoneTemplateName>

<userLocale>English United States</userLocale>

<softkeyTemplateName uuid="{72F64050-7AD5-4B47-9BFA-5E9AD9CD4AA9}">Standard User</softkeyTemplateName>

<singleButtonBarge>Default</singleButtonBarge>

<joinAcrossLines>Off</joinAcrossLines>

<callInfoPrivacyStatus>Default</callInfoPrivacyStatus>

<ignorePresentationIndicators>false</ignorePresentationIndicators>

<dndOption>Call Reject</dndOption>

<dndRingSetting>Disable</dndRingSetting>

<dndStatus>false</dndStatus>

<alwaysUsePrimeLine>Default</alwaysUsePrimeLine>

<alwaysUsePrimeLineForVoiceMessage>Default</alwaysUsePrimeLineForVoiceMessage>

<callingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</callingSearchSpaceName>

<devicePoolName uuid="{A7358833-3F99-31C1-3F38-4860ED8EC6B8}">dp_Kloten</devicePoolName>

<commonPhoneConfigName uuid="{AC243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Common Phone Profile</commonPhoneConfigName>

<networkLocation>Use System Default</networkLocation>

<locationName uuid="{72FBF836-A981-0AA6-2931-CC352FE6ACF3}">Kloten</locationName>

<mediaResourceListName uuid="{BAEC0607-EB07-E851-41C1-3662F031D70E}">MRGL_LUPS</mediaResourceListName>

<networkHoldMohAudioSourceId>51</networkHoldMohAudioSourceId>

<useTrustedRelayPoint>Default</useTrustedRelayPoint>

<retryVideoCallAsAudio>true</retryVideoCallAsAudio>

<securityProfileName uuid="{5CD3A1A0-98B9-4A97-ACB0-B7A50E5C5076}">Cisco Dual Mode for iPhone - Standard SIP Non-Secure Profile</securityProfileName>

<sipProfileName uuid="{6F3DFB0D-2D1D-4346-BD7B-A38120405B3A}">Standard SIP Profile for Mobile Device</sipProfileName>

<useDevicePoolCgpnTransformationCss>true</useDevicePoolCgpnTransformationCss>

<sendGeoLocation>false</sendGeoLocation>

<ringSettingIdleBlfAudibleAlert>Default</ringSettingIdleBlfAudibleAlert>

<ringSettingBusyBlfAudibleAlert>Default</ringSettingBusyBlfAudibleAlert>

<networkLocale>Switzerland</networkLocale>

<enableExtensionMobility>false</enableExtensionMobility>

<builtInBridgeStatus>Off</builtInBridgeStatus>

<hlogStatus>Off</hlogStatus>

<packetCaptureMode>None</packetCaptureMode>

<packetCaptureDuration>0</packetCaptureDuration>

<hotlineDevice>false</hotlineDevice>

<subscribeCallingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</subscribeCallingSearchSpaceName>

<rerouteCallingSearchSpaceName uuid="{BC3B6B1C-ADF4-2B1D-F723-4A927AAFFE89}">css_all</rerouteCallingSearchSpaceName>

<allowCtiControlFlag>false</allowCtiControlFlag>

<presenceGroupName uuid="{AD243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Presence group</presenceGroupName>

<unattendedPort>false</unattendedPort>

<requireDtmfReception>false</requireDtmfReception>

<rfc2833Disabled>false</rfc2833Disabled>

<certificateOperation>No Pending Operation</certificateOperation>

<deviceMobilityMode>Default</deviceMobilityMode>

<remoteDevice>false</remoteDevice>

<isActive>true</isActive>

<isDualMode>true</isDualMode>

<phoneSuite>Default</phoneSuite>

<phoneServiceDisplay>Default</phoneServiceDisplay>

<isProtected>false</isProtected>

<mtpRequired>false</mtpRequired>

<mtpPreferedCodec>711ulaw</mtpPreferedCodec>

<outboundCallRollover>No Rollover</outboundCallRollover>

<deviceTrustMode>Not Trusted</deviceTrustMode>

<AllowPresentationSharingUsingBfcp>false</AllowPresentationSharingUsingBfcp>

<allowiXApplicableMedia>false</allowiXApplicableMedia>

<useDevicePoolCgpnIngressDN>true</useDevicePoolCgpnIngressDN>

<enableCallRoutingToRdWhenNoneIsActive>false</enableCallRoutingToRdWhenNoneIsActive>

</phone>

And CUCM replies

<?xml version='1.0' encoding='utf-8'?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<soapenv:Fault>

<faultcode>soapenv:Client</faultcode>

<faultstring>Security Profile is required for this device</faultstring>

<detail>

<axlError>

<axlcode>429</axlcode>

<axlmessage>Security Profile is required for this device</axlmessage>

<request>addPhone</request>

</axlError>

</detail>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Now hold on a minute, I say.. look at line 79 of the phone object I'm sending:

<securityProfileName uuid="{5CD3A1A0-98B9-4A97-ACB0-B7A50E5C5076}">Cisco Dual Mode for iPhone - Standard SIP Non-Secure Profile</securityProfileName>

Isn't that the security profile CUCM is complaining about?

So I figured.. perhaps there are different security profiles for phone templates.. so I went ahead and loaded one of my existing templates that I added using ccmadmin. And lo behold.. it contains the exact same line. Next step is downloading the AXL traces and checking what kind of query makes it chuck that up, but I suspect the error doesn't really reflect what is actually going on.

10 Replies 10

stephan.steiner
Spotlight
Spotlight

Here's the AXL log.. no idea why it doesn't pick up the security profile, but we can see that it doesn't get added to the sql insert query

2017-10-25 21:16:07,584 DEBUG [http-bio-443-exec-218] filters.TimingFilter - Received request 1505911705608 from sdkuser at IP 10.80.0.21

2017-10-25 21:16:07,585 DEBUG [http-bio-443-exec-218] wrappers.RequestHeaderWrapper - Inside Request Header Wrapper

2017-10-25 21:16:07,585 DEBUG [http-bio-443-exec-218] filters.AuthenticationFilter - Operation:add api:addPhone

2017-10-25 21:16:07,609 DEBUG [http-bio-443-exec-218] filters.ThrottlingFilter - DBLCNQueue Count: 0

2017-10-25 21:16:07,609 DEBUG [http-bio-443-exec-218] filters.ThrottlingFilter - Successfully set the value of counter: 4 value: 0

2017-10-25 21:16:07,609 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - Checking request version [11.5]

2017-10-25 21:16:07,609 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - Checking if requested api [addPhone] the implementedHandlers list

2017-10-25 21:16:07,610 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - [addPhone] is not in the implementedHandlers list

2017-10-25 21:16:07,610 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - Checking if version is 8.x

2017-10-25 21:16:07,610 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - function to check if the version is 8.x

2017-10-25 21:16:07,610 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - version is not 8.x

2017-10-25 21:16:07,611 INFO  [http-bio-443-exec-218] servletRouters.AXLAlpha - Executing api: addPhone in axis

2017-10-25 21:16:07,611 DEBUG [http-bio-443-exec-218] wrappers.RequestNamespaceWrapper - Inside Request Wrapper

2017-10-25 21:16:07,612 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - AXL REQUEST :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.5"><soapenv:Header/><soapenv:Body><ns:addPhone sequence="0"> <phone><name>TCTMTRATEMPLATE</name><description>template</description><product>Cisco Dual Mode for iPhone</product><class>Phone Template</class><protocol>SIP</protocol><protocolSide>User</protocolSide><userHoldMohAudioSourceId>1</userHoldMohAudioSourceId><vendorConfig><paramEditability>1</paramEditability><iPhoneCountryCode>CH</iPhoneCountryCode><cuetLevel>1</cuetLevel><cucmUseSipDigest>0</cucmUseSipDigest><cucmSipDigestUserName>wengerP</cucmSipDigestUserName><cucmCtiUserName>wengerp</cucmCtiUserName><dialViaOffice>0</dialViaOffice><cucmUseVoiceDialing>0</cucmUseVoiceDialing><cucmAddVoiceDialingNumberToFavorites>0</cucmAddVoiceDialingNumberToFavorites><emEnabled>0</emEnabled><cucmGSMHandoffPreference>1</cucmGSMHandoffPreference><ldapUseLDAPUserAuthentication>1</ldapUseLDAPUserAuthentication><ldapUseSSL>0</ldapUseSSL><dialerEmergencyNumbers>112,117,114,1414,1415</dialerEmergencyNumbers><Ringtone>0</Ringtone><videoCapability>1</videoCapability><reserved>configurationfile=jabber-config_iPhone.xml</reserved></vendorConfig><traceFlag>false</traceFlag><preemption>Disabled</preemption><mlppIndicationStatus>Off</mlppIndicationStatus><preemption>Disabled</preemption><lines/><phoneTemplateName uuid="{CFD9C6FB-B9FA-4A2B-935C-FC5E8A859F5D}">Standard Dual Mode for iPhone</phoneTemplateName><userLocale>English United States</userLocale><softkeyTemplateName uuid="{72F64050-7AD5-4B47-9BFA-5E9AD9CD4AA9}">Standard User</softkeyTemplateName><singleButtonBarge>Default</singleButtonBarge><joinAcrossLines>Off</joinAcrossLines><callInfoPrivacyStatus>Default</callInfoPrivacyStatus><ignorePresentationIndicators>false</ignorePresentationIndicators><dndOption>Call Reject</dndOption><dndRingSetting>Disable</dndRingSetting><dndStatus>false</dndStatus><alwaysUsePrimeLine>Default</alwaysUsePrimeLine><alwaysUsePrimeLineForVoiceMessage>Default</alwaysUsePrimeLineForVoiceMessage><callingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</callingSearchSpaceName><devicePoolName uuid="{A7358833-3F99-31C1-3F38-4860ED8EC6B8}">dp_Kloten</devicePoolName><commonPhoneConfigName uuid="{AC243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Common Phone Profile</commonPhoneConfigName><networkLocation>Use System Default</networkLocation><locationName uuid="{72FBF836-A981-0AA6-2931-CC352FE6ACF3}">Kloten</locationName><mediaResourceListName uuid="{BAEC0607-EB07-E851-41C1-3662F031D70E}">MRGL_LUPS</mediaResourceListName><networkHoldMohAudioSourceId>51</networkHoldMohAudioSourceId><useTrustedRelayPoint>Default</useTrustedRelayPoint><retryVideoCallAsAudio>true</retryVideoCallAsAudio><securityProfileName uuid="{5CD3A1A0-98B9-4A97-ACB0-B7A50E5C5076}">Cisco Dual Mode for iPhone - Standard SIP Non-Secure Profile</securityProfileName><sipProfileName uuid="{6F3DFB0D-2D1D-4346-BD7B-A38120405B3A}">Standard SIP Profile for Mobile Device</sipProfileName><useDevicePoolCgpnTransformationCss>true</useDevicePoolCgpnTransformationCss><sendGeoLocation>false</sendGeoLocation><ringSettingIdleBlfAudibleAlert>Default</ringSettingIdleBlfAudibleAlert><ringSettingBusyBlfAudibleAlert>Default</ringSettingBusyBlfAudibleAlert><networkLocale>Switzerland</networkLocale><enableExtensionMobility>false</enableExtensionMobility><builtInBridgeStatus>Off</builtInBridgeStatus><hlogStatus>Off</hlogStatus><packetCaptureMode>None</packetCaptureMode><packetCaptureDuration>0</packetCaptureDuration><hotlineDevice>false</hotlineDevice><subscribeCallingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</subscribeCallingSearchSpaceName><rerouteCallingSearchSpaceName uuid="{BC3B6B1C-ADF4-2B1D-F723-4A927AAFFE89}">css_all</rerouteCallingSearchSpaceName><allowCtiControlFlag>false</allowCtiControlFlag><presenceGroupName uuid="{AD243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Presence group</presenceGroupName><unattendedPort>false</unattendedPort><requireDtmfReception>false</requireDtmfReception><rfc2833Disabled>false</rfc2833Disabled><certificateOperation>No Pending Operation</certificateOperation><deviceMobilityMode>Default</deviceMobilityMode><remoteDevice>false</remoteDevice><isActive>true</isActive><isDualMode>true</isDualMode><phoneSuite>Default</phoneSuite><phoneServiceDisplay>Default</phoneServiceDisplay><isProtected>false</isProtected><mtpRequired>false</mtpRequired><mtpPreferedCodec>711ulaw</mtpPreferedCodec><outboundCallRollover>No Rollover</outboundCallRollover><deviceTrustMode>Not Trusted</deviceTrustMode><AllowPresentationSharingUsingBfcp>false</AllowPresentationSharingUsingBfcp><allowiXApplicableMedia>false</allowiXApplicableMedia><useDevicePoolCgpnIngressDN>true</useDevicePoolCgpnIngressDN><enableCallRoutingToRdWhenNoneIsActive>false</enableCallRoutingToRdWhenNoneIsActive></phone></ns:addPhone></soapenv:Body></soapenv:Envelope>

2017-10-25 21:16:07,612 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - Request processed by AXIS

2017-10-25 21:16:07,615 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - dbConnector Initialization in handler.java

2017-10-25 21:16:07,615 DEBUG [http-bio-443-exec-218] axlapiservice.Axl - Connection given to current thread

2017-10-25 21:16:07,615 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - In begin transaction of AXLCallflow and created pub connector

2017-10-25 21:16:07,616 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,617 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,617 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,618 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,618 DEBUG [http-bio-443-exec-218] axlapiservice.AddPhoneHandler - select tkModel from TypeProduct where typeproduct.enum='449'

2017-10-25 21:16:07,619 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='449'  and tkdeviceprotocol in ('11',99)

2017-10-25 21:16:07,620 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 116

2017-10-25 21:16:07,621 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchSpace where my_lower(name ) =my_lower('css_international' )

2017-10-25 21:16:07,622 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from DevicePool where my_lower(name ) =my_lower('dp_Kloten' )

2017-10-25 21:16:07,623 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 104

2017-10-25 21:16:07,623 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,623 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from CommonPhoneConfig where my_lower(name ) =my_lower('Standard Common Phone Profile' )

2017-10-25 21:16:07,624 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,625 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from Location where my_lower(name ) =my_lower('Kloten' )

2017-10-25 21:16:07,626 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from MediaResourceList where my_lower(name ) =my_lower('MRGL_LUPS' )

2017-10-25 21:16:07,627 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,628 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,629 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,630 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from PhoneTemplate where my_lower(name ) =my_lower('Standard Dual Mode for iPhone' )

2017-10-25 21:16:07,631 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - select enum from TypeUserLocale where name='English United States'

2017-10-25 21:16:07,631 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,632 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 18

2017-10-25 21:16:07,632 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from softkeyTemplate where my_lower(name ) =my_lower('Standard User' )

2017-10-25 21:16:07,633 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 79

2017-10-25 21:16:07,634 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 78

2017-10-25 21:16:07,634 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 53

2017-10-25 21:16:07,634 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,635 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,636 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,637 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,638 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchspace where my_lower(name ) =my_lower('css_international' )

2017-10-25 21:16:07,639 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchspace where my_lower(name ) =my_lower('css_all' )

2017-10-25 21:16:07,640 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - getPkid Query is :select pkid from Matrix where my_lower(name ) =my_lower('Standard Presence group' )

2017-10-25 21:16:07,640 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 120

2017-10-25 21:16:07,641 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 114

2017-10-25 21:16:07,641 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 114

2017-10-25 21:16:07,641 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,642 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,643 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:16:07,643 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,644 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:16:07,644 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,644 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 72

2017-10-25 21:16:07,645 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:16:07,645 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,645 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,646 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,647 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 63

2017-10-25 21:16:07,647 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,647 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,648 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:16:07,649 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - Product 449 does not support feature 144

2017-10-25 21:16:07,649 DEBUG [http-bio-443-exec-218] axlapiservice.Handler - insert into Device ( tkDeviceProtocol,tkPacketCaptureMode,fkMatrix_Presence,tkNetworkLocation,EnableiXChannel,tkStatus_MLPPIndicationStatus,tkProtocolSide,tkStatus_DeviceMobilityMode,DeviceLevelTraceFlag,fkPhoneTemplate,NetworkHoldMOHAudioSourceID,RFC2833Disabled,fkCallingSearchSpace,tkdevicetrustmode,tkStatus_AlwaysUsePrimeLineForVM,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,enableCallRoutingToRdWhenNoneIsActive,tkOutboundCallRollover,isprotected,remoteDevice,unattended_port,PacketCaptureDuration,fkMediaResourceList,AllowHotelingFlag,tkCertificateOperation,fkLocation,AllowCTIControlFlag,fkCommonPhoneConfig,pkid,tkStatus_UseTrustedRelayPoint,tkProduct,tkCountry,mTPRequired,fkCallingSearchspace_restrict,requireDTMFReception,tkRingSetting_DND,EnableBFCP,tkPhonePersonalization,fkDevicePool,tkSIPCodec_MTPPreferredOrigCodec,tkStatus_AlwaysUsePrimeLine,fkSIPProfile,UseDevicePoolCgpnIngressDN,tkPreemption,fkSoftkeyTemplate,SendGeoLocation,hotlinedevice,Description,tkstatus_joinacrosslines,ignorePI,Name,tkDndOption,retryVideoCallAsAudio,tkUserLocale,tkClass,tkPhoneServiceDisplay,UserHoldMOHAudioSourceID ) values ( '11','0','ad243d17-98b4-4118-8feb-5ff2e1b781ac','2','f','0','1','2','f','cfd9c6fb-b9fa-4a2b-935c-fc5e8a859f5d','51','f','9223fbd6-b942-5e41-ed4c-ad7e056c844d','0','2','bc3b6b1c-adf4-2b1d-f723-4a927aaffe89','0','f','0','f','f','f','0','baec0607-eb07-e851-41c1-3662f031d70e','f','1','72fbf836-a981-0aa6-2931-cc352fe6acf3','f','ac243d17-98b4-4118-8feb-5ff2e1b781ac','20925854-8db1-d1b4-0c2c-f07b4c623620','2','449','59','f','9223fbd6-b942-5e41-ed4c-ad7e056c844d','f','1','f','3','a7358833-3f99-31c1-3f38-4860ed8ec6b8','1','2','6f3dfb0d-2d1d-4346-bd7b-a38120405b3a','t','0','72f64050-7ad5-4b47-9bfa-5e9ad9cd4aa9','f','f','template','0','f','TCTMTRATEMPLATE','1','t','1','253','3','1' )

2017-10-25 21:16:07,784 ERROR [http-bio-443-exec-218] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info

2017-10-25 21:16:07,785 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - In rollback transaction and created pub connector

2017-10-25 21:16:07,786 DEBUG [http-bio-443-exec-218] axlapiservice.Axl - Connection closed and hashmap entry removed in AXL.java closing connection

2017-10-25 21:16:07,786 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - Rollback transaction connector object closed

2017-10-25 21:16:07,786 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - In AXL CAll Flow class, method getSOAPError

2017-10-25 21:16:07,787 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - checking typeDBErrors for sql exception name

2017-10-25 21:16:07,805 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - Setting soap fault

2017-10-25 21:16:07,806 DEBUG [http-bio-443-exec-218] axlapiservice.AXLCallFlow - Setting soap fault2

2017-10-25 21:16:07,810 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>Security Profile is required for this device</faultstring><detail><axlError><axlcode>429</axlcode><axlmessage>Security Profile is required for this device</axlmessage><request>addPhone</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

2017-10-25 21:16:07,810 DEBUG [http-bio-443-exec-218] servletRouters.AXLAlpha - Finished processing request

2017-10-25 21:16:07,810 INFO  [http-bio-443-exec-218] filters.TimingFilter - Request 1505911705608 received from sdkuser at ip 10.80.0.21 was processed in 226ms

And here's the exact same request, with slightly different device name and type phone instead of phone template and that passes just fine.

2017-10-25 21:25:00,671 DEBUG [http-bio-443-exec-221] filters.TimingFilter - Received request 1505911705622 from sdkuser at IP 10.80.0.21

2017-10-25 21:25:00,671 DEBUG [http-bio-443-exec-221] wrappers.RequestHeaderWrapper - Inside Request Header Wrapper

2017-10-25 21:25:00,703 DEBUG [http-bio-443-exec-221] filters.AuthenticationFilter - addToCache("sdkuser")

2017-10-25 21:25:00,704 DEBUG [http-bio-443-exec-221] filters.AuthenticationFilter - Operation:add api:addPhone

2017-10-25 21:25:00,723 DEBUG [http-bio-443-exec-221] filters.ThrottlingFilter - DBLCNQueue Count: 0

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] filters.ThrottlingFilter - Successfully set the value of counter: 4 value: 0

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - Checking request version [11.5]

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - Checking if requested api [addPhone] the implementedHandlers list

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - [addPhone] is not in the implementedHandlers list

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - Checking if version is 8.x

2017-10-25 21:25:00,724 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - function to check if the version is 8.x

2017-10-25 21:25:00,725 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - version is not 8.x

2017-10-25 21:25:00,725 INFO  [http-bio-443-exec-221] servletRouters.AXLAlpha - Executing api: addPhone in axis

2017-10-25 21:25:00,725 DEBUG [http-bio-443-exec-221] wrappers.RequestNamespaceWrapper - Inside Request Wrapper

2017-10-25 21:25:00,726 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - AXL REQUEST :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.5"><soapenv:Header/><soapenv:Body><ns:addPhone sequence="0"> <phone><name>TCTGUGUS</name><description>template</description><product>Cisco Dual Mode for iPhone</product><class>Phone</class><protocol>SIP</protocol><protocolSide>User</protocolSide><userHoldMohAudioSourceId>1</userHoldMohAudioSourceId><vendorConfig><paramEditability>1</paramEditability><iPhoneCountryCode>CH</iPhoneCountryCode><cuetLevel>1</cuetLevel><cucmUseSipDigest>0</cucmUseSipDigest><cucmSipDigestUserName>wengerP</cucmSipDigestUserName><cucmCtiUserName>wengerp</cucmCtiUserName><dialViaOffice>0</dialViaOffice><cucmUseVoiceDialing>0</cucmUseVoiceDialing><cucmAddVoiceDialingNumberToFavorites>0</cucmAddVoiceDialingNumberToFavorites><emEnabled>0</emEnabled><cucmGSMHandoffPreference>1</cucmGSMHandoffPreference><ldapUseLDAPUserAuthentication>1</ldapUseLDAPUserAuthentication><ldapUseSSL>0</ldapUseSSL><dialerEmergencyNumbers>112,117,114,1414,1415</dialerEmergencyNumbers><Ringtone>0</Ringtone><videoCapability>1</videoCapability><reserved>configurationfile=jabber-config_iPhone.xml</reserved></vendorConfig><traceFlag>false</traceFlag><preemption>Disabled</preemption><mlppIndicationStatus>Off</mlppIndicationStatus><preemption>Disabled</preemption><lines/><phoneTemplateName uuid="{CFD9C6FB-B9FA-4A2B-935C-FC5E8A859F5D}">Standard Dual Mode for iPhone</phoneTemplateName><userLocale>English United States</userLocale><softkeyTemplateName uuid="{72F64050-7AD5-4B47-9BFA-5E9AD9CD4AA9}">Standard User</softkeyTemplateName><singleButtonBarge>Default</singleButtonBarge><joinAcrossLines>Off</joinAcrossLines><callInfoPrivacyStatus>Default</callInfoPrivacyStatus><ignorePresentationIndicators>false</ignorePresentationIndicators><dndOption>Call Reject</dndOption><dndRingSetting>Disable</dndRingSetting><dndStatus>false</dndStatus><alwaysUsePrimeLine>Default</alwaysUsePrimeLine><alwaysUsePrimeLineForVoiceMessage>Default</alwaysUsePrimeLineForVoiceMessage><callingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</callingSearchSpaceName><devicePoolName uuid="{A7358833-3F99-31C1-3F38-4860ED8EC6B8}">dp_Kloten</devicePoolName><commonPhoneConfigName uuid="{AC243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Common Phone Profile</commonPhoneConfigName><networkLocation>Use System Default</networkLocation><locationName uuid="{72FBF836-A981-0AA6-2931-CC352FE6ACF3}">Kloten</locationName><mediaResourceListName uuid="{BAEC0607-EB07-E851-41C1-3662F031D70E}">MRGL_LUPS</mediaResourceListName><networkHoldMohAudioSourceId>51</networkHoldMohAudioSourceId><useTrustedRelayPoint>Default</useTrustedRelayPoint><retryVideoCallAsAudio>true</retryVideoCallAsAudio><securityProfileName uuid="{5CD3A1A0-98B9-4A97-ACB0-B7A50E5C5076}">Cisco Dual Mode for iPhone - Standard SIP Non-Secure Profile</securityProfileName><sipProfileName uuid="{6F3DFB0D-2D1D-4346-BD7B-A38120405B3A}">Standard SIP Profile for Mobile Device</sipProfileName><useDevicePoolCgpnTransformationCss>true</useDevicePoolCgpnTransformationCss><sendGeoLocation>false</sendGeoLocation><ringSettingIdleBlfAudibleAlert>Default</ringSettingIdleBlfAudibleAlert><ringSettingBusyBlfAudibleAlert>Default</ringSettingBusyBlfAudibleAlert><networkLocale>Switzerland</networkLocale><enableExtensionMobility>false</enableExtensionMobility><builtInBridgeStatus>Off</builtInBridgeStatus><hlogStatus>Off</hlogStatus><packetCaptureMode>None</packetCaptureMode><packetCaptureDuration>0</packetCaptureDuration><hotlineDevice>false</hotlineDevice><subscribeCallingSearchSpaceName uuid="{9223FBD6-B942-5E41-ED4C-AD7E056C844D}">css_international</subscribeCallingSearchSpaceName><rerouteCallingSearchSpaceName uuid="{BC3B6B1C-ADF4-2B1D-F723-4A927AAFFE89}">css_all</rerouteCallingSearchSpaceName><allowCtiControlFlag>false</allowCtiControlFlag><presenceGroupName uuid="{AD243D17-98B4-4118-8FEB-5FF2E1B781AC}">Standard Presence group</presenceGroupName><unattendedPort>false</unattendedPort><requireDtmfReception>false</requireDtmfReception><rfc2833Disabled>false</rfc2833Disabled><certificateOperation>No Pending Operation</certificateOperation><deviceMobilityMode>Default</deviceMobilityMode><remoteDevice>false</remoteDevice><isActive>true</isActive><isDualMode>true</isDualMode><phoneSuite>Default</phoneSuite><phoneServiceDisplay>Default</phoneServiceDisplay><isProtected>false</isProtected><mtpRequired>false</mtpRequired><mtpPreferedCodec>711ulaw</mtpPreferedCodec><outboundCallRollover>No Rollover</outboundCallRollover><deviceTrustMode>Not Trusted</deviceTrustMode><AllowPresentationSharingUsingBfcp>false</AllowPresentationSharingUsingBfcp><allowiXApplicableMedia>false</allowiXApplicableMedia><useDevicePoolCgpnIngressDN>true</useDevicePoolCgpnIngressDN><enableCallRoutingToRdWhenNoneIsActive>false</enableCallRoutingToRdWhenNoneIsActive></phone></ns:addPhone></soapenv:Body></soapenv:Envelope>

2017-10-25 21:25:00,726 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - Request processed by AXIS

2017-10-25 21:25:00,729 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - dbConnector Initialization in handler.java

2017-10-25 21:25:00,729 DEBUG [http-bio-443-exec-221] axlapiservice.Axl - Connection given to current thread

2017-10-25 21:25:00,730 DEBUG [http-bio-443-exec-221] axlapiservice.AXLCallFlow - In begin transaction of AXLCallflow and created pub connector

2017-10-25 21:25:00,730 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,731 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,731 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,732 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,733 DEBUG [http-bio-443-exec-221] axlapiservice.AddPhoneHandler - select tkModel from TypeProduct where typeproduct.enum='449'

2017-10-25 21:25:00,733 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - select tksupportsfeature, tkdeviceprotocol,param from ProductSupportsFeature where tkproduct='449'  and tkdeviceprotocol in ('11',99)

2017-10-25 21:25:00,734 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 116

2017-10-25 21:25:00,735 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchSpace where my_lower(name ) =my_lower('css_international' )

2017-10-25 21:25:00,736 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from DevicePool where my_lower(name ) =my_lower('dp_Kloten' )

2017-10-25 21:25:00,737 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 104

2017-10-25 21:25:00,737 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,737 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from CommonPhoneConfig where my_lower(name ) =my_lower('Standard Common Phone Profile' )

2017-10-25 21:25:00,738 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,739 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from Location where my_lower(name ) =my_lower('Kloten' )

2017-10-25 21:25:00,740 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from MediaResourceList where my_lower(name ) =my_lower('MRGL_LUPS' )

2017-10-25 21:25:00,741 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,742 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,742 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,743 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from SecurityProfile where my_lower(name ) =my_lower('Cisco Dual Mode for iPhone - Standard SIP Non-Secure Profile' )

2017-10-25 21:25:00,744 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from PhoneTemplate where my_lower(name ) =my_lower('Standard Dual Mode for iPhone' )

2017-10-25 21:25:00,745 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from PhoneTemplate where my_lower(name ) =my_lower('Standard Dual Mode for iPhone' )

2017-10-25 21:25:00,746 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - select enum from TypeUserLocale where name='English United States'

2017-10-25 21:25:00,747 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,748 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 18

2017-10-25 21:25:00,748 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from softkeyTemplate where my_lower(name ) =my_lower('Standard User' )

2017-10-25 21:25:00,749 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 79

2017-10-25 21:25:00,749 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 78

2017-10-25 21:25:00,749 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 53

2017-10-25 21:25:00,749 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,750 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,751 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,752 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,753 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchspace where my_lower(name ) =my_lower('css_international' )

2017-10-25 21:25:00,754 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from CallingSearchspace where my_lower(name ) =my_lower('css_all' )

2017-10-25 21:25:00,755 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - getPkid Query is :select pkid from Matrix where my_lower(name ) =my_lower('Standard Presence group' )

2017-10-25 21:25:00,756 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 120

2017-10-25 21:25:00,756 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 114

2017-10-25 21:25:00,756 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 114

2017-10-25 21:25:00,757 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,757 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,758 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:25:00,759 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,759 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:25:00,760 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,760 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 72

2017-10-25 21:25:00,760 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 supports feature 76

2017-10-25 21:25:00,761 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,761 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,762 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,762 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 63

2017-10-25 21:25:00,762 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,763 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,763 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Inside addTkdataAXIS utils part

2017-10-25 21:25:00,764 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 144

2017-10-25 21:25:00,765 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - insert into Device ( tkDeviceProtocol,tkPacketCaptureMode,fkMatrix_Presence,tkNetworkLocation,EnableiXChannel,tkStatus_MLPPIndicationStatus,tkProtocolSide,tkStatus_DeviceMobilityMode,DeviceLevelTraceFlag,fkPhoneTemplate,NetworkHoldMOHAudioSourceID,RFC2833Disabled,fkCallingSearchSpace,tkdevicetrustmode,tkStatus_AlwaysUsePrimeLineForVM,fkCallingSearchspace_reroute,tkStatus_BuiltInBridge,enableCallRoutingToRdWhenNoneIsActive,tkOutboundCallRollover,isprotected,remoteDevice,unattended_port,PacketCaptureDuration,fkMediaResourceList,AllowHotelingFlag,tkCertificateOperation,fkLocation,AllowCTIControlFlag,fkCommonPhoneConfig,pkid,tkStatus_UseTrustedRelayPoint,tkProduct,tkCountry,mTPRequired,fkCallingSearchspace_restrict,requireDTMFReception,tkRingSetting_DND,EnableBFCP,tkPhonePersonalization,fkDevicePool,tkSIPCodec_MTPPreferredOrigCodec,tkStatus_AlwaysUsePrimeLine,fkSIPProfile,UseDevicePoolCgpnIngressDN,tkPreemption,fkSoftkeyTemplate,SendGeoLocation,hotlinedevice,Description,tkstatus_joinacrosslines,ignorePI,Name,tkDndOption,retryVideoCallAsAudio,tkUserLocale,tkClass,tkPhoneServiceDisplay,UserHoldMOHAudioSourceID,fkSecurityProfile ) values ( '11','0','ad243d17-98b4-4118-8feb-5ff2e1b781ac','2','f','0','1','2','f','cfd9c6fb-b9fa-4a2b-935c-fc5e8a859f5d','51','f','9223fbd6-b942-5e41-ed4c-ad7e056c844d','0','2','bc3b6b1c-adf4-2b1d-f723-4a927aaffe89','0','f','0','f','f','f','0','baec0607-eb07-e851-41c1-3662f031d70e','f','1','72fbf836-a981-0aa6-2931-cc352fe6acf3','f','ac243d17-98b4-4118-8feb-5ff2e1b781ac','b21b7e6c-823b-dae7-4103-49522999efd7','2','449','59','f','9223fbd6-b942-5e41-ed4c-ad7e056c844d','f','1','f','3','a7358833-3f99-31c1-3f38-4860ed8ec6b8','1','2','6f3dfb0d-2d1d-4346-bd7b-a38120405b3a','t','0','72f64050-7ad5-4b47-9bfa-5e9ad9cd4aa9','f','f','template','0','f','TCTGUGUS','1','t','1','1','3','1','5cd3a1a0-98b9-4a97-acb0-b7a50e5c5076' )

2017-10-25 21:25:01,105 DEBUG [http-bio-443-exec-221] axlapiservice.AddPhoneHandler - xml has been converted

2017-10-25 21:25:01,106 DEBUG [http-bio-443-exec-221] axlapiservice.AddPhoneHandler - <paramEditability>1</paramEditability><iPhoneCountryCode>CH</iPhoneCountryCode><cuetLevel>1</cuetLevel><cucmUseSipDigest>0</cucmUseSipDigest><cucmSipDigestUserName>wengerP</cucmSipDigestUserName><cucmCtiUserName>wengerp</cucmCtiUserName><dialViaOffice>0</dialViaOffice><cucmUseVoiceDialing>0</cucmUseVoiceDialing><cucmAddVoiceDialingNumberToFavorites>0</cucmAddVoiceDialingNumberToFavorites><emEnabled>0</emEnabled><cucmGSMHandoffPreference>1</cucmGSMHandoffPreference><ldapUseLDAPUserAuthentication>1</ldapUseLDAPUserAuthentication><ldapUseSSL>0</ldapUseSSL><dialerEmergencyNumbers>112,117,114,1414,1415</dialerEmergencyNumbers><Ringtone>0</Ringtone><videoCapability>1</videoCapability><reserved>configurationfile=jabber-config_iPhone.xml</reserved>

2017-10-25 21:25:01,106 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - execute procedure dbWriteDeviceXML('b21b7e6c-823b-dae7-4103-49522999efd7','<paramEditability>1</paramEditability><iPhoneCountryCode>CH</iPhoneCountryCode><cuetLevel>1</cuetLevel><cucmUseSipDigest>0</cucmUseSipDigest><cucmSipDigestUserName>wengerP</cucmSipDigestUserName><cucmCtiUserName>wengerp</cucmCtiUserName><dialViaOffice>0</dialViaOffice><cucmUseVoiceDialing>0</cucmUseVoiceDialing><cucmAddVoiceDialingNumberToFavorites>0</cucmAddVoiceDialingNumberToFavorites><emEnabled>0</emEnabled><cucmGSMHandoffPreference>1</cucmGSMHandoffPreference><ldapUseLDAPUserAuthentication>1</ldapUseLDAPUserAuthentication><ldapUseSSL>0</ldapUseSSL><dialerEmergencyNumbers>112,117,114,1414,1415</dialerEmergencyNumbers><Ringtone>0</Ringtone><videoCapability>1</videoCapability><reserved>configurationfile=jabber-config_iPhone.xml</reserved>')

2017-10-25 21:25:01,113 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - update devicehlogdynamic set hlog='f' where fkDevice='b21b7e6c-823b-dae7-4103-49522999efd7'

2017-10-25 21:25:01,117 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - update deviceprivacydynamic set tkStatus_CallInfoPrivate='2' where fkDevice='b21b7e6c-823b-dae7-4103-49522999efd7'

2017-10-25 21:25:01,118 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - update dnddynamic set dndStatus='f' where fkDevice='b21b7e6c-823b-dae7-4103-49522999efd7'

2017-10-25 21:25:01,122 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - select fknumplan, numplanindex from devicenumplanmap where fkdevice = 'b21b7e6c-823b-dae7-4103-49522999efd7'

2017-10-25 21:25:01,124 DEBUG [http-bio-443-exec-221] axlapiservice.Handler - Product 449 does not support feature 1

2017-10-25 21:25:01,125 DEBUG [http-bio-443-exec-221] axlapiservice.AddPhoneHandler - AddPhone completed

2017-10-25 21:25:01,133 DEBUG [http-bio-443-exec-221] axlapiservice.AXLCallFlow - In commit transaction and created pub connector

2017-10-25 21:25:01,134 DEBUG [http-bio-443-exec-221] axlapiservice.Axl - Connection closed and hashmap entry removed in AXL.java closing connection

2017-10-25 21:25:01,134 DEBUG [http-bio-443-exec-221] axlapiservice.AXLCallFlow - Commit transaction connector object closed

2017-10-25 21:25:01,140 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns:addPhoneResponse xmlns:ns="http://www.cisco.com/AXL/API/11.5"><return>{B21B7E6C-823B-DAE7-4103-49522999EFD7}</return></ns:addPhoneResponse></soapenv:Body></soapenv:Envelope>

2017-10-25 21:25:01,140 DEBUG [http-bio-443-exec-221] servletRouters.AXLAlpha - Finished processing request

2017-10-25 21:25:01,140 INFO  [http-bio-443-exec-221] filters.TimingFilter - Request 1505911705622 received from sdkuser at ip 10.80.0.21 was processed in 469ms

Paul Giralt
Cisco Employee
Cisco Employee

There definitely appears to be a bug when adding a Phone Template. In 12.0, this does not work at all and UCM will return a SOAP Fault indicating "Invalid Value of Class". It appears that the behavior was changed by the fix for CSCva98980, but instead of fixing the ability to insert a template, it just blocks it entirely. Investigating to see if a more appropriate fix can be made...

I also implemented the same thing for UDPs and RDPs. Same problem for UDPs (well, slightly different .. see my other post), and no problems whatsoever with RDPs. RDP also being sort of a device (same table and all), it shows that it's not so hard. Give me the AXL source code and I'll provide a real fix. Can't be so hard to run the same code regardless of whether the type is a phone template or a phone.

Ticket has been filed: #2027. I assume that since tickets costs money there'll be a fix, not the lazy ass workaround of simply disabling this functionality.

Ha, don't count on it!

Does this work in 11.5 still?

As far as I can tell, yes. Not sure if the last time I tried I was still on SU3 or already on SU4 though.

Perfect, keen to try this out.  Where has this been my whole life.

The discussion is old but worth a reply: same bug is present in 11.5.1.16900-16 (SU5).

 

That's too bad because creating phone templates is one of the most slow operations to do via GUI.

Paul Giralt
Cisco Employee
Cisco Employee

Sorry this has taken so long. DE agrees this is a bug and the ability to insert a phone template should work. I've filed CSCvj04755 for this issue.

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: