02-10-2016 06:51 AM
Hi,
I'm sending the following <updatePhone> AXL request as usual, updating phone services:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Body>
<axl:updatePhone sequence="12" xmlns:axl="http://www.cisco.com/AXL/API/9.1">
<name>SEP88755651BC56</name>
<services>
<service>
<telecasterServiceName uuid="{80B3C4D0-DE22-6A7F-8A53-C09D82904E4F}"/>
<name>EM</name>
<url>http://192.168.5.18:8080/emapp/EMAppServlet?device=#DEVICENAME#&EMCC=#EMCC#</url>
<urlButtonIndex>0</urlButtonIndex>
<urlLabel/>
<urlLabelAscii/>
<serviceNameAscii>EM</serviceNameAscii>
<phoneService>Standard IP Phone Service</phoneService>
<phoneServiceCategory>XML Service</phoneServiceCategory>
<priority>50</priority>
</service>
</services>
</axl:updatePhone>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
But I get the following AXL error in response:
<axlmessage>Cannot insert a null into column (telecastersubscribedservice.urllabel).</axlmessage>
In the request, the service part is exactly the same as i get it from getPhone, the <urlLabel> is empty in the getPhoneResponse too.
I understood: if I remove the <urlLabel/> item, the update is successful.
However I'm a bit confused, since I'm pretty sure this was working for years now.
I did not find any changes related to this item in the AXL schema documentation.
Furthermore, also very strange: in the database neither telecastersubscribedservice.urllabel, nor telecastercubscribedservice.urllabelascii are nillable. Why is it problem for empty <urlLabel/>, but does not for <urlLabelAscii/> then?
Reproduced on version 9.1 and 10.5.
03-29-2016 10:06 AM
Hi Istvan,
First of all, try to send the body SOAP with imported values only.
See at the AXL scheme what do you can to remove at this moment.
http://developer.cisco.com/site/axl/documents/previous-versions/index.gsp
In addition, the urlLabel is a string value so try to replace there something like NULL or "".
04-20-2016 06:14 AM
Try it like this:
<services>
<service>
<telecasterServiceName uuid="{80B3C4D0-DE22-6A7F-8A53-C09D82904E4F}"/>NAME</telecasterServiceName>
<name>EM</name>
<url>http://192.168.5.18:8080/emapp/EMAppServlet?device=#DEVICENAME#&EMCC=#EMCC#</url>
<urlButtonIndex>0</urlButtonIndex>
<urlLabel>EM</urlLabel> or <urlLabel>""</urlLabel>
<urlLabelAscii/>
<serviceNameAscii>EM</serviceNameAscii>
<phoneService>Standard IP Phone Service</phoneService>
<phoneServiceCategory>XML Service</phoneServiceCategory>
<priority>50</priority>
</service>
</services>
</axl:updatePhone>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide